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?
These are range names not used in a model.
These are range names not used by the end user.
This is a range name where the underlying cell reference(s) have been deleted giving rise to an #REF! error.
3. Which Excel feature is key to deleting a range name?
Excel Formula Bar
Excel Name Box
Excel Name Manager
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement