# Question: excel macros in a hypothetical class if a student takes...

###### Question details

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 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
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.