Spreasheets I : Cell References

Lesson Objective : Understand the a spreadsheet is made up of cells

Each cell has a cell reference

Learning Outcome : Download and open a spreadsheet file. Enter cell references

The Big Picture

What have we done? This is out first spreadsheet lesson

What are we doing? We are going to use a spreadsheet and enter cell references

What are we going? We will use spreadsheets to make lots of calculations

A spreadsheet program is made up of a large table, called a sheet.

Each cell has a cell reference. The cell reference is the column letter followed by the row number. The cell reference for the green cell below is B3.

How to find MS Excel on your computer. Select the windows button on the bottom left of the screen and search for Excel. Select the correct version.

Task: The Wizard’s Challenge

Note : You may need to select Enable Editing

Enter the correct cell references into the appropriate cells in the table.

You can simply click on any cell to start typing into it.

You can also use the arrow keys on the keyboard to move from cell to cell.

Press the ENTER key once finished.

If the cell reference is correct, the cell will turn green.

Success Criteria

Success : I can enter over 15 cell references

Super Success : I can fill most of the table

Extra Success : I can complete the table and move on the next week’s task

Next week’s task

Note : You may need to select Enable Editing


Work out the answers to various calculations and if they are right, the cells will automatically turn gold.

You can enter formulae into cells to help work out the answers.

All formulae must begin with an = (equals) sign

See example in D7;

=B7+C7 will add the numbers of the 2 cells together

If you finish, you can go to level 2

Socrative Plenary

If you are attending the live sessions, you will be asked to tell me how you did.


Room Name : XFUTURE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: