School Bazaar

Your school is to have a school bazaar to raise funds to buy additional computer equipment for the school. You have been asked to help with the administration side of the bazaar by being in charge of computer-related tasks that need to be completed.

The list of expenses that you have been given to date is as follows:

Expenses June July August
Hire of tents 0 0 799.95
Advertising 45.73 63.35 132.46
Groceries for pancake stall 0 0 412.97
Liquor licence 0 0 1027.85
Stock for beer garden 133.50 127.30 133.25
Materials - Needlework 47.33 35.82 23.15
Transport 350.00 350.00 350.00
Stationary and postage 0 0 0
Wages 0 0 0
  1. Create a spreadsheet to store the expense details. The headings of each should be underlined and in bold type. Each column must be just wide enough.
  2. Insert your name as a footer. 
  3. Add a Totals column to the right of the spreadsheet and calculate the amount spent on each item. 
  4. All figures should be formatted to 2 decimal places as Rand. 
  5. Sort the rows according to alphabetical order of the Expenses column. 
  6. Create a pie chart showing the Expenses and Totals with the legend (heading) 'Expenses to date'. Be sure to show all data legends. 
  7. In File / Properties add your name as the author.
  8. As a footer add the file name left,    Prepared by ... and the date       centre.    (Add as a mixture of normal and custom footers.)
  9. Print a copy of the spreadsheet and graph fitted to ONE page.
  10. Display the formulae in the spreadsheet.  Print a copy of the spreadsheet showing the formulae in landscape. 

This work may be freely copied for non-commercial use only. Copyright © Pam Miller.