In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When that formula is copied to cell C7, the relative references in the formula change to _____.
A) =B6*C3
B) =B7*C4
C) =B8*C5
D) =B5*C2

Question

In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When that formula is copied to cell C7, the relative references in the formula change to _____.
A) =B6*C3 
B) =B7*C4 
C) =B8*C5 
D) =B5*C2

Quizplus · Accepted Answer

When a formula is copied to another cell, relative references change based on their position relative to the new location. In this case, the formula in cell C5 refers to B5 and C2, which are one row above and one column to the left. When copied to cell C7, the formula will refer to B7 and C4, which are one row above and one column to the left of the new location. Therefore, the correct answer is B, which shows the formula with the correct relative references for cell C7.

In the Accompanying Figure, the Original Formula =B5*C2 Works Correctly