| A | B |
| Absolute cell reference | Cell reference that does not adjust to the new cell location when copied or moved. |
| Formulas | Equation that calculates a new value from values currently on a worksheet. |
| Mixed cell reference | Cell reference containing both relative and absolute references. |
| Operand | Numbers or cell references used in calculations in the formulas of worksheets. |
| Operator | Tells Excel what to do with operands in a formula. |
| Order of Evaluation(Operation) | The sequence used to calculate the value of a formula. |
| Point-and-click-method | Constructs a cell formula in Excel by clicking on the cell you want to reference rather than typing the reference. |
| Relative cell reference | Cell reference that adjusts to a new location when copied or moved. |