9.2.6: Validation


 I Love ValidationI Love ValidationI Love ValidationI Love Validation

Validation is without a doubt one of the most exciting things you can do in spreadsheet software like Excel.

We need to be able to use Validation to enter our questionnaire data quickly and efficiencently into the software.

Set up a Table – Using, Rows, Cells, Columns, Borders & Headings we will have somewhere to put our data.

Add Validation rules – Making it more difficult to put in wrong or too much data.

Add Input & Error messages – This lets us know what rules we are using and how to correct any mistakes we have made.

Input Device Quiz