- How does cell reference affect calculations?
- How does absolute reference differ from relative cell reference?
First off, a cell reference saves you time by allowing you to include the values of other cells in formulas.
This is usually done by either typing the cell’s location directly or clicking on the cell after writing the equal sign (=).
There are two types of cell reference:
Relative reference is when you simply type the location of the cell or clicking on it after the equal sign. This is the default reference.
Absolute cell references do not change once a cell’s content is cut and pasted to another location. It can be applied to a column, row, or both. The dollar sign ($) is an indication that absolute cell reference is used.
Because a cell reference is used to avoid writing the same data again, a formula with incorrect cell references would be catastrophic.