| A | B |
| Function | A predefined formula that performs a calculation |
| Sum | Adds all the numbers in a range of cells |
| Average | Adds a range of cells and then divides by the number of cell entries |
| Count | Counts the number of numeric entries in a range |
| Min | Returns the smallest value in a set of values |
| Max | Returns the largest value in a set of values |
| Argument | This can be a value, a cell reference, a range of cells, or even another function. |
| Formula | A formula is the equation used to calculate values in a cell |
| Cell Reference | A unique identifier for a cell which is formed by combining the cell's column letter and row number |
| Operator | A symbol that indicates the type of calculation to perform on the operands, such as a plus sign (+) for addition. |
| Operand | A constant (text or number) or cell reference used in a formula. |
| Order of Operations | The mathematical rules used for calculating the value of a formula |
| Absolute Cell Reference | Cell reference that does not adjust to the new cell location when copied or moved |
| Relative Cell Reference | Cell reference that adjusts to a new location when copied or moved |
| Mixed Cell Reference | A cell reference that contains both relative and absolute references |