Exam 6: Excell: Managing Multiple Worksheets and Workbooks

What are the steps to inserting a hyperlink and linking to: a file or Web page, a location in the current workbook, a new document, and an e-mail address.

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

When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ____.

Click the button marked ____ in the accompanying figure to fix broken links.

To delete the hyperlink but keep the text, right-click the hyperlink cell, and then click ____ Hyperlink.

If you need to use data located in one workbook in the other workbook, you have to create a(n) ____ between the two workbooks.

To select adjacent worksheets, you use the ____ key.

A ____ is a workbook that you can open with the text, formats, and formulas already built into it.

Case-Based Critical Thinking Questions Case 6-2 Ryder has discovered the power of creating and viewing multiple workbooks. Ryder wants to use the workbooks he has created on another computer. What steps does he need to take?

A(n) ____ cell reference specifies not only the rows and columns of a cell range, but also the names of the worksheets on which the cells appear.

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?

When you click a(n) ____, the computer switches to the file or portion of the file that it references.

To ungroup worksheets, you can click a sheet ____ of a sheet not in the group.

If you trust the provider of source files, you can choose to ____ the content, which allows the external reference formulas to function and updates the links in the destination workbook.

The ____ caption indicates a worksheet group.

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.

In the Edit Links dialog box in the accompanying figure, ____ in the Update column indicates that links are updated automatically.

Some of the task-specific outlines available from the Office.com site include: Monthly Family Budget, Inventory List, and Time sheets.