Exam 29: Working With Multiple Worksheets and Workbooks

To unhide a worksheet, right-click any sheet tab, and then click Unhide on the shortcut menu.

To display data or formula results from one worksheet in another worksheet of the same workbook, you use a(n) ____________________ with a reference to another worksheet.

The Print option called Print ____ prints the worksheet that appears on-screen, or a group of selected worksheets.

Deleting does not permanently remove a worksheet and all its contents from the workbook.

What would be a circumstance where you would want to hide one of the worksheets within a workbook? How do you go about hiding a worksheet?

The formula =SUM(Sheet2:Sheet4!D12), adds the value from cell D12 in the Sheet2, Sheet3, and Sheet4 worksheets.

A(n) ____________________ mark separates the worksheet range from its cell or range reference.

When working with cell references, any change you make to the ____ cell also changes the value in the destination cell.

To delete a worksheet, you can right-click a sheet tab, click Delete on the shortcut menu, and then click ____________________ in the message box to delete a worksheet.

Case EX 7-1 Kristin wants to arrange multiple workbooks in a way where she can compare figures. Kristin wants to access the Arrange Windows dialog box. She clicks the ____ tab on the Ribbon, and then in the Window group, clicks the Arrange All button.

A 3-D reference lists the worksheet range, an exclamation point, and a cell or range.

To print all of the worksheets in the workbook, click Print Entire Workbook print option.

The Print option called Print ____ prints all of the worksheets in a workbook.

The ____________________ Print Area print option prints the entire worksheet, regardless of what print area is set for that worksheet.

To select multiple worksheets in a workbook, hold down the ____ key as you click the sheet tab of each worksheet you want to include in the group.

When the Move or Copy dialog box appears, click the To book arrow and click the workbook where you want to move or copy the selected worksheet. After you select the destination workbook, the names of all of its worksheets appear in the ____ sheet box.

Case EX 7-2 Ron wants to be able to distinguish one worksheet from another. He plans to rename the worksheets and change the color of the tabs. Ron now wants to change the tab color. He first right-clicks the sheet tab he wants to recolor, points to ____ on the shortcut menu, and then clicks the color he wants for the tab.

FIGURE EX 7-1 The area indicated by #3 in Figure EX 7-1 above is ____.

To insert a blank worksheet, click the Insert Cells tab next to the existing sheet tabs.