Back to lesson
1. When creating a range name, which scope is recommended in general?
It does not matter.
Workbook is recommended so that you do not create duplicate names which may cause confusion in Excel formula.
Worksheet specific range names are recommended since the more explicit the range name, the less confusion it causes end users.
2. What is a redundant range name?
This is a range name where the underlying cell reference(s) have been deleted giving rise to an #REF! error.
These are range names not used in a model.
These are range names not used by the end user.
3. Which Excel feature is key to deleting a range name?
Excel Name Manager
Excel Formula Bar
Excel Name Box
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement