When you copy a formula to a new cell, the original cell references are replaced with cell references that are in the same ____ position as those in the original formula.
A) relative
B) adjacent
C) absolute
D) exact

Question

Quizplus · Accepted Answer

Relative references change based on their position relative to the new cell, whereas absolute references always refer to the same cell. Adjacent and exact do not accurately describe how the cell references are changed when copying a formula.

When You Copy a Formula to a New Cell, the Original