Excel 2007: IF...Then, Nested IFs, IF OR, IF AND

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

Resource

KS3

KS4

KS5

Click Here

IF...Then Workbook

Explains step-by-step how to set up an IF...Then function.

Students are then given 4 further tasks to practice this skill

 
tick
tick
download filedownload file

School Tests Task

 
tick
tick
absolute cell reference video tutorial

Budget Task

 
tick
tick
absolute cell reference video tutorial

Concert Task

 
tick
tick
absolute cell reference video tutorial

Discounts Task

 
tick
tick

absolute cell reference video tutorial

task

absolute cell reference video tutorial

answers

The Lakeside Theatre Company

This task provides students with a number of opportunities to practice simple and complex IF statements

(subscription only)

 

 

 
tick
tick

download file

task

download file

spreadsheet

Count IFULA

This spreadsheet exercise provides students with an opportunity to practise:

  • IF formula
  • COUNTIF formula
  • COUNTA formula
  • COUNT formula
  • RANK formula

Extension tasks are provided

Contributed by Jon Bridgeman of Finham Park School

 

 
tick
tick

absolute cell reference video tutorial

task

 

Nested IFs, IF(OR), IF(AND)

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

Resource

KS3

KS4

KS5

Click Here

Tests Task

 
 
tick

absolute cell reference video tutorial

task

absolute cell reference video tutorial

answers

Cars, nested IF

 
 
tick

absolute cell reference video tutorial

task

Create a Multiple Choice Quiz

During this task, students will learn how to write nested if functions in order to create a multiple choice quiz which provides feedback based on the input answer.

The task sheet, quiz template and video tutorial are provided.

This task is probably better suited to higher ability students

(subscription only)

 
 
tick

download file

Task sheet

download file

Video tutorial and quiz spreadsheet

 

 

 

 

 

 

 

 

 

 

Copyright © www.teach-ict.com