| A | B |
|---|
| spreadsheet functions | predefined formulas that perform calculations by using specific values |
| cell reference | indicates a cell's location and provides instructions for how cell data is copied or used in calculations |
| relative cell reference | cell value changes as the formula is copied |
| absolute cell reference | cell value remains static when copied to other locations |
| mixed cell reference | indicates the combination of an absolute cell and a relative cell |
| parentheses | control the order of operations |
| conditions or criteria | tell the function how to calculate the results and what data to use |
| Sum | adds the range of cells |
| Average (AVG) | determines the average of the range of cells |
| Maximim (MAX) | finds the highest number in the range of cells |
| Minimum (MIN) | finds the lowest number in the range of cells |
