A cell reference that changes when a formula is copied or moved is called a(n) ____ reference.
A)absolute
B)relative
C)formula
D)relational

Question

Quizplus · Accepted Answer

Relative references change their location based on the position of the cell in which they are copied or moved. This allows for ease of use when creating formulas that need to reference different cells in the same pattern. Absolute references, on the other hand, do not change their location and require manually updating each reference when copied or moved to a new location. Formula and relational are not options for cell references.

A Cell Reference That Changes When a Formula Is Copied