Can anyone use EXCEL and demonstrate the following 4 problems below please?! Please provide screenshots of the EXCEL work step-by-step please (do not solve by writing, USE EXCEL) thank you

Leave columns A \& B empty - make no entries. You may wish to simply "hide" these two columns. These columns will be used for grading. At the top of the Excel spread sheet, list the names of your Excel Team, and your E10 Lab Section number. The Excel solutions should include explanations for what you have done, and why. Explanations should be entered as text in cells adjoining the solution work. * For many solutions, much of what you have done will be displayed in the details of the cells displayed in the top of page formula bar. However, that will display the "what" not the "why" of what you did. Clearly arrange and label exercise answers. You should be able to fit all the exercise solutions on a single sheet. Arrange the exercise solutions one above the other, moving down the Excel sheet. Do not place the solutions side by side across the sheet. Exercise 1 An engineering student took five courses in the Spring 2020 semester. The credit hours and the grades for these courses are listed in Table 1. Table1: Credit Hours and Grades for Spring 2012 Courses Calculate the student's grade point average (formula given in Eq-1) for the semester. Table 2 provides the grade point associated with each letter grade (per each credit hour). Table 2: Grade Points Per Credit Hour Associated with Letter Grades The equation that is used by Excel to calculate the GPA. You can check your answer by hand calculation. Grade Point Average =i=1nxii=1nxiyi,n= number of courses Eq-1 where xi is the credit hours of course i and yi is the points associated with the grade for course i. Exercise 2 Information on inventory of machine parts of a manufacturing company is displayed in Table 3 . The first column displays the part identification number; the second column presents the number of units on hand available for the corresponding part; the third column gives the per-unit manufacturing cost of the corresponding part; the fourth column gives the unit sales price for the corresponding part. The company has the following simple inventory policy. - When the current stock level (i.e., the number of units on hand) of a part falls below a threshold, called the minimum stock level, the company will order the part from its suppliers. - The order quantity (i.e., the number of units ordered) for the part plus the current stock level should be equal to the maximum number of units that can be held in inventory, called the maximum stock level. - The total order cost is the sum of the order costs for all parts that must be ordered. Table 3: Inventory of Machine Parts Use appropriate Excel formulas/functions to answer the following (check Excel answers by visual inspection and hand calculation: a) Use an Excel function to determine the greatest quantity on hand among all the parts stocked in the inventory. E10- Excel 1 Lab Spring 2023 - GF page 4 b) Use an Excel function to determine the average quantity on hand across all parts. c) Use Excel equations to calculate the total dollar amount tied up in inventory, in terms of manufacturing cost? d) Use Excel equations to determine the average manufacturing cost per unit for the total inventory on hand. e) Use an Excel formula to determine how many parts have a unit price that is greater than $2.00. f) Create a column to display an order quantity based on the following rules. If the quantity on hand is less than the minimum stock level of 30 , then order 100 minus the quantity on hand (to bring the stock level up to 100 units of item). Otherwise the quantity ordered is zero. The column should contain Excel functions to automatically calculate the order. Preventing fatigue crack propagation in aircraft structures is an important element of aircraft safety. An engineering study to investigate fatigue crack in n=9 cyclically loaded wing boxes reported the following crack lengths (mm): 2.29, 2.76, 3.22, 1.85, 1.15, 1.45, 2.14, 1.97, 2.68. Calculate by using the Eq-2 and Eq-3 a) the sample mean (i.e., the average of the lengths) b) sample standard deviation (as a measure of variability of the lengths) c) verify the answers by entering Microsoft Excel statistical functions Average and Stdey, respectively Data Observations: x1,x2,.,xn Sample mean: x=ni=1nxi Eq- 2 Sample Variance: s2=n1i=1n(xix)2 and Sample Standard Deviation: s=s2 Eq-3 Exercise 4 Table 4 provides information on structural defects in a random sample of automobile doors: Table 4: Structural Defects in Automobile Doors a) Construct an appropriate chart to help visualize how frequently different types of defects occur. b) Construct an appropriate chart to display the percentage of defects of each different type with respect to the total number of defects. Hint: what type of chart is good for showing proportions