A vertical range of cells referred to by a number.
A horizontal range of cells referred to by a number.
A vertical range of cells referred to by a letter.
\ (forward slash)
= (equal sign)
The cell reference automatically changes when the formula is copied down a column or across a row.
The cell uses the A1 reference style.
The cell reference is fixed or locked.
The formula is missing the math operator.
The column width is not wide enough to display the results.
You entered an invalid cell reference.
Ctrl + ~
Ctrl + F5
Ctrl + $
Here's an interesting quiz for you.