An introduction to spreadsheets 3

This interactive resource is a visual introduction to spreadsheets for pupils studying at KS3 and above, and is a continuation of the two previous units at KS2. Individual parts of the resource can be used separately as required or the whole series can be used together to build up the ‘flooring’ spreadsheet. The spreadsheet deals with functions such as data validation, if statements, vlookup and countif.

Spreadsheetcellrowcolumnformulaedata validationif statementsvlookupcountif.