I need the excel formula used for solving the Excel sheet.

Thanks

1 Question #1 2 3 In this assignment, you will be using various formulae to make your calculations. Please complete the gray shaded areas. Sort the 4 student names by last name. Pay particular attention to the weighted test scores and the bonus mark. Students who did OKAY on there homework, get a bonus of an additional 3 marks on their Final Mark. Please use RED to indicate a letter grade less than 70%. 5 save the results. 6 7 8 Sowinski's Grade Book - Excel Tests Marks 9 OK 10 Name Student Number Test 1 11 Adamson, John 111223333 80 12 Barber, BettyAnn 444556666 92 13 Boone, Dan 777889999 78 14 Borrow, Ineda 123456789 65 15 Brown, James 999999999 92 16 Carson, Kit 888888888 82 17 Sundine. Mathew 100000000 60 18 Gerey, Richard 222222222 75 19 Flinstone Fred 200000000 90 20 Glassman, Kris 444444444 82 21 Woods, Lion 555555555 66 22 Milgrom, Marion 666666666 94 23 Mousette Mickey 300000000 75 24 Smith, Adam 777777777 60 25 Test 2 71 98 81 65 95 90 50 70 90 78 88 92 78 50 Test 3 70 97 70 65 79 90 40 65 80 62 65 86 65 65 Test 4 Test Mark Homework Final Mark Grade 84 Poor 90 OK 78 OK 60 OK 80 70 OK 79 OK 95 OK 90 Poor 77 OK 78 OK 84 OK 82 Poor 80 Poor Homework Bonus 3 Grading Criteria 0 60 26 Average 27 Highest Grade 28 Lowest Grade 29 Range 30 31 Exam Weights 70 80 90 I T 20% 20% 20% 40% A 32