You can use shortcut keys to quickly cut, copy, and paste cells.

If you select more than one row or column, the same number of rows or columns you selected is inserted in the worksheet.

You can split the worksheet window into horizontal or vertical panes, but not both.

Design view is helpful when you prepare a worksheet for printing.

By default, Excel is set to print pages in landscape orientation.

The Office Clipboard is a temporary storage area for up to ____ selections you copy or cut.

After you copy and paste, the ____ button appears next to the cell or range with the pasted item.

____ places the last item from the Clipboard into the cell or range selected in the worksheet.

To move cell contents, select the cell or range whose contents you want to move. Then, click the Cut button in the ____ group on the Home tab of the Ribbon.

To use the drag-and-drop method, select the cell or range you want to move or copy. Then, position the pointer on the top border of the selected cells. The pointer changes from a white cross to a  ____  arrow. To move the selected cells, drag them to a new location.

On the Home tab of the Ribbon, the ____ group includes buttons for inserting and deleting rows, columns, and cells.

To insert a row, click the ____ to select the row where you want the new row to appear. Then, click the Insert button in the Cells group on the Home tab.

To check the spelling in a worksheet, click the Review tab on the Ribbon, and then, in the ____ group, click the Spelling button.

If Excel incorrectly flags a word that you use frequently as a misspelling, you can add the word to a custom dictionary that resides on your computer by clicking the ____ button.

To change the margins of a worksheet, click the Page Layout tab on the Ribbon, and then, in the ____ group, click the Margins button.

Worksheets printed in ____ orientation are wider than they are long.

Excel inserts ____whenever it runs out of room on a page.

The simplest way to adjust page breaks in a worksheet is in ____.

____are designated rows and/or columns in a worksheet that print on each page.

A ____ is text that prints in the top margin of each page.

A ____ is text that prints in the bottom margin of each page.

FIGURE 3-1



Excel Case 3-1
Vanessa is learning how to split a worksheet window.  Please answer the questions below while referring to the figure above.

What should Vanessa do to start the process of splitting the window horizontally as it is shown in Figure 3-1?

To resize the panes, what should Vanessa do?

Excel Case 3-2
Ben is preparing his worksheet to print and is making adjustments to the margin and print area.  Please answer the questions below.

Ben wants to choose the margin style that will allow for a 1” margin on the top, bottom, and sides.  He would choose the preset margin layout that is called ____.

Ben had set a print area earlier and now he wants to print the entire worksheet.  To clear the print area, Ben would choose the Page Layout tab in the Page Setup group, click the ____ button, and then click Clear Print Area.