When you define a range name for a cell in Excel, What does Excel automatically do with all formulas within your spreadsheet that refer to that cell?
1) Adjusts all formulas to use the range name
2) Deletes all formulas that refer to the cell
3) Leaves the formulas unchanged
4) Prompts you to update the formulas manually