How can we help?
You can also find more resources in our
Select a category
Something is confusing
Something is broken
I have a suggestion
What is your email?
What is 1 + 3?
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.
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.
Allows you to point and click each cell in a formula rather than typing
Relative cell reference
Adjusts to its new location when copied or moved.
Makes adding long columns or rows of numbers simple to do.