(a)

(i)

=AVERAGE(B3:I3)

(ii)

=(SUM(B3:I3)-MAX(B3:I3)-MIN(B3:I3))/6

(iii)

=MAX(J3:K3)

(b)

=COUNTIF(B3:I3,">=40")

(c)

(i)

B3: =MARK!L3

C3: =MARK!M3

(ii)

Ms. Wong should copy the columns L and M in ¡§MARK¡¨ worksheet and paste them into columns B and C in ¡§GRADE¡¨ worksheet by value/Link

(d)

=IF($B3>=$B$44,(IF($C3>=5,¡¨A¡¨,¡¨B¡¨,(IF($C3>,5,¡¨C¡¨,¡¨D¡¨))

(e)

It can be used as¡¨what-if¡¨analysis
The data involved is relatively low

(f)

Sort cells A3 to D41 in ascending order
Enter the following formula in cell address E3 and then copy to cells addresses E4 to E40  =IF(B3=B4,1,0)
Then,Enter the following formula in cell address E43 =IF(SUM(E3:E41)>0,¡¨YES¡¨,¡¨NO¡¨)