click below
click below
Normal Size Small Size show me how
Lesson 4 vocabulary
| Term | Definition |
|---|---|
| Absolute cell reference | does not change when copied or moved to a new cell |
| Formula | the equation used to calculate values in a cell |
| Manual calculation | lets you determine when Excel calculates the formulas |
| Mixed cell reference | cell references that contain both relative and absolute references |
| Operand | A constant or cell reference used in a formula |
| Operator | A symbol that indicates the type of calculation to perform on operands |
| Order of evalutaion | the sequence used to calculte the value of a formula |
| point-and-click method | allows you to point and click each cell in a formula rather than typing cell reference |
| relative cell reference | adjusts to its new location when copied or moved |
| sum button | makes adding long columns or rows of numbers simple to do |