Order from us for quality, customized work in due time of your choice.
ohnston Smith, Associate Director of Sales as Pasadena HVAC Manufacturer, has asked you to calculate the cost of running HVAC units in summer.
For this assignment, you will need the following file:
HVAC_Cooling.xlsx
You will save your file as: Lastname_Firstname_HVAC_Cooling
Open the HVAC_Cooling Excel file and save the file as Lastname_Firstname_HVAC_Cooling.xlsx.
Insert your name in the footer.
In the worksheet, Format as Table and add a header row.
Add a calculated column that calculates the cost of cooling using $0.00124 per Cooling BTU formatted with the Accounting Number Format.
Sort Heating BTU number smallest to largest
Filter the data to display only all Heating BTU number greater than 75,000.
Rename the Sheet1 to Heating BTU
Apply AutoFit to all columns.
Center the worksheet horizontally on a landscape page.
Order from us for quality, customized work in due time of your choice.