A worksheet is a collection of workbooks.

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

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

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

You designate the portion of the workbook to print in the Print what section of the Print dialog box.

The active sheet has a ____ sheet tab.

To rename a worksheet, double-click its sheet tab, type the new name, and then press the ____ key.

To change the tab color of a worksheet, right-click the sheet tab you want to recolor, point to ____ on the shortcut menu, and then click the color you want for that tab.

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

____ the worksheet you want to hide, and then click Hide on the shortcut menu.

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

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

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

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

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

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

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

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 using the Arrange Windows dialog box, which layout is NOT an option? ____.

To make a workbook active, just click ____.

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.

FIGURE 7-1



Excel Case 7-1
Kristin wants to arrange multiple workbooks in a way where she can compare figures.  Please refer to the figure above as you answer the questions below.

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.

Kristin wants to move the February worksheet in the top half of the pane to the Annual Statement worksheet in the bottom half of the pane.  She intends to place the February worksheet after the January worksheet. What should she do?

Excel Case 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.  Please answer the questions below.

How does Ron go about renaming his worksheet?