Absolute Cell Reference

Resource

KS3

KS4

KS5

Click Here

Video Tutorials

Workbook

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 1

This task sheet assumes familiarity with absolute cell references. It provides an opportunity to embed skills.

Task 2

This task sheet assumes familiarity with absolute cell references. It provides another opportunity to embed skills.

Task 3

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.