A formula at cell D5 is =SUM(D1:D4). If the same formula is copied to cell E5, what would happen?
Answers
Answered by
4
Answer:
D5=D1:D4
E5=E1:E4
Answer
Answered by
0
Copying formula at cell D5 which is =SUM(D1:D4) to cell E5 will become =SUM(E1:E4)
Explanation:
- In Excel, while copying a formula, relative cell references will change. When copying a formula, Excel automatically adjusts the cell references for each new cell the formula is copied to.
- In Excel, to copy a formula, select cell, and press CTRL + c.
- In Excel, to paste this formula, select cell. and press CTRL + v.
Similar questions