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

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.

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

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

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

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?

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

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

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

Each workbook opens with five worksheets.

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

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

You can reposition a worksheet by dragging its ____ to a new location.

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

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

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

The active sheet has a blue sheet tab.

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

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 ____.

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.