Exam 13: Excel Lesson 7: Working With Multiple Worksheets and Workbooks

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.

Moving a worksheet does not affect 3-D references in the workbook.

You can create a copy of a worksheet by pressing the ____ key as you drag and drop its sheet tab.

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

You can use a 3-D reference with 24 different functions.

The active workbook has all of the following EXCEPT: ____.

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

The Print option called Print ____ prints the range or ranges selected within a single worksheet.

A worksheet is a collection of workbooks.

In a worksheet range, as in a cell range, a ____ separates the names of the first worksheet and the last worksheet in the group.

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.

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.

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.

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

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?

To make a workbook active, just click ____.

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.

You designate the portion of the workbook to print on the Area tab in Backstage view.

Case EX 7-1 Kristin wants to arrange multiple workbooks in a way where she can compare figures. Kristin wants to move the February worksheet from the February Statement workbook to the Annual Statement workbook. She intends to place the February worksheet after the January worksheet in the Annual Statement workbook. What should she do?

Until ____ are named, they are identified as Sheet1, Sheet2, and so on.