Microsoft Excel 2007
Validation and protection exercise
Average difficulty
This Microsoft Excel 2007 VALIDATION AND PROTECTION exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl EXCEL 2007 BUSINESS MODELLING course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.
Exercise: Country Info - Validation and Protection
A full answer to this exercise is provided as part of the training course!
| 1) | Download the files needed to start this exercise: exercise-853.zip (and click here if you experience any problems unzipping this file after downloading it). |
| 2) | Open the file in the folder above. |
You need to provide a drop-down list for the country
|
|
| 3) | Using data validation, ensure that a drop-down list is available for country selection. |
| 4) | Create a range called Country on the Info worksheet which will provide the list. |
| 5) | Formulae exist in the cells below, but you don't want anyone to be able to amend or view them. Apply the necessary protection to ensure this. |
Note that you cannot see the formula above.
|
|
| 6) | When you have validated and protected this sheet, save the file as Countries Locked Down. |
Thank you for showing an interest in this Excel 2007 Business Modelling training course! As mentioned above, full answers to this and other exercises are provided on the course. On all Wise Owl scheduled courses delegates can take away these model answers (together with their own efforts!) on a free USB stick.
