87.8k views
4 votes
Which best describes what happens when a formula is copied from one cell to another?

The cell references in the formula remain the same to match the cell that the formula is pasted into.
The cell references in the formula remain the same as they were in the original cell.
The cell references in the formula change to match the cell that the formula was copied from.
The cell references in the formula change to match the cell that the formula is pasted into.

1 Answer

4 votes

Answer:

The answer is B. The cell references in the formula remain the same as they were in the original cell.

Step-by-step explanation:

User Marcus Riemer
by
5.1k points