When cell D4 containing the formula =A4*B5 is copied to cell E2,the formula in cell E2 is ________.
A)=A4*B5
B)=B4*C5
C)=B2*C3
D)=A2*B3

Question

Quizplus · Accepted Answer

When cell D4 is copied to cell E2, the original formula is shifted over two columns and down two rows. So, the new formula in cell E2 should have the same relative position to its new row and column as the original formula did. Therefore, the correct formula in cell E2 should be =B2*C3.

When Cell D4 Containing the Formula =A4*B5 Is Copied to Cell