Introduction to basic formulae and functions

Skills covered:

• addition formula
• subtraction formula
• multiplication formula
• division formula
• SUM function
• AVERAGE function
• MIN function
• MAX function
• COUNT function
• Displaying formulae

Basic Excel Formula

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

Basic information about formulae

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

Basic Formulae Revision Task

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

Addition formula tasks

Kindly contributed by Jo Wallace from City of Bath College

Subtraction formula tasks

Kindly contributed by Jo Wallace from City of Bath College

Formatting and using basic formula

Kindly contributed by Jo Wallace from City of Bath College

Bush tucker trial

This task asks students to enter data into a spreadsheet and set up a multiplication formula which they then replicate to other cells.

They are also required to undertake some basic formatting tasks

Basic Functions Revision Task

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

Chocolate Addicts

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

(subscription only)

Addition formula tasks

Kindly contributed by Jo Wallace from City of Bath College

SUM, AVERAGE, MIN and MAX

Kindly contributed by Jo Wallace from City of Bath College