### Excel 2010: Formulae and Functions

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

### Basic formulae and functions

#### KS5

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

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

(subscription only)

##### Basic formula paper based task

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

(subscription only)

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

#### KS5

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