Excel 2007: Absolute Cell References

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

Sales commission

This provides a brief overview of absolute cell references and then gives students an opportunity to write their own formula.

  tick tick
download filedownload file

Task

 

Relative references, absolute references and mixed references

A good introductory task

Kindly contributed by Jo Wallace from City of Bath College

tick tick tick

absolute cell reference video tutorial

Task

Experimental data

Students enter data from an experiment.

They write their own absolute cell reference formula to work out the variables in the experiement

  
tick
tick
download filedownload file

Task

Concerts

Students are given a spreadsheet and have to use an absolute cell reference in order to work out the commission made on ticket sales.

(subscription only)

  
tick
tick

download file

Task

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

(subscription only)

  
tick
tick
download file
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)

  
tick
tick
download file
Absolute cell reference practice

This task provides students with another chance to practice setting up an absolute cell reference. It assumes that they know how to do this.

Kindly contributed by Jo Wallace from City of Bath College

tick tick tick

absolute cell reference video tutorial

Task

 

 

 

 

 

 

Copyright © www.teach-ict.com