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. |