| A | B |
| Go To Command | F5 |
| Preset conditions | defaults |
| Horizontal Portions of spreadsheet | rows |
| Formulas begin with | = |
| Worksheet used to calculate data | spreadsheet |
| Vertical portions of spreadsheet | columns |
| To get to A1 | Control + Home |
| Numbers align | right |
| Layout used to present spreadsheet data attractively | format |
| Defined area of a spreadsheet | range |
| Placement of data either left, right or centered | alignment |
| Built in formulas | function |
| Single location on a spreadsheet | cell |
| Columns are indicated by | letters |
| A column letter and row number | cell address |
| Arranging data in ascending or descending order | sort |
| Cell addresses separated by mathematical operators | formula |
| Reproducing data from one cell to another | copying |
| Changing the contents of an active cell | editing |
| Location on spreadsheet that displays contents of an active cell | formula bar |
| Used to find the average | =AVERAGE |
| Used to find the lowest number | =MIN |
| Used to find the highest number | =MAX |
| Used to add numbers | =SUM |
| Formula to find the number of products | =COUNT |
| Text align | left |