Excel 2005 Q9

(a)	(i)	=LARGE(D3:J3,3)+LARGE(D3:J3,4)+LARGE(D3:J3,5)
	(ii)	=RANK($K3,$K$2:$K$41)
(b)	(i)	=SUMIF($C$2:$C$41,$A45,$L$2:$L$41)
	(ii)	=COUNTIF($C$2:$C$41,$A45)
(c)		IF(C45=0,100,ROUND(B45/C45,2))
(d)		找出最低學社平均分，將每一個學社平均分與最低的比較， 將勝出者的名字連接起來 =CONCATENATE(IF(D44:MIN(D44:D47),A44,””),IF(D45:MIN(D44:D47),A45,””),IF(D46:MIN(D44:D47),A46,::),IF(D47:MIN(D44:D47,””))
(e)		步驟1：排序總評分 步驟2：排序學社和性別
(f)		利用自動數據篩選功能，在學社欄選擇條件"學社=A"(即欄C) 在名次欄選擇條件"5<=名次<=30"(即欄L)

Find out the smallest average marks of all institutes, compare the average mark and