Exam 29: Working With Multiple Worksheets and Workbooks

To make a workbook active, just click ____.

You can tell which workbook is active by looking at its title. The active workbook has a ____ title bar.

A 3-D reference is a reference to the same cell or range in multiple worksheets that you use in a formula.

The active sheet has a blue sheet tab.

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?

To delete a worksheet, click the sheet tab for the worksheet you want to remove. On the Home tab of the Ribbon, in the ____ group, click the arrow to the right of the Delete button, and then click Delete Sheet.

To select more than one cell or range in a worksheet, select the first cell or range, hold down the Shift key, and select each additional cell or range.

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

A common workbook organization is to place sales data for each sales territory or region in its own worksheet, and then summarize the total sales in another worksheet.

A worksheet is a collection of workbooks.

When using the Arrange Windows dialog box, the ____ layout is NOT an option.

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

Each workbook opens with five worksheets.

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

To insert a worksheet, on the Home tab of the Ribbon, in the Cells group, click the arrow to the right of the Insert button, and then click ____.

When you reposition a worksheet, a placement ____________________ indicates the new location.

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

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

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. How does Ron go about renaming his worksheet?

To move or copy a worksheet, right-click the sheet tab of the worksheet you want to move or copy, and then click ____ on the shortcut menu.