Process and analyse numerical data

Absolute and relative cell references

Absolute Cell References 1

Use this task sheet to give your students further practice at writing an absolute cell reference

download filedownload file

(2003 & 2007)

 

Absolute Cell References 2

Use this task sheet to give your students further practice at writing an absolute cell reference

download filedownload file

(2003 & 2007)

 

Absolute Cell References 3

Use this task sheet to give your students further practice at writing an absolute cell reference

(subscription only)

download file

(2003 & 2007)

Ice Cream Task

This provides a formatted spreadsheet which requires an absolute cell reference to be written in order to calculate total ice cream sales

download file

(2003 & 2007)

Mobile phones task

Use this task sheet provides students with another opportuntiy to practice writing a formula which contains an absolute cell reference.

(subscription only)

download file

(2003 & 2007)

Relative references, absolute references, mixed references

Kindly contributed by Jo Wallace from City of Bath College

click here

(Excel 2007)

Absolute cell reference practice, charts

Kindly contributed by Jo Wallace from City of Bath College

level 1 dida

(Excel 2007)

 

 

Copyright © www.teach-ict.com