click below
click below
Normal Size Small Size show me how
Excel Lesson 8 Terms
| Term | Definition |
|---|---|
| Absolute cell reference | A reference that does not change when a formula is copied or moved. |
| Arguments | A component of a function that is enclosed in parentheses. |
| Constant | A number or text value that is entered directly into a formula. |
| External reference | A cell or range on a worksheet in another Excel workbook, or a defined name in another workbook. |
| Formula | An equation that performs calculations on values in worksheet. |
| Function | A predefined formula that performs a calculation. |
| Mathematical operator | An element that specifies a calculation to be performed. |
| Mixed referfence | A reference in which one component is absolute and one is relative. |
| Name | A 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. |
| Operand | An element that identifies the value to be used in a calculation. |
| Reference | A component of a formula that identifies a cell or range of cells on a worksheet. |
| Relative cell reference | A reference that changes "relative" to the location where it is copied or moved. |
| Scope | The location within which Excel recognizes an item without qualification. |