Resource

KS3

KS4

KS5

Click Here

Validation tasksheet 1

Students set up different types of spreadsheet validation

(subscription only)

Task

answers

validation example.xls

Hogwarts 1 and 2

This spreadsheet exercise provides students with an opportunity to practise:

• setting up validation (task 1)
• lookup tables (task 2)

Extension tasks are provided

Contributed by Jon Bridgeman of Finham Park School