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