Exam 25: Organizing the Worksheet

The drag-and-drop method is the slowest way to copy or move data short distances in a worksheet.

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

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.

The print area consists of the cells and ranges designated for printing.

The Transfer command pastes a row of cells into a column, or a column of cells into a row.

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

To help track down and correct spelling errors in a worksheet, you can use the Find command.

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

To freeze panes, on the View tab of the Ribbon, in the Window group, click the Freeze Panes button, and then click Freeze Panes.

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

Click the Ctrl+C keys to cut selected cells.

Click the Ctrl+C keys to ____ selected cells.

You can right-click a cell or selected range, and then click Insert on the shortcut menu to open the Insert dialog box.

Click the Ctrl+V keys to ____ the selected cells.

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

Case EX 3-1 Vanessa is learning how to split a worksheet window. What should Vanessa do to start the process of splitting a window horizontally?

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

To access the Clipboard task pane, click the Clipboard Dialog Box Launcher on the ____ tab of the Ribbon. The Clipboard task pane appears in a separate pane along the left side of the worksheet.

Please briefly describe the difference between portrait and landscape orientation, when each is used, and how to change the page orientation.

Case EX 3-1 Vanessa is learning how to split a worksheet window. To resize the panes, what should Vanessa do?