click below
click below
Normal Size Small Size show me how
AR CBA Excel Lesson4
| Term | Definition |
|---|---|
| Operand | A constant (text or number) or cell reference used in a formula |
| Operator | A symbol that indicates the type of calculation to perform |
| Mixed cell reference | Cell references that contain both relative and absolute references |
| Absolute cell referrence | Does not change when copied or moved to a new cell |
| Relative cell reference | Adjusts to its new location when copied or moved |
| Formula | The equation used to calculate values in a cell |
| Manual caluculation | Lets you determine when Excel calculates the formulas |
| Order of evaluation | The sequence used to calculate the value of a formula |
| Point-and-click method | Allows you to point and click each cell in a formula rather than typing |
| Sum button | Makes adding long columns or rows of numbers simple to do |