Excel - Part 2

• Computing
• Lower Secondary (Key Stage 3)

Personal Development Q&A

CLICK ME

 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

Task

Click here to Open your worksheet.

Click the viewing button and then open up in Desktop App. Save the file your Digital 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?