| 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 |
| circulation operator | Operators that specify the calculations to be performed |
| cell reference | A reference that identifies a cell location in the worksheet based on its row number and column letter |
| constant | A number or text value entered directly into a formula |
| extrenal 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 additon, 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 with a formula. |
| operand | An element that identifies the values to be used in a circulation |
| order of operations | The rule Excel follows to calculate any formula that contains two or more operations. |
| relative cell reference | A cell reference that adjusts the clee identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell. |
| scope | The location within Excel recognizes a named range, which is either a specific worksheet or the entire workbook. |
| scope | If you set the scope of a named range to workbook, you can reference the name range on any sheet in the workbook. |
| value | A number, a cell address, a date, text, or Boolean data in Excel. |
| value | 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 |
