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

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

The correct answer is:

• The formula becomes invalid and displays a #NAME? error.

🎓 Get all the latest and 100% correct LinkedIn Microsoft Excel Skill Quiz Answers