Excel 2003: Validation

The ticks indicate the suitability of resources for each Key Stage.

Resource

KS3

KS4

KS5

Click Here

Validation tasksheet 1

Students set up different types of spreadsheet validation

(subscription only)

 
 
tick
tick

download file

Task

download file

answers

click here

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

 

 
tick
tick

click here

task

 

 

 

 

 

 

 

Copyright © www.teach-ict.com