The first midterm, second midterm, and comp scores are listed in columns 8, 9, and 10, respectively. Using the following subroutine:

Sub fillingIt()

For i = 3 To 30

mid1 = Cells(i, 9)

mid2 = Cells(i, 9)

comp = Cells(i, 9)

Cells(i, 11) = calScores(mid1, mid2, comp)

Next i

End Sub

The following column is filled with the function output

A)11

B)9

C)8

D)7