Excel - Part 2

 7 - Excel Recap
1 / 10
Slide 1: Slide
ComputingLower Secondary (Key Stage 3)

This lesson contains 10 slides, with interactive quizzes and text slides.

time-iconLesson duration is: 50 min

Items in this lesson

 7 - Excel Recap

Slide 1 - Slide

KO: To refresh your knowledge of Microsoft Excel spreadsheets
All: Understand grid references and how to use them in calculations.
Most: Be able to create calculations with more complex operators (*, /, etc.).
Some: Be able to calculate SUM, MIN, MAX and AVERAGE.

Slide 2 - Slide

Spreadsheets, Excel

Slide 3 - Mind map

The Wizard's Challenge!
Fill out the grid references
Type the cell reference in each cell and score a point towards the magic number. Can you work out the magic number?

Slide 4 - Slide

What was the magic number (high score)

Slide 5 - Open question

The Gold Mine

Slide 6 - Slide

Click here to Open your worksheet.

Click the viewing button and then open up in Desktop App. Save the file your Digitla Literacy folder, so you can edit it.

Slide 7 - Slide

On the sum page, calculate the sum of the three answers?

Slide 8 - Open question

On the Min Max page, calculate the average of the two answers?

Slide 9 - Open question

On the average page, what is the answer to 1 multiplied by the answer to 2?

Slide 10 - Open question