| A | B |
|---|
| Fill Handle | The lower right hand corner of the active cell - allows you to copy or complete a series. |
| AutoFit | The feature that resized a column to fit the longest entry when you double click the column divider on the column header. |
| CTRL-1 | The shortcut key to bring up the Format Cells dialog box. |
| Merge & Center button | Will center a title over the selected area & combine the cells. |
| Left Aligned | The default alignment for text values. |
| Right Aligned | The defalut alignment for number values. |
| Operands | The values or references to cells in a formula or function. |
| Operators | The symbols that indicated the type of calculation that will take place in a formula. (+, -, *, /) |
| Ascending | The sort order which arranges values from the smallest value to the largest. |
| Descending | The sort order that arranges values from the largest to the smallest. |
| A large arrow pointer | The mouse pointer that is used to move or copy cell values using drag-n-drop. |
| CTRL | The key you hold while dragging to copy instead of move. |
| Relative | A reference type that when copied, the cell references change relative to the cell from which the formula is being copied. |
| Mixed | A reference type that always refers to either a specific row or a specific column. ($A1) Or (A$1) |
| Absolute | A reference type that always refers to a specific CELL. ($A$1) |
| Autocomplete | A feature of Excel that will fill in the rest of a word when you begin typing it - it if is already in the column. |
| Freeze Panes | A command in Excel that will allow you to scroll a large worksheet while still viewing the column & row headings. |
| SubTotal Command | A command on the Data menu that will allow you to add subtotals and create an Outline of large amounts of data in Excel. |
| Shift | Key that you hold while clicking tabs of sheets to select multiple ones to spell check. |
| Tools | Menu on which you can find the spell check command. |
