### Excel 2007: Formulae and Functions

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

### Basic formulae and functions

#### Click Here

##### Basic information about formulae

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

##### Addition Formula Task

Task to learn how to write an addition formula

Kindly contributed by Jo Wallace from City of Bath College

Task

##### Subtraction Formula Task

Task to learn how to write an subtraction formula

Kindly contributed by Jo Wallace from City of Bath College

Task

##### Basic Formulae Task 1

This task asks students to enter data and then write a formula to calculate totals

Kindly contributed by Jo Wallace from City of Bath College

Task

##### Basic Formulae Task 2

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

(subscription only)

task

##### Basic Formulae Task 3

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

(subscription only)

task

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

##### Basic Functions Task 1

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

(subscription only)

task

##### Basic Functions Task 2

Learn SUM, AVERAGE, MIN and MAX

Kindly contributed by Jo Wallace from City of Bath College

Task

##### Chocolate Addicts

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

(subscription only)

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

Task

car sales.xls

car sales answers.xls

##### Champions Football League

This is an excellent resource which asks students to set up a spreadsheet and undertake a number of tasks related to the Champion's football league.

It has been written for Key Skills Level 3 ICT students. However, it could also be used to help teach or reinforce skills at KS4 level.

Please note that the task has been written specifically for Excel 2007 and it is not compatible for earlier versions.

Contributed by Jonathan Heaton

Task

### Advanced formulae and functions

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

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

task

Copyright © www.teach-ict.com