Excel 2003: Absolute cell reference tasks

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

Resource

KS3

KS4

KS5

Click Here

Tasksheet 1

This workbook provides a step-by-step guide to understanding absolute cell references.

It provides plenty of screen prints which the students can use as a reference point.

Also contains practice tasks

 
 
tick
tick

download filedownload file

Task

Tasksheet 2: 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

 

Tasksheet 3: 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

Tasksheet 4: Car sales

This task sheet assumes familiarity with absolute cell references and if..then.

The spreadsheet contains instructions to give students a chance to check their skills in using both absolute cell references and if..then functions.

(task sheet: subscription only)

  
tick
tick

download file

Task

click here

car sales.xls

click here

car sales answers.xls

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
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
Absolutely Relative

This spreadsheet exercise provides students with an opportunity to practise:

  • relative cell references
  • absolute cell references

Extension tasks are provided

Contributed by Jon Bridgeman of Finham Park School

  
tick
tick

absolute cell reference video tutorial

Task

 

 

 

 

 

 

 

Copyright © www.teach-ict.com