Q. What will happen when you copy a formula?

A
Excel erases the original copy of the formula
B
Excel edits cell reference in the newly copied formula
C
Excel adjusts absolute cell references
D
Excel doesn't adjust relative cell refernces
Solution:

It’s important to be aware of what can happen to cell references, whether they are absolute or relative, when you move a formula by cutting and pasting it, or copy a formula by copying and pasting it.
When you copy a formula, the cell references may change based on the type of cell reference that you use.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!

    [honeypot honeypot-100]