When you copy a formula using the fill handle, Excel automatically replaces the original cell references with cell references that are in the same ____ position as those in the original formula.
A) absolute
B) approximate
C) relative
D) possible

Question

Quizplus · Accepted Answer

When copying a formula using the fill handle, Excel automatically replaces the references in the formula relative to the position of the cell being copied into. This means that the references in the copied formula will adjust to refer to cells that are in the same relative position as those in the original formula, but relative to the new location of the formula. This is known as relative referencing, and it allows formulas to be easily copied and applied to new sets of data without having to edit each formula individually.

When You Copy a Formula Using the Fill Handle, Excel