FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Excel 2: Managing Multiple Worksheets and Workbooks

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

Case-Based Critical Thinking Questions Case 6-1 Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help. Simon tells Brooke that when he attempts to open a workbook, the Edit Links dialog box appears with the message "This workbook contains one or more links that cannot be updated." Brooke suggests several possible causes of this error message. Which of the following is a possible cause?

A) one of the workbook's source files was edited
B) one of the workbook's source files was copied to a different folder
C) one of the workbook's source files was replaced with an updated file of the same name
D) the workbook was sent to him without links

E) None of the above
F) C) and D)

Correct Answer

verified

Show Answer

Question 2

Matching

Review LaterAdd Note

Review Later

Identify the letter of the choice that best matches the phrase or definition.

Premises

Responses

A connection between two files allowing information to be transferred from one file to the other

3-D

hyperlink

source

destination

worksheet group

link

Premises

A connection between two files allowing information to be transferred from one file to the other

Responses

3-D

hyperlink

source

destination

worksheet group

link

Show Answer

Correct Answer

Premises

Responses

3-D

hyperlink

source

destination

worksheet group

link

Premises

3-D

hyperlink

source

destination

worksheet group

link

Responses

Question 3

Short Answer

Review LaterAdd Note

After you have saved a template, you can access the template from the New screen in ____________________ view.

If the destination file is closed when you make a change in the ____ file, you can choose whether to update the link to display the current values when you open the destination file.

When the source and destination workbooks are stored in the same folder, you still need to include the location information in the workbook reference that links the two files.

All template files have a(n) ____ extension.

The ____ arrangement option layers the open workbooks on the screen.

Case-Based Critical Thinking Questions Case 6-3 Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file. Jared wants to create a hyperlink to a location in his current workbook. He clicks the Hyperlink button in the Links group on the Insert tab. What option should he select from the Link to list?

If a worksheet group includes all the worksheets in a workbook, you can edit only the active worksheet.

____ are usually represented by words with colored letters and underlines or images.

Identify the letter of the choice that best matches the phrase or definition.

All template files have the .xlts file extension.

When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.

If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be ____.

Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the group.

When two files are linked together, the ____________________ file receives the information.

In order to reference data located in one workbook in another workbook, you have to create a(n)dialog between the two workbooks. _________________________

When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference.

When you create a new workbook from a template, an unnamed copy of the template opens.

If you delete a value from one cell in a worksheet group, the content is also deleted from the same cell in all the worksheets in the group.