Question

A formula at cell D5 is =SUM(D1:D4). If the same formula is copied to cell E5, what would happen?​

Answer 1

Answer:

D5=D1:D4

E5=E1:E4

Answer

Answer 2

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.