SPREADSHEETS

Below is the worksheet showing Austin Citizens High School Leavers’ party budget. Use any of the spreadsheet programs and type in the work in the table below before you follow the instructions provided in the required list.

1. Save your work as Your Name – Leavers Budget              

Required:

1. Use a function or a formula to calculate the Total Price in each item
2. Use appropriate functions to calculate:
   • Average Total Price                                                          
   • Lowest Total Price                                                            
   • Highest Total Price                                                           
   • Grand Total Price                                                             
3. If the Leavers made a contribution of 1,500,000 as indicated in the worksheet, use a formula to calculate the balance to remain after all the purchases.
4. Use the IF() function to display comments as “High Price” if the item’s price is 10000 and above, “Normal Price” if the item’s price is above 5000 and “Low Price” if the item’s price is 5000 and below                              
5. Apply a thick green border with red grids inside                    
6. Create a pie chart based on Items against Price fields showing labels and price variation in percentages. Save it as Pie-Chart.                    
7. Put your full name and class as footer and make printout.