click below
click below
Normal Size Small Size show me how
V-XL L04
Vocabulary Excel Lesson 4
Term | Definition |
---|---|
Absolute cell referance | A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address |
calculation operator | Operators that specify the calculations to be performed. |
cell reference | A reference that identifies a cell's location in the worksheet based on its row number and column letter. |
constant | A number or text value entered directly into a formula. |
external 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 addition, 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 within a formula. |
operand | An element that identifies the values to be used in a calculation. |
order of operations | The rules Excel follows to calculate any formula that contains two or more operators. |
relative cell reference | A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell. |
scope | The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook. |
value | A number, a cell address, a date, text, or Boolean data in Excel. 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. |