When cell D4 containing the formula =$A4-B$5 is copied to cell E2,the formula in cell E2 is ________.
A)=$A4-B$5
B)=B4-C5
C)=$A2-C$5
D)=$A2-B$3

Question

Quizplus · Accepted Answer

When cell D4 =$A4-B$5 is copied to cell E2, the formula will adjust relative to its new position, resulting in =$A2-C$5 in cell E2. The row reference for A4 has changed from 4 to 2, and the column reference for B5 has changed from B to C.

When Cell D4 Containing the Formula =$A4-B$5 Is Copied to Cell