A spreadsheet developer enters the formula "=$B$9*B10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?
A) =$B$9*B10
B) =$B$9*C11
C) =C10*C11
D) =B9*B11
E) =$B$10*$B$11

Question

Quizplus · Accepted Answer

When the formula is copied and pasted into cell D2, the reference to the cell B10 will change to C11 because the formula was moved down one row and over one column. Therefore, the resulting formula in cell D2 will be =$B$9*C11.

A Spreadsheet Developer Enters the Formula "=$B$9*B10" into Cell C1