| A | B |
|---|
| Excel displays this button after the Paste button is clicked | Paste Options |
| when you use the mouse to move or copy cells | drag and drop |
| located on the shortcut menu, this command allows you to insert rows between rows that already contain data | Insert |
| located on the Insert gallery of the Insert button on the Ribbon, this command allows you to insert a single cell or range of cells | Cells |
| Excel displays the titles on the screen, no matter how far down you scroll | freeze titles |
| this function returns a number that corresponds to the system date and time beginning with December 31, 1899 | NOW |
| technique that keeps a cell reference constant when copying a formula or function | Absolute Cell Reference |
| what you do to a slice of a 3-D pie chart to make it stand out from the rest | offsetting |
| what you do to a slice of a 3-D pie chart to make it stand out from the rest | exploding |
| use this button on the View tab to magnify or shrink the appearance of a worksheet or chart | zoom |
| use this function if the value you want to assign to a cell is dependent on a logical test | IF function |
| use this button to decrease the indent by three spaces each time you click it | Decrease Indent button |
| the Copy button copies the contents and format of the source area to this | Office Clipboard |
| to freeze worksheet titles use this button on the View tab | Freeze Panes |
| A cell reference of $B17 is a(n) ____________ cell reference | mixed |
| after you use the Insert command on the shortcut menu to insert a row, you can press this key to keep inserting rows | F4 |
| the Goal Seeking command is located on this tab on the Ribbon | Data |
