Question

In MS Excel, when copying a formula to a new cell,
(1) the original copy of the formula is erased.
(2) relative cell references are automatically adjusted in the newly copied cell.
(3) absolute cell references are adjusted automatically.
(4) relative cell references are not adjusted.

Answer 1

(2) relative cell references are automatically adjusted in the newly copied cell.

Answer 2

Answer:

What is the atmosphere in a few more things to the atmosphere of the answer is.