Q. In MS-Excel when you copy a formula

1. MS-Excel erases the original copy of the formula
2. MS-Excel edits cell references in the newly copied formula
3. MS-Excel adjusts absolute cell references
4. All of these