Please list the excel formualas.

1. In your New class, you would be required to complete 5 assignments during the semester. The best 4 assignment grades would count toward the final grade. In addition, you would be required to complete a term paper, and also take a mid-term and a final examination. Assignments are worth 20% on the final grade, the term paper is worth another 20% on the final grade, and the mid-term and the final are worth 25% and 35%, respectively. Scored for 4 students are provided in Sheet named Problem 1 of the accompanying Excel file named Final Examination. Maximum scores are in row 2. a. Calculate overall assignment grade out 20 in Cell G3 for Alpha. You should be able to copy the formula in cells G4 to G6. Copy/write this formula in the section for the answer. b. You also want to calculate the overall grade for each student. What formula would you enter in cell K3 to calculate the weighted score so that it can be copied to cells K4 to K6 to calculate weighted score (out of 100) for each student. (5+5) Copy/write these formulas you wrote in cells G3 and K3 in the answer for this question.Name Assn1 Assn2 Assn3 Assn4 Assn5 Assignments TermPaper Midterm Final Weighted Score Max 10 10 10 10 10 20 100 100 Alpha 0 2 W 1 19 70 67 Bravo 2 10 0 20 74 63 O VOU Charlie 17 77 73 Delta 10 17 96 71