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

Type the cell reference in each cell and score a point towards the magic number. Can you work out the magic number?

What was the magic number (high score)

The Gold Mine

Diggy Diggy Hole

Task

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.

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?