please kindly answer all the questions and put the answers in the chart

You are a teaching assistant for Professor Mark Houston, who teaches introduction to business in computers at Harvard University. One of your routine tasks is to test grades entered into the grade book by professor Houston. a. Open the file and save it as _YourLastnameFirstname. b. Calculate The Final average based on the four category points (My_it_Lab, Mid-term, Attendance Record and Final Exam). c. Use the appropriate function to calculate the letter grade, rank and the comment field for each student, use the Grading Scale table. Hint: Use either the range name or absolute reference in your function. d. Find the mean, highest score and lowest score based on Final Average. e count the total no of students who's comment was "v.good".. f count the total no of students whose leter grade was "A" Name Lottor Grade Attendance Final Record Average 85 Comment Hank My_lt_Lab 90 Mid-Term Final Exam 84 88 88 90 75 91 78 68 85 70 64 60 60 74 58 82 80 82 84 90 80 70 55 62 80 94 74 96 80 Atkin Bailey Basquez Ethington Isham Leung McAllister Mellor Myers Noakes Nuve O'Hair Peugh Pulley Rodarte Sager Smith Stanworth Stuberg Takahashi 74 82 90 66 76 90 78 78 52 85 84 76 64 56 78 76 82 50 84 74 60 88 74 60 85 100 50 90 90 80 75 75 80 95 100 86 6B 48 54 50 68 74 98 86 62 96 88 100 94 Higest Score Lowest Score Mean count the total no of students who were "w.good" count the total no of students whose ieter grade was "A" Final Grade Distribution Grade # Students A Grading Scale Breakpoint Letter 0 F 59.5 D 69.5 79.5 B 89.5 Comment Fail Pass Good V.good Excellent B