| A | B |
|---|
| external reference | cell or range on a worksheet in another Excel workbook, or a defined name in another workbook. |
| reference | component of a formula that identifies a cell or a range of cells on a worksheet. |
| arguments | component of a function that is enclosed in parentheses. |
| operand | element that identifies the value to be used in a calculation. |
| mathematical operator | element that specifies a calculation to be performed. |
| formula | equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet. |
| scope | location within which Excel recognizes an item without qualification. |
| name | meaningful and logical identifier that a user can apply to make it easier to understand the purpose of a cell reference, constant, formula, or table. |
| constant | number or text value that is entered directly into a formula. |
| function | predefined formula that performs a calculation. |
| mixed reference | reference in which one component is absolute and one is relative. |
| relative cell reference | reference that changes “relative” to the location where it is copied or moved. |
| absolute cell reference | reference that does not change when a formula is copied or moved. |
