### Excel 2003: Formulae and Functions

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

### Basic formulae and functions

##### Introduction to basic formulae and functions

Skills covered:

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

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

##### Basic Formulae Revision Task 1

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

(subscription only)

##### Basic Formulae Revision Task 2

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

(subscription only)

##### 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

(subscription only)

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

(subscription only)

Note: please ensure that macros are enabled

skills practice

##### Hogwalks Houses

Students work on a basic spreadsheet which has been provided.

They format the worksheet, write basic formulae and functions and then print out their work

hogwalks houses.xls

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

(subscription only)

##### 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
• Set gridlines to show on printing
• Set row and column headers to show on printing
• Show formulas

car sales.xls

##### Count IFULA

This spreadsheet exercise provides students with an opportunity to practise:

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

Contributed by Jon Bridgeman of Finham Park School

##### INTeresting T-shirts

This spreadsheet exercise provides students with an opportunity to practise:

• INT function
• percentage calculations

Contributed by Jon Bridgeman of Finham Park School

=Index function worksheet (kindly contributed by Anthony Hughes)