Unit 2 Assessment

Portfolio Activity

Please note: If you are completing the assessment for this course, then you need to complete this portfolio activity.

Make sure you have a clear understanding of the scenario and instructions in the Assessment brief
Download and print the Planning template
Create your spreadsheet plan
Submit your spreadsheet plan for assessment

Spreadsheet specifications

With the data provided in the Scenario you are required to plan a spreadsheet to show:

Cost per appliance per day - (Cost per Hour X Hours Used Daily)
Cost per appliance per week - (Cost per Appliance per Day X 7)
Cost per appliance per month - (Cost per Appliance per Week x 4)
Use the SUM function to calculate:
- Total cost of all appliances per day
- Total cost of all appliances per week
- Total cost of all appliances per month