Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle9i Database Administrator Implementation And Administration

Authors: Carol McCullough-Dieter

1st Edition

0619159006, 978-0619159009

More Books

Students also viewed these Databases questions

Question

1. Traditional and modern methods of preserving food Articles ?

Answered: 1 week ago

Question

What is sociology and its nature ?

Answered: 1 week ago

Question

What is liquidation ?

Answered: 1 week ago

Question

Explain the different types of Mergers.

Answered: 1 week ago