| A | B |
|---|
| Formula | A mathematical equation that performs calculations on values in a worksheet. |
| Value | A representation in Excel that can be a number, a cell address, a date, text, or range of cells. |
| Constant | A number or text value that is entered directly into a cell. |
| Operator | An Indicator used to specify the type of calculation to take place, such as add (+), subtract (-), multiply (*), or divide (/). |
| Function | A pre-built command in Excel that performs mathematical operations such as automatically adding up a range of cells, or reviewing values to be used in calculations. |
| Order of operations | A standard mathematical process used to determine which operator to calculate first when evaluating a formula. |
| Cell reference | Identifies a cell’s location within a worksheet. |
| Relative cell reference | A cell or range reference in a formula that changes based upon the relation to the cell containing the formula. |
| Absolute cell reference | A cell reference in a formula that refers to a specific cell or range regardless of where the formula is located in the worksheet. |
| Mixed cell reference | A cell or range in a formula that uses both a relative and absolute reference. |
| Named range | A single cell or group of cells in an Excel worksheet with a designated name. |
