Exam 6: Excel 2: Managing Multiple Worksheets and Workbooks

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

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

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.

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

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?

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

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

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

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?

All template files have the .xlts file extension.

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.

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

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

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

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 you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference.

All template files have a(n)____ extension.

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