SPREADSHEETS        

Create a Spreadsheet

Teacher Guidelines

Examples of Spreadsheets

  To Create a Spreadsheet

 1. Start
 2. Programs
 3. Microsoft Excel
 4. The blank spreadsheet appears.
 5. Minimise this spreadsheet for the present.
 6. Click here and print a copy of the data required for the spreadsheet.
 7. Maximise the spreadsheet already created and enter the data into the      spreadsheet - you may wish to use your own name instead of Mary's.

 8. Save this spreadsheet as assignment 1 

Click HERE to view the Excel Window layout as an image

 





 

 

 

Mary's Personal Budget        
 
Week 1
Week 2
Week 3
Week 4
         
Mary's Income        
Opening Balance
110
Formula
Formula
Formula
Wages
250
260
200
240
Overtime
20
120
50
0
         
Total Income
Formula
Formula
Formula
Formula
         
Mary's Expenditure        
Travel / Bus / Train        
Food        
Entertainment        
Savings        
Rent        
Bills        
Extras        
         
Total Expenses
Formula
Formula
Formula
Formula
         
Closing Balance
Formula
Formula
Formula
Formula

 

 

 

Teacher Guidelines

Examples of Spreadsheets