Carrying out a project part I
Lesson 10 / 10
Lesson video
The video is not available yet.
Lesson slides
not available yet
Lesson details
Lesson outcome
I can edit the structure of a provided spreadsheet workbook and apply functions and formulas to each sheet.
Show transcript
Using a single spreadsheet workbook with different sheets can help organise all the data in one place.
Formulas like SUM and functions like IF help you do calculations quickly and accurately.
Using the fill handle and absolute cell references can make your formulas more efficient.
You can use formulas to link cells from one sheet to another, so data updates automatically.
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.