EXCL1905_201960036_이동원_132965_assignsubmission_file_201960036 이동원.xlsm
[점수(100점 만점)] : 80
[상세점수] :
[과제(배점:100점)] : 80
[문제] : 과제, P10:P18, [틀림]인원이 틀렸습니다.
[정답] : 2 =COUNTIF($J$4:$J$33,O10) 3 =COUNTIF($J$4:$J$33,O11) 3 =COUNTIF($J$4:$J$33,O12) 5 =COUNTIF($J$4:$J$33,O13) 8 =COUNTIF($J$4:$J$33,O14) 4 =COUNTIF($J$4:$J$33,O15) 3 =COUNTIF($J$4:$J$33,O16) 1 =COUNTIF($J$4:$J$33,O17) 1 =COUNTIF($J$4:$J$33,O18)
[학생] : 2 =COUNTIF(J4:J33,O10) 3 =COUNTIF(J5:J34,O11) 3 =COUNTIF(J6:J35,O12) 5 =COUNTIF(J7:J36,O13) 8 =COUNTIF(J8:J37,O14) 3 =COUNTIF(J9:J38,O15) 2 =COUNTIF(J10:J39,O16) 1 =COUNTIF(J11:J40,O17) 0 =COUNTIF(J12:J41,O18)
[문제] : 과제, K4:K33, [틀림]등수 계산이 틀렸습니다.
[정답] : 1 =RANK.EQ(I4,$I$4:$I$33) 4 =RANK.EQ(I5,$I$4:$I$33) 6 =RANK.EQ(I6,$I$4:$I$33) 19 =RANK.EQ(I7,$I$4:$I$33) 28 =RANK.EQ(I8,$I$4:$I$33) 11 =RANK.EQ(I9,$I$4:$I$33) 26 =RANK.EQ(I10,$I$4:$I$33) 14 =RANK.EQ(I11,$I$4:$I$33) 22 =RANK.EQ(I12,$I$4:$I$33) 8 =RANK.EQ(I13,$I$4:$I$33) 14 =RANK.EQ(I14,$I$4:$I$33) 2 =RANK.EQ(I15,$I$4:$I$33) 3 =RANK.EQ(I16,$I$4:$I$33) 26 =RANK.EQ(I17,$I$4:$I$33) 16 =RANK.EQ(I18,$I$4:$I$33) 20 =RANK.EQ(I19,$I$4:$I$33) 9 =RANK.EQ(I20,$I$4:$I$33) 21 =RANK.EQ(I21,$I$4:$I$33) 24 =RANK.EQ(I22,$I$4:$I$33) 11 =RANK.EQ(I23,$I$4:$I$33) 17 =RANK.EQ(I24,$I$4:$I$33) 10 =RANK.EQ(I25,$I$4:$I$33) 18 =RANK.EQ(I26,$I$4:$I$33) 7 =RANK.EQ(I27,$I$4:$I$33) 30 =RANK.EQ(I28,$I$4:$I$33) 13 =RANK.EQ(I29,$I$4:$I$33) 5 =RANK.EQ(I30,$I$4:$I$33) 29 =RANK.EQ(I31,$I$4:$I$33) 23 =RANK.EQ(I32,$I$4:$I$33) 25 =RANK.EQ(I33,$I$4:$I$33)
[학생] : 1 =RANK(I4,I4:I33) 3 =RANK(I5,I5:I34) 4 =RANK(I6,I6:I35) 16 =RANK(I7,I7:I36) 24 =RANK(I8,I8:I37) 8 =RANK(I9,I9:I38) 21 =RANK(I10,I10:I39) 10 =RANK(I11,I11:I40) 16 =RANK(I12,I12:I41) 5 =RANK(I13,I13:I42) 9 =RANK(I14,I14:I43) 1 =RANK(I15,I15:I44) 1 =RANK(I16,I16:I45) 15 =RANK(I17,I17:I46) 7 =RANK(I18,I18:I47) 9 =RANK(I19,I19:I48) 3 =RANK(I20,I20:I49) 8 =RANK(I21,I21:I50) 9 =RANK(I22,I22:I51) 4 =RANK(I23,I23:I52) 5 =RANK(I24,I24:I53) 3 =RANK(I25,I25:I54) 4 =RANK(I26,I26:I55) 2 =RANK(I27,I27:I56) 6 =RANK(I28,I28:I57) 2 =RANK(I29,I29:I58) 1 =RANK(I30,I30:I59) 3 =RANK(I31,I31:I60) 1 =RANK(I32,I32:I61) 1 =RANK(I33,I33:I62)