Q:

When you copy a formula-

• 1
  Excel deletes the original copy of the formula.
• 2
  Excel edits the cell reference in the newly copied formula.
• 3
  Excel adjusts the absolute cell reference.
• 4
  Excel does not adjust relative cell references