Spreadsheets - Data Validation

Objective:

To be able to
define data validation.
apply data validation checks in a spreadsheet

Task 1:

1. Observe the demonstration carefully.
2. Download the activity file from HERE.
3. Save the file in your folder in D drive.

Task 2 (2 Activities)

Activity 1:

• Apply the data validation checks as demonstrated.

Activity 2:

• Explore data validation dialogue box and apply the required data validation checks yourself.