20 likes | 97 Views
Create a spreadsheet to calculate feeding costs for zoo animals. Use formulas to determine total cost and overspending. Design charts to visualize costs and animal count. Assist the zoo manager in managing expenses effectively.
E N D
Objectives : Task 1 TASKS 1: Using formulas and your spread sheet work out the following. 1.How much does it cost to feed all the animals in the zoo . 2. The total cost of feeding all the animals. 3.Now much has been over or under spent. Your have been asked by the Zoo manager to design a spread sheet to help them calculate how much it cost to feed the animals they have. http://www.teach-ict.net/software/excel_2007/excel_2007.htm
Objectives : Task 2 TASKS 2: Charts 1) A column chart showing how much it cost to feed the animals. 2) A Pie chart showing the number of animals currently in the zoo. Using a text box annotate each chart.( What you think it shows). Now that you have made your calculations, the Zoo manager would like you to generate a chart to give them a better visual idea on the costs of feeding the animals they have.