ReviseICT.co.uk homepage
Microsoft Excel
Spreadsheet software

Tasks

 
You have three tasks to complete.  As you work through the task you will develop your Excel skills.  Many people find Excel tricky to use, but as you work through these challenging activities you'll soon be excelling!

Right-click on the links and select 'Save As'.  Save the file to your own computer.

 Task  Requirements
   
1. Sweets  Complete basic calculations.
 Add in formulas.
 Develop understanding of "computer modelling".
   
2. Pocket money  Create own spreadsheet.
 Use formulas and functions.
 Add in data and explain results.
 Use autofill feature
 Develop your own "computer model".
   
3. Record store  Create accounts spreadsheet.
 Understand and use cell and number formatting.
 Use formulas, functions and cell references.
 Use charts to illustrate data.
 Use colours to indicate profit and loss.
 Begin to use "IF" statement.
   

Only when you have completed all the tasks about should you continue on.


Assessment

 

Index page