Microsoft Office
Validation and protection exercise
Average difficulty

This Microsoft Office VALIDATION AND PROTECTION exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl ADVANCED EXCEL course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: House price model - set data 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-162.zip (and click here if you experience any problems unzipping this file after downloading it).
2)	Apply validation so that you see the following message if you type in a ridiculously high house price in cell D7:
	£1,000,000 might be a sensible limit?
3)	Now apply validation so that if you type in a deposit of less than £10,000 in cell D8, you see this disturbing message:
	You can make your version more insulting if you like
4)	Apply validation so that a user of your model can only choose one of the regions held in the Regions worksheet:
	When you click in cell D5, a drop-down list should appear
5)	Now set protection, so that if you try to change any cell except those shown in yellow below you get an error message:
	First unprotect the cells shown, then protect the worksheet
6)	Save this workbook as Model with validation, and close it down.

Thank you for showing an interest in this Advanced Excel 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.

Return to the list of exercises for this topic