10 terms

Excel Lesson 4: Entering Worksheet Formulas

Absolute cell reference
Does not change when copied or moved to a new cell.
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.
A constant (text or number) or cell reference used in a formula.
A symbol that indicates the type of calculation to perform on operands.
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
cell references.
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.