| A | B |
|---|
| absolute cell reference | A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. Uses a dollar sign in front of the column and row markers in a cell address |
| calculation operator | Operators that specify the calculations to be performed |
| cell reference | A reference that identifies a cell’s location in the worksheet based on its row number and column letter |
| constant | A number or text value entered directly into a formula |
| external reference | A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook |
| formula | An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet |
| mixed cell reference | A cell reference that uses an absolute column or row reference, but not both |
| named range | A group of cells, and occasionally a single cell, with a designated name |
| nested parentheses | Parentheses inside of parentheses within a formula |
| operand | An element that identifies the values to be used in a calculation |
| order of operations | The rules Excel follows to calculate any formula that contains two or more operators |
| relative cell reference | A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell |
| scope | The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook |
| value | A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address |
| variable | A symbol or name that represents something else; it can be a cell address, a range of cells, and so on |
