Question: excel macros in a hypothetical class if a student takes...
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 final’s 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
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.