Excel 2010: Formulae and Functions

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

Basic formulae and functions

Resource

KS3

KS4

KS5

Click Here

Basic information about formulae

A one page help sheet that covers the very basics of writing formulae

 

tick
tick

download file

 

Basic Formulae Task

This task asks students to write a variety of different, basic formulae

(subscription only)

tick tick  
download file

task

Basic formula paper based task

A paper-based task. Could be used as a starter or gentle reminder about spreadsheet formula

 

tick
tick

download file

 

Basic Functions Task 1

This task asks students to write a variety of different, basic functions

(subscription only)

tick tick  
download file

task

Chocolate Addicts

This task provides students with the opportunity to practise writing SUM and AVERAGE formulae

(subscription only)

tick tick  
download file

task and answer sheet

Car Sales

Skills covered:

  • Write a SUM formula
  • Write a formula to calculate percentages
  • Format cells as a percentage
  • Format cells to 1 decimal place
  • Write and use an absolute cell reference
  • Replicate formulae
  • Write a formula to calculate the differences between to different percentages
  • Ensure work fits on one A4 sheet
  • Add name to footer
  • Set gridlines to show on printing
  • Set row and column headers to show on printing
  • Show formulas
  tick tick

download file

Task

absolute cell reference video tutorial

car sales.xls

absolute cell reference video tutorial

car sales answers.xls

 

Advanced formulae and functions

Resource

KS3

KS4

KS5

Click Here

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

INTeresting T-shirts

This spreadsheet exercise provides students with an opportunity to practise:

  • INT function
  • percentage calculations

Extension tasks are provided

Contributed by Jon Bridgeman of Finham Park School

 

 
tick
tick

absolute cell reference video tutorial

task

 

 

 

 

 

 

 

Copyright © www.teach-ict.com