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.
Please allow access to your computer’s microphone to use Voice Recording.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Your microphone is muted
For help fixing this issue, see this FAQ.