Question: If a range name is used in a formula and the name is deleted, what happens to the formula?

1. The formula display a warning but the actual cell address is substituted for the deleted name.
2. The formula becomes invalid and displays a #NAME? error.
3. The actual cell addresses replace the original range name in the formula.
4. The formula becomes invalid and displays a #N/A error

Answer: The correct answer of the above question is Option B:The formula becomes invalid and displays a #NAME? error.