Exam 9: Excel Lesson 3: Organizing the Worksheet

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

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

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.

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

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

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

Headers and footers are each divided into three sections, which you can use to organize the text.

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

FIGURE EX 3-1 The area marked with the number 3 in Figure EX 3-1 above, shows ____scrolled out of view.

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

Case EX 3-2 Ben is preparing his worksheet to print and is making adjustments to the margin and print area. 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.

____________________ copies a cell's contents and/or formatting into an adjacent cell or range.

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

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

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.

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

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

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

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