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