Excel - Part 2

• Computing
• Lower Secondary (Key Stage 3)

 7 - Excel Recap

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.

Spreadsheets, Excel

The Wizard's Challenge!

Fill out the grid references

Find the magic number.

What was the magic number (high score)

The Gold Mine

Diggy Diggy Hole

Head to teams for your worksheet.

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

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

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