If the formula in B7 is copied to cell D7, which formula will display in the formula bar when D7 is selected?
A. =SUM(B3:B5)-B6
B. =SUM(C3:C5)-C6
C. =SUM(D3:D5)-B6
D. =SUM(D3:D5)-D6
Answer:D
If the formula in B7 is copied to cell D7, which formula will display in the formula bar when D7 is selected?
A. =SUM(B3:B5)-B6
 B. =SUM(C3:C5)-C6
 C. =SUM(D3:D5)-B6
 D. =SUM(D3:D5)-D6
