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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!