What type of cell referencing changes automatically when the formula is moved to a different location?

Relative cell referencing is a type of referencing in Excel that adjusts itself automatically when the formula containing the reference is moved to a different cell or copied to another location. This means if you have a formula that refers to a cell, and you move that formula elsewhere, the reference will change to reflect its new position relative to the source data.

For instance, if you have a formula in cell B1 that references cell A1, when you copy or drag this formula to cell B2, the reference will change to refer to A2, maintaining the same relative position. This automatic adjustment is crucial for performing calculations across various cells without needing to manually update each reference.

This behavior distinguishes relative references from other types such as absolute references, which do not change when moved, and mixed references, which can have fixed components. Static cell referencing, often not referenced explicitly in Excel terminology, conveys a similar concept to absolute references.