SOFTWARE SKILLS
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 |
|
|
|
  
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.
|
|
|
|
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 |
|
|
|
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) |
|
|
|

Task

car sales.xls

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) |
|
|
|
|
This provides a formatted spreadsheet which requires an absolute cell reference to be written in order to calculate total ice cream sales
(subscription only) |
|
|
|
|
Use this task sheet provides students with another opportuntiy to practice writing a formula which contains an absolute cell reference.
(subscription only) |
|
|
|
|
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 |
|
|
|

Task
|
Copyright © www.teach-ict.com