Rows, Columns & Wizards

C7 Column then Row : This is the Cell Reference

Task

Wizard’s_Challenge Enter the cell references to score a point. Remind your teacher to use this countdown so you can have a class race (2 minutes)

Vocab Test

What is the Active Cell?

Teachers note

This first lesson is simple and fun. If you don’t want to spend too long on The portrait. Move on to lesson 2

Key words & Cabbages

Key Terms Starter ppt Click: Enable Editing and Enable Content.

Formulas Goldmine

Formulas always start with =

eg. =A1+A2

+  add
-  minus
*  multiply
/  divide

Task

The Gold Mine 3 levels for you to dig

On which key do you find * ?

Format Tennis

Format: how things are presented

How many different formats can you see in the image below?

Challenge your partner to a game of format tennis. Rules:

Serve up a format
Receive one back
Winner is the one who can remember another format without repeating one thats already been said

.

Bold, font type/size, 
colour, background/fill, italic, 
borders, date/time, text(label), percent 

• Merge Cells and Centre Text (eg. in the title of the table – How to Merge and Centre )
• Remove Gridlines [ View > Show > Gridlines ]
• Add speech bubbles [ Insert > Shapes > Callouts ]

Extension: teach yourself some advanced formatting

Formatting Help Videos from TeachICT.com (wait for the page to load fully or click on the formatting button.

Excel Portrait

Teach ICT column width video
Youtube Excel Animation