Question
Regarding the following function: Function calScores(mid1, mid2, comp) highscore = WorksheetFunction.Max(mid1, mid2) lowscore = WorksheetFunction.Min(mid1, mid2) If comp > 102 Then If comp > highscore
Regarding the following function:
Function calScores(mid1, mid2, comp)
highscore = WorksheetFunction.Max(mid1, mid2)
lowscore = WorksheetFunction.Min(mid1, mid2)
If comp > 102 Then
If comp > highscore Then
highscore = 2* highscore - lowscore
lowscore = comp
comp = comp + 5
ElseIf comp > lowscore Then
lowscore = comp
End If
avg = (lowscore + highscore + comp) / 3
Else
avg = (lowscore + highscore) / 2
End If
calScores = avg
End Function
A student who scored 80, 95, and 98 in his mid1, mid2, and comp exams, respectively, will have a final score of:
A) 87.5
B) 97.0
C) 98.7
D) 96.0
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started