Category Archives: Spreadsheets

Using Spreadsheets to investigate problems.


Last week we looked at referencing cells and entering simple formulae, so this week we are going to build on these skills.  For the start of the lesson I want you to copy my spreadsheet shown, but complete it.

L2 1

Sometimes you need to make a spreadsheet more attractive for the user, so you can use colours and different fonts.  Remember… It needs to be readable!

L2 2

The tool bar on Excel is very similar to Word and PowerPoint, so you don’t need any help with this.

Now you know how useful Spreadsheets are get ready for the next challenge!

Sweet Problem

Now you have tackled the problems can you comment on our blog and tell me what are the advantages of a spreadsheet over a pencil and paper with this type of problem solving.