In Excel, relative references are indicated by the lack of a dollar sign character preceding either the column or the row reference.

Question

Quizplus · Accepted Answer

Relative references in Excel are indicated by the lack of a dollar sign character preceding either the column or the row reference. This allows the reference to change relative to the position of the formula when copied to different cells. Absolute references, on the other hand, have a dollar sign preceding the column and/or row reference, which means their value will not change when the formula is copied to different cells.

In Excel, Relative References Are Indicated by the Lack of a Dollar