Formulas in a spreadsheet model
Lesson 1 / 9
Lesson video
The video is not available yet.
Lesson slides
not available yet
Lesson details
Lesson outcome
I can use formulas to perform calculations in a spreadsheet model and replicate formulas across a range of cells.
Show transcript
Relative and absolute cell references are used in spreadsheet formulas to control how cell addresses change when copied.
A relative reference changes automatically when the formula is copied to another cell.
An absolute reference stays fixed on one cell, even when the formula is replicated.
Using the correct type of reference helps ensure formulas calculate correctly when using tools like the fill handle.
Worksheet
not available yet
Quizzes
This quiz is not available yet.
What pupils see
The same lesson as a pupil sees it. You can set any section as work on its own.
- IntroductionPrepare · Not available
- Starter quizActivate · Not available
- Lesson videoLearn · Not available
- Exit quizCheck · Not available
This content is by Cashar and published under an open licence.