Final answer:
A relative cell reference changes in relation to the formula's location and is indicated by the absence of a $ sign before the column and row references.
Step-by-step explanation:
The reference to a cell that changes in relation to the location of the formula is called a relative cell reference. When a formula is copied to other cells, a relative reference adjusts accordingly based on its new location.
For example, if you have a formula in cell B2 that references cell A1, the relative reference would be written as A1. When the formula is copied to cell B3, the reference automatically adjusts to A2.
Relative cell references are indicated by the absence of a $ sign before the column and row references. This allows formulas to be easily replicated and adapted to different locations.