Exam 6: Excel 2: Managing Multiple Worksheets and Workbooks

To manually ____________________ a link and see the new data values, click the Update Values button.

Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets.

What is an example of when you would use a template? Name at least three benefits of using a workbook template.

You can create a(n)____ reference by deleting the $ from the row reference in the cell reference $B$6.

A worksheet ____ is a collection of two or more selected worksheets.

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

A(n)template is a workbook with labels, formats, and formulas already built into it with data removed. _________________________

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

Case-Based Critical Thinking Questions Case 6-1 Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help. Finally, Simon asks Brooke what steps (if any)need to be taken to keep a destination file up-to-date if he updates a value in one of the source files. Which of the following statements by Brooke would be correct?

The worksheet range ____ references the worksheets, "Sheet1," "Sheet2," "Sheet3," and "Sheet4."

When the destination file is ____________________, and the source files are closed, the complete file path is included as part of the external reference formula that appears in the formula bar.

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

The default template places the formula results aligned to the ____ of a cell.

A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.

A workbook based on a specific template always displays the name of the template followed by the date.

To move a worksheet or worksheet group to another location in the same workbook, select the worksheets and then drag and drop them by the selected sheet ____.

Case-Based Critical Thinking Questions Case 6-2 Ryder has discovered the power of creating and viewing multiple workbooks. Ryder wants to use a layout in which the workbooks overlap each other with all the title bars visible. Ryder opens all of the workbooks, and then he clicks the View tab on the Ribbon and clicks the Arrange All button. What should he do next to obtain the desired layout?

Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.