I need the Excel formula otherwise this answer will be disliked . Make sure you provide me with the excel formula

In this assignment, you will be using various formulae to make your calculations. Please complete the gray shaded areas. Sort the 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%. Save the results. 6 8 Sowinski's Grade Book - Excel Tests Marks 10 Name Student Number Test 1 Test 2 Test 3 Test 4 Test Mark Homework Final Mark Grade 11 Adamson, John 111223333 80 71 70 84 Poor 12 Barber, BettyAnn 444556666 92 98 97 90 OK 13 Boone, Dan 777889999 78 81 70 78 OK 14 Borrow, Ineda 123456789 65 65 65 60 OK 15 Brown, James 999999999 92 95 79 80 OK 16 Carson, Kit 888888888 82 90 90 70 OK 17 Sundine. Mathew 100000000 60 50 40 79 OK 18 Gerey, Richard 222222222 75 70 65 95 OK 19 Flinstone,Fred 200000000 90 90 80 90 Poor 20 Glassman, Kris 444444444 82 78 62 77 OK 21 Woods,Lion 555555555 66 88 65 78 OK 22 Milgrom, Marion 666666666 94 92 86 84 OK 23 Mousette. Mickey 300000000 75 78 65 82 Poor 24 Smith, Adam 777777777 60 50 65 80 Poor 25 Homework 26 Average Bonus 3 Grading Criteria 27 Highest Grade 0 28 Lowest Grade 60 29 Range 70 30 80 31 Exam Weights 20% 20% 20% 40% 90 32