The formula =C3+C4+C5 has been copied from cell C7 to cell E7. What will the…
2018
The formula =C3+C4+C5 has been copied from cell C7 to cell E7. What will the formula bar display when the cell selector is in cell E7?
- A.
=E3+E4+E5
- B.
=E4+E5+E6
- C.
=C7+D7+E7
- D.
=C3+C4+C5
Attempted by 25 students.
Show answer & explanation
Correct answer: A
Copying the formula from C7 to E7 moves it two columns to the right. Relative references C3, C4, and C5 become E3, E4, and E5.