1. Engineering
2. Computer Science
3. excel macros in a hypothetical class if a student takes...

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

###### Solution by an expert tutor 