Exam 9: Excel Lesson 3: Organizing the Worksheet

When you ____________________ panes, you select which rows and/or columns of the worksheet remain visible on the screen as the rest of the worksheet scrolls.

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.

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

Pasting replaces any content already in the cell.

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

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