A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.
A) mixed
B) absolute
C) relative
D) parameter

Question

Quizplus · Accepted Answer

A relative cell reference is the default reference type in Excel, which means that when copying a formula, it will adjust the reference to the cell relative to the current position of the copied formula. This allows for quicker and easier formula copying without having to manually adjust cell references.

A(n) ____ Cell Reference Tells Excel to Substitute New Cell