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.

In MS Excel, when copying a formula to a new cell,(1) the original cop

1.	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» 2nd..RELATIVE CELL refrences are AUTOMATICALLY ADJUSTED