Working with spreadsheets/Charts/Assessment

{{OP Portfolio_activity|

Instructions
The Electricity company has sent out a revised brochure showing a 20% increase in the cost of running each appliance and offering a $10 reduction if your account is paid early.

Using the revised data, make changes to your spreadsheet to reflect the new information.


 * 1) Create a column called 20% Increase and key the following data into the appropriate row. The 20% Increase column should be inserted after Cost per Hour
 * Clothes Dryer	0.1844
 * Computer	0.0505
 * Fan Heater	0.0581
 * Television	0.0654
 * Oven	0.0665
 * Stereo	0.0751
 * 1) Insert a new column after the 20% Increase column and name it Total Cost per Hour
 * 2) Calculate the Total Cost per Hour (Cost per Hour + 20% Increase)
 * 3) Insert a new column after Total Cost per Hour and name it % Increase
 * 4) Calculate the percentage increase and format to percentage and zero decimal places (‘Total Cost per hour’ / ‘Cost per hour’). This will provide you with a check that the company has provided the correct information that you entered previously – your answer should be 120%.
 * 5) Modify the formula in Costs per Day to reflect the new column called Total Cost per Hour
 * 6) Insert a new column after Cost per Month and name it Early Payment
 * 7) Subtract $10 off each appliance’s Cost per Month
 * 8) In cell A15 enter Average Running Cost. In Cell B12 calculate that average cost to run all 	appliances per month. Format to two decimal places.
 * 9) In cell A16 enter Max Cost per Hour. In Cell B13 calculate the maximum for Costs per Hour. Format to two decimal places.
 * 10) In a new sheet create a pie graph (Chart Layout 1) using data in the Appliance and Cost per Month columns. Name the graph Appliance Costs. Name the sheet Appliance Cost Graph.
 * 11) In a new sheet create a column graph using data in the Appliance, costs per hour and 	Total costs per hour. Name the graph New Appliance Costs. Name the sheet New Appliance Cost Graph.
 * 12) Use the checklist below to review your work before submitting the revised spreadsheet.

Checklist

 * The spreadsheet file has been located and opened.
 * The new variables have been entered.
 * The new columns have been created
 * The formulae have been altered
 * Correct cell ranges have been used to produce two graphs as part of the solution.
 * The revised spreadsheets have been printed out in hard copy.
 * Formulae have been entered and formatted correctly.
 * The spreadsheet has been formatted and headings are consistent.

}}