When you copy a formula from cell A10 to cell B10, what happens to the cell references in the formula?
A) Excel places them on the Clipboard.
B) Excel changes the cell references in the copied formula to reflect the new location of the formula.
C) Excel bolds the cell references so you can change them.
D) Excel displays a button near the copied cell with options for handling the cell references.

Question

Quizplus · Accepted Answer

When you copy a formula from one cell to another, Excel automatically adjusts the cell references in the formula to reflect the new location of the formula. For example, if the original formula in cell A10 refers to cell A1, when you copy it to cell B10, the formula will automatically refer to cell B1. This is called relative referencing.

When You Copy a Formula from Cell A10 to Cell