EXCL1909_201923046_고란화_.xlsm

[점수(100점 만점)] : 95

[상세점수] :
        [과제3(배점:100점)] : 95

[문제] : 과제3, L4:L33, [틀림]등수 계산이 틀렸습니다.

[정답] : 	1	=RANK(J4,$J$4:$J$33)
	4	=RANK(J5,$J$4:$J$33)
	6	=RANK(J6,$J$4:$J$33)
	17	=RANK(J7,$J$4:$J$33)
	26	=RANK(J8,$J$4:$J$33)
	10	=RANK(J9,$J$4:$J$33)
	24	=RANK(J10,$J$4:$J$33)
	30	=RANK(J11,$J$4:$J$33)
	20	=RANK(J12,$J$4:$J$33)
	8	=RANK(J13,$J$4:$J$33)
	13	=RANK(J14,$J$4:$J$33)
	2	=RANK(J15,$J$4:$J$33)
	3	=RANK(J16,$J$4:$J$33)
	24	=RANK(J17,$J$4:$J$33)
	14	=RANK(J18,$J$4:$J$33)
	18	=RANK(J19,$J$4:$J$33)
	9	=RANK(J20,$J$4:$J$33)
	19	=RANK(J21,$J$4:$J$33)
	22	=RANK(J22,$J$4:$J$33)
	10	=RANK(J23,$J$4:$J$33)
	15	=RANK(J24,$J$4:$J$33)
	29	=RANK(J25,$J$4:$J$33)
	16	=RANK(J26,$J$4:$J$33)
	7	=RANK(J27,$J$4:$J$33)
	28	=RANK(J28,$J$4:$J$33)
	12	=RANK(J29,$J$4:$J$33)
	5	=RANK(J30,$J$4:$J$33)
	27	=RANK(J31,$J$4:$J$33)
	21	=RANK(J32,$J$4:$J$33)
	23	=RANK(J33,$J$4:$J$33)

[학생] : 	1	=RANK(J4,J4:J33)
	3	=RANK(J5,J5:J34)
	4	=RANK(J6,J6:J35)
	14	=RANK(J7,J7:J36)
	22	=RANK(J8,J8:J37)
	7	=RANK(J9,J9:J38)
	19	=RANK(J10,J10:J39)
	23	=RANK(J11,J11:J40)
	15	=RANK(J12,J12:J41)
	5	=RANK(J13,J13:J42)
	8	=RANK(J14,J14:J43)
	1	=RANK(J15,J15:J44)
	1	=RANK(J16,J16:J45)
	14	=RANK(J17,J17:J46)
	6	=RANK(J18,J18:J47)
	8	=RANK(J19,J19:J48)
	3	=RANK(J20,J20:J49)
	7	=RANK(J21,J21:J50)
	8	=RANK(J22,J22:J51)
	3	=RANK(J23,J23:J52)
	4	=RANK(J24,J24:J53)
	9	=RANK(J25,J25:J54)
	4	=RANK(J26,J26:J55)
	2	=RANK(J27,J27:J56)
	6	=RANK(J28,J28:J57)
	2	=RANK(J29,J29:J58)
	1	=RANK(J30,J30:J59)
	3	=RANK(J31,J31:J60)
	1	=RANK(J32,J32:J61)
	1	=RANK(J33,J33:J62)