click below
click below
Normal Size Small Size show me how
Excel Lesson 4 Vocab
Vocabulary for MSIA Excel
| Term | Definition |
|---|---|
| Absolute Cell reference | A specific cell or range of cells regardless of where the formula is located in the worksheet. |
| Calculation Operator | Specify the calculations to be performed. |
| Cell reference | Identifies a cell's location in the worksheet based on its column letter and row number. |
| Constant | A number or text value that is entered directly into a formula. |
| External reference | A cell or range in a worksheet in another workbook or to a defined name in another workbook. |
| Formula | A set amount of operations used to make calculations with ease. |
| Mixed cell reference | A cell reference that uses an absolute column or row reference, but not both. |
| Named range | A group of cells that have a name. |
| Nested parentheses | Calculations are performed on formulas in the innermost set of parentheses, then left to right. |
| Operand | Identify the values to be used in calculation. |
| Order of operations | A specific order that is used to make calculations. |
| Relative cell reference | Cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows. |
| scope | Name without qualification. |
| Value | A number, cell address, a date, text, or Boolean (T/F) data. |
| Variable | A symbol or name that represents something else. |