Sales commission

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

Task

Relative references, absolute references and mixed references

A good introductory task

Kindly contributed by Jo Wallace from City of Bath College

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

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)

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)

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)

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

Task