_____ referencing is when you copy a formula to a new cell and Excel automatically replaces the original cell references with cell references that are in the same relative position as those in the original formula.
A) Relative cell
B) Absolute cell
C) Formula
D) Relational

Question

Quizplus · Accepted Answer

Relative referencing is a feature in Excel that allows you to copy a formula to a new cell and automatically adjust the cell references so that they refer to the correct cells relative to the new location of the formula. This is in contrast to absolute referencing, where the cell references remain fixed regardless of where the formula is copied. Formula and relational are not relevant to the concept of referencing in Excel.

_____ Referencing Is When You Copy a Formula to a New