India Exam Junction
[Clerk (Morning) Dec, 2021]
13. The formula in cell D5 is ‘=SUM(D1:D4)’. On Copying the formula of this cell to D9, The formula in D9 cell will be
=SUM(D1:D8)
=SUM(D5:D9)
=SUM(D1:D9)
=SUM(D5:D8)
Correct Answer :
=SUM(D5:D8)
Solution
When you copy a formula in Excel, the cell references are relative, meaning they adjust based on their new position. The original formula in D5 is =SUM(D1:D4). When you copy this formula to D9, the references adjust relative to the new position.
The original formula was summing the four cells above its position. Since D9 is four cells below D5, the formula adjusts to sum the four cells above D9. Therefore, the new formula in D9 will be:
=SUM(D5:D8)
So, the correct answer is =SUM(D5:D8)