The adjusted cell references in a copied and pasted formula are called ____ cell references.
A) related
B) relative
C) pasted
D) alternative

Question

Quizplus · Accepted Answer

Relative cell references adjust automatically when a formula is copied and pasted to a new location. For example, if a formula in cell E5 references cell B2, when the formula is copied to cell F6, the reference will automatically adjust to C3. These adjusted cell references are known as relative cell references. The other choices do not accurately describe this concept.

The Adjusted Cell References in a Copied and Pasted Formula