| A | B |
|---|
| Workbook | Single Excel file containing one or more worksheets. |
| Worksheet | Single report or tab in workbook. |
| Cell | Intersection of row and column. |
| Cell Address | Defined on column-by-row intersection (A1, C7, B10, etc.). |
| Active Cell | Cell currently displayed with a dark border. |
| Sizing | Button at bottom right of active window when restored. |
| To create new workbook: | Click Office Button, New, Blank Workbook or Press (Ctrl) + (N) |
| To switch between workbooks: | Click button on Taskbar, or On View tab, in Window group, click Switch Windows |
| Every workbook comes with | three worksheets by default |
| To close a workbook: | Click Office Button, Close |
| Use Save As to | save new document or to save existing document with new name or in new location |
| Use Save to | save changes to currently active file with existing name in existing location |
| 3 types of data entry in a Excel Worksheet are | Labels, Values and Formulas |
| Labels | Text entries appear exactly as entered (default to left aligned) |
| Values | Numeric values (default to right aligned) |
| Formulas | Composed of values, cell references, arithmetic operators or special functions |
| (Ctrl) + (Home) | Move to cell A1. |
| (Ctrl) + (Last) | Move to last cell in data. |
| Row | horizontal, left to right |
| Column | vertical, top to bottom |
| Ascending | A to Z, numbers arranged from the smallest to the largest |
| Descending | Z to A, numbers arranged from largest to the smallest |
