Back to lesson
1. When creating a range name, which scope is recommended in general?
Worksheet specific range names are recommended since the more explicit the range name, the less confusion it causes end users.
Workbook is recommended so that you do not create duplicate names which may cause confusion in Excel formula.
It does not matter.
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 Box
Excel Formula Bar
Excel Name Manager
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement