Using the information in tables 1 & 2 and the Project: Energy Yearly Projections Using Electricity, Coal, and Oil Data S

[answerhappygod]

Using the information in tables 1 & 2 and the
Project: Energy Yearly Projections Using Electricity, Coal,
and Oil Data Set spreadsheet answer questions 1 – 7.
You will submit the finished spreadsheet as the project in
Canvas.
You can locate the Project: Energy Yearly Projections
Using Electricity, Coal, and Oil Data Set spreadsheet
under the Project: Energy Yearly Projections Using
Electricity, Coal, and Oil Resources section.
Table 1:
Appliance
Central Air Conditioner
Water Heater
Clothes Dryer
Oven
Dishwasher
Fridge
Ceiling Fan
LCD TV
Watts
8000
3400
3500
1350
1150
1200
120
250
Assume that the number of hours that the aforementioned
appliances run during an average day is given in the table
below:
Table 2:
Appliance
Central Air Conditioner
Water Heater
Clothes Dryer
Oven
Dishwasher
Fridge
Ceiling Fan
LCD TV
Hours
8
3
3.5
2
1.5
24
6
6
Add columns to the Project Data spreadsheet that show the
following for each appliance:
Using the information in tables 1 & 2 and the
Project: Energy Yearly Projections Using Electricity, Coal,
and Oil Data Set spreadsheet answer questions 1 – 7.
You will submit the finished spreadsheet as the project in
Canvas.
You can locate the Project: Energy Yearly Projections
Using Electricity, Coal, and Oil Data Set spreadsheet
under the Project: Energy Yearly Projections Using
Electricity, Coal, and Oil Resources section.
Table 1:
Appliance
Central Air Conditioner
Water Heater
Clothes Dryer
Oven
Dishwasher
Fridge
Ceiling Fan
LCD TV
Watts
8000
3400
3500
1350
1150
1200
120
250
Assume that the number of hours that the aforementioned
appliances run during an average day is given in the table
below:
Table 2:
Appliance
Central Air Conditioner
Water Heater
Clothes Dryer
Oven
Dishwasher
Fridge
Ceiling Fan
LCD TV
Hours
8
3
3.5
2
1.5
24
6
6
Add columns to the Project Data spreadsheet that show the
following for each appliance: