help please! this is for an excel assignment due in 2 hours!!! time sensitive!!

Required information Excel Analytics 12-01 (Static) Ouality Coit Report (LO12-2) To complete this activity, you will need to have Excel installed on your computer. This exercise requires you to work in Excel and answer questions in Connect. You will read a brief scenario through 3 of this exercise: Some of the requirements include brief video tutorials on using Excel functions, Anter viewing the tutorials, you will then use what you learned to work directly in Excel to answer the trotulted questions in Connect. The following information applies to the questions displayod below] Harvey Company designs and produces surgical lasers. Its product is brilliantly designed, but the manufacturing process has been plagued by chronic quality controf problems. To heip costs of quality over the last two quarters as foliown Harvey Company designs and produces surgical lasers. Its product is brilliantly designed, but the manufacturing process has been placued by chronic nuality control prohleme To hein address the situation, Havey formed a cross-functional team of managers that quantified its costs of quality over the last two quarters as follows: on in Cuarter 2. Excel Analytics 12.01 (Static) Part 1 Excet Analytics 12-01 (Static) Part 1 Required: Click here fo download the Excel template" ExcelAnalytics QualityCostReport Template" which you will une to eomplete the requirements in Parts 1 through 3 of this exercise 1. Go to the Template A tob in the Excel workbook - For each coet deecription in celle A5 throunh A17, choose the correct qualify cost classification (1.e. prevention, appralsal, internal faliure, or external fallure) from the drop-down list that appears when you click in each of cells B6 through B17. b. Create formulas in cells D6 through D17 that state each individual cost from Quarter 1 (as shown in celis c5 through CTh as a percent of the first quarter's total cost of quality (as shown in cell C18). Repeat this process in column G for quarter 2. c. Create formulas in cells E6 through E17 that state each individual cost from Ouarter 1 (as shown in cells C6 through C77) as a percent of the first quarter's total sales (as shown in cell C20). Repeat this process in column H for quarter 2. save your work in tacel, then enter your andwers to queitions is through ic in the tabe below. C6 through C17 ) as a percent of the first quarter's total sales (as snown in cell C2 column H for quarter 2. Save your work in Excel, then enter your answers to queetions 1a through ic in the tabs below. What is the correct quality cost classification for each of the following quality costs? C6 through C17 ) as a percent of the first quarter's total sales (as shown in cell C20 ). Repeat this pr column H for quarter 2 . Save your work in Excel, then enter your answers to queotions 1a through 1c in the tabs below. For each of the quality costs shown below, what is the amount of the cost as a percent of the tocal cost of quality? The firat column of answers relates the first quarter and the second column relates to the second quarter. Note: Round vour answers to 1 decimal place. C6 through C17 ) as a percent of the first quarter's total sales (as shown in cell C20 ). Repeat this pro column 4 for quarter 2 Save your work in Excel, then enter your answers to questions 1 a through 1c in the tabs below. For each of the quaity costs shown below, what is the amount of the cost as a percent of the total saics? The first column of answers relates the first quarter and the second column relates to the secand quarter