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

Question

Quizplus · Accepted Answer

Relative references are adjusted when a formula is copied and pasted to a new location. This is because the formula needs to refer to the correct cells in the new location. For example, if a formula in cell A1 refers to cell B1, and the formula is copied to cell C1, the formula will automatically adjust to refer to cell D1.

The Adjusted Cell References in a Copied and Pasted Formula