A relative reference keeps the relative positions of the formula and the cells it references ________.
A) synchronized
B) intact
C) absolute
D) asynchronous
E) referred to

Question

Quizplus · Accepted Answer

A relative reference adjusts its position based on its new location when copied or moved, keeping the positions of its references intact relative to the new location. It does not maintain a fixed position (absolute) or depend on a specific cell reference (referred to) for its calculation. Asynchronous does not apply to references.

A Relative Reference Keeps the Relative Positions of the Formula