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 PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

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