Please help! Textbook problem that needs to be completed in Excel.

Thank you!

1. Open the workbook named Binding3.xlsx locatod in the Chapter 2 folder, and then save it as QC Binding Data Analysis 3.xlsx. The InspectionCosts workshect conrains two hours of inspection data from the QC inspectors, detailing the amount of time spent testing the bindings for each of the tests performed: Pressure and Temperature. 2. Calculate the cost to test each ski binding and the total costs for all bindings over this two-hour period. Insert the labor cont per hour abowe the column heading, and display the cell to include "\$/hr-labor" following the value, centering it in the cell. If an crror message regarding omitting adjacent cells is generated, instruct Excel to ignore this error. (Hins If the error occurs for multiple adjacent cells, highlight all cells, and then click the error message adjacent to the first cell to apply the setting to all cells.) Format the first value using the Accounting Number Format, and format the remaining values using the Comma Style. Use similar cell outlining to the adjacent cells. 3. Several rows below the labor cost data, calculate the mean, median, and standard deviation of these inspection costs (Pressure, Temperature) rounded to the nearest cent. Label the rows appropriately. Format these values in Accounting Number Format. 4. On a separate worksheet named TypeSummary, summarize these values by binding type ( 1 to 5 ). Include both a count of the number of bindings inspected of that type and the averages for bindings of that type, as listed in Table 2.13. Be sure to use formulas that will automatically update if any of the binding types, values, or cost data is later updated. The formula for average pressure should work when copied down the column to determine pressure for each corresponding binding type, and across the row to determine the average temperature and average costs for each type. Format the table appropriately. Also include a value for the total number of bindings tested and the total cost of all bindings tested. 1. Open the workbook named Binding3.xlsx locatod in the Chapter 2 folder, and then save it as QC Binding Data Analysis 3.xlsx. The InspectionCosts workshect conrains two hours of inspection data from the QC inspectors, detailing the amount of time spent testing the bindings for each of the tests performed: Pressure and Temperature. 2. Calculate the cost to test each ski binding and the total costs for all bindings over this two-hour period. Insert the labor cont per hour abowe the column heading, and display the cell to include "\$/hr-labor" following the value, centering it in the cell. If an crror message regarding omitting adjacent cells is generated, instruct Excel to ignore this error. (Hins If the error occurs for multiple adjacent cells, highlight all cells, and then click the error message adjacent to the first cell to apply the setting to all cells.) Format the first value using the Accounting Number Format, and format the remaining values using the Comma Style. Use similar cell outlining to the adjacent cells. 3. Several rows below the labor cost data, calculate the mean, median, and standard deviation of these inspection costs (Pressure, Temperature) rounded to the nearest cent. Label the rows appropriately. Format these values in Accounting Number Format. 4. On a separate worksheet named TypeSummary, summarize these values by binding type ( 1 to 5 ). Include both a count of the number of bindings inspected of that type and the averages for bindings of that type, as listed in Table 2.13. Be sure to use formulas that will automatically update if any of the binding types, values, or cost data is later updated. The formula for average pressure should work when copied down the column to determine pressure for each corresponding binding type, and across the row to determine the average temperature and average costs for each type. Format the table appropriately. Also include a value for the total number of bindings tested and the total cost of all bindings tested