EXCL1909_201960030_김윤지__KimYoonJi.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,$J$4:$J$32)
	4	=RANK(J5,$J$4:$J$32)
	6	=RANK(J6,$J$4:$J$32)
	17	=RANK(J7,$J$4:$J$32)
	25	=RANK(J8,$J$4:$J$32)
	10	=RANK(J9,$J$4:$J$32)
	23	=RANK(J10,$J$4:$J$32)
	29	=RANK(J11,$J$4:$J$32)
	20	=RANK(J12,$J$4:$J$32)
	8	=RANK(J13,$J$4:$J$32)
	13	=RANK(J14,$J$4:$J$32)
	2	=RANK(J15,$J$4:$J$32)
	3	=RANK(J16,$J$4:$J$32)
	23	=RANK(J17,$J$4:$J$32)
	14	=RANK(J18,$J$4:$J$32)
	18	=RANK(J19,$J$4:$J$32)
	9	=RANK(J20,$J$4:$J$32)
	19	=RANK(J21,$J$4:$J$32)
	22	=RANK(J22,$J$4:$J$32)
	10	=RANK(J23,$J$4:$J$32)
	15	=RANK(J24,$J$4:$J$32)
	28	=RANK(J25,$J$4:$J$32)
	16	=RANK(J26,$J$4:$J$32)
	7	=RANK(J27,$J$4:$J$32)
	27	=RANK(J28,$J$4:$J$32)
	12	=RANK(J29,$J$4:$J$32)
	5	=RANK(J30,$J$4:$J$32)
	26	=RANK(J31,$J$4:$J$32)
	21	=RANK(J32,$J$4:$J$32)
	-2146826246	=RANK(J33,$J$4:$J$32)