# 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.

Lesson 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 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)

The Gold Mine

#### Slide 6 -Slide

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?