EXCEL MACROS

In a hypothetical class, if a student takes a comprehensive final and gets a better score than the higher of the two midterm scores, then: (1) the lowest score would be replaced by the comprehensive finals score, (2) the higher score will be increased by the difference between the higher and lower scores, AND the student will get an extra 3 points added to the comprehensive score. If the student scores higher than only one of the two midterm scores, only that particular midterm score is replaced by the final. The final score will then be calculated by averaging the three test scores. Calculate the final score using the given data presented in the Question1 worksheet. Note: for this question all your procedures (subs and/or functions) should be stored in the Question1_Module. Task 1: Code a function that requires test 1 score, test 2 score, and comprehensive final as inputs and calculates the final score per the description above Task 2: Code a subroutine that uses the function coded in part (a) to fill column F of the worksheet, and link this subroutine to the Perform Calculations button in the worksheet.

Final Score Student GPA 3.5 3.7 Student ID udent Na Test 1 Score Test 2 Score l Joe Hans Ferris Mike Lauren Larry Tony Kevin Sam Zibin Ran Donia Kate Sahar Milos Brian Zane Istiak Kumari John 78 80 92 45 98 75 48 68 59 63 49 87 85 45 21 49 34 91 100 19 Comprehensive Final 87 98 51 87 89 65 89 79 98 95 94 92 49 87 Perform Calculations 98 56 87 49 85 87 83 62 68 59 10 15 62 68 85 98 101 105 108 109 110 115 125 130 145 150 186 4 3.9 3.5 3.6 57 59 49 98 38 87 78 76 3.8 2.9 2.6 2.7 3.8 3.9 3.2 3.1 2.9