| A | B |
|---|
| Absolute Cell Reference | Cell references that DO NOT automatically change when copied and pasted. |
| AVERAGE | A spreadsheet function used to find the average of a range of cells. |
| Cell Data | Information in the cell of a spreadsheet |
| Cell Reference (Address) | indicates a cell’s location and provides instructions for how cell data is copied or used in calculations |
| Colon | Used in a cell range to mean “through” |
| Currency (money) | The specific cell format that would change 29.99 to $29.99. |
| Formula | Statements used in spreadsheets to perform mathematical calculations |
| Function | shortcuts for commonly used formulas |
| MAX | A spreadsheet function used to find the highest value in a range of cells. |
| MIN | A spreadsheet function used to find the lowest value in a range of cells. |
| Mixed Cell Reference | Cell reference where only part of the cell reference (the column letter or row number) is absolute. |
| Operators | Symbols representing mathematical operations |
| Page Break | Vertical and horizontal dashed lines on a spreadsheet |
| Range | A group of cells that are adject and form a rectangle when highlighted |
| Relative Cell Reference | Cell references that automatically change when the cell, formula or function is copied. |
| Repeated Pound Signs (##) | Indicates the column width in your spreadsheet is too narrow to accommodate the number in the cell |
| SUM | A spreadsheet function used to add (total) numbers in a cell range. |
| $N$10 | Example of an absolute cell reference |
| N10 | Example of a relative cell reference |
| $N10 | Example of a mixed cell reference |
