click below
click below
Normal Size Small Size show me how
Excel Lesson 4
Term | Definition |
---|---|
Absolute Cell Reference | A cell reference that does not change when copied or moved to a new cell. |
Formula | An equation that calculates a new value from values currently in a worksheet. |
Manual Calculation | The option that lets you determine when Excel calculates formulas in the worksheet. |
Mixed Cell Reference | A cell reference that contains both relative and absolute references. |
Operand | A number or cell reference used in a formula. |
Operator | A symbol that indicates what mathematical operation to perform on the operands, such as a plus sign (+) for addition. |
Order of Evaluation | The sequence used to calculate the value of a formula. |
Point-and-Click Method | In a formula, to click a cell rather than type its cell reference. |
Relative Cell Reference | A cell reference that adjusts to its new location when copied or moved. |
Sum Button | A button on the Ribbon that inserts the SUM function to add long columns or rows of numbers. |