EXCL1904_201979033_이소현_131843_assignsubmission_file_201979033 이소현.xlsm
[점수(100점 만점)] : 90
[상세점수] :
[과제(배점:100점)] : 90
[문제] : 과제, O10:O18, [틀림]인원이 틀렸습니다.
[정답] : 2 =COUNTIF($J$4:$J$33,N10) 3 =COUNTIF($J$4:$J$33,N11) 3 =COUNTIF($J$4:$J$33,N12) 5 =COUNTIF($J$4:$J$33,N13) 8 =COUNTIF($J$4:$J$33,N14) 4 =COUNTIF($J$4:$J$33,N15) 3 =COUNTIF($J$4:$J$33,N16) 1 =COUNTIF($J$4:$J$33,N17) 1 =COUNTIF($J$4:$J$33,N18)
[학생] : 2 =COUNTIF(J4:J33,N10:N18) 3 =COUNTIF(J5:J34,N11:N19) 3 =COUNTIF(J6:J35,N12:N20) 5 =COUNTIF(J7:J36,N13:N21) 8 =COUNTIF(J8:J37,N14:N22) 3 =COUNTIF(J9:J38,N15:N23) 2 =COUNTIF(J10:J39,N16:N24) 1 =COUNTIF(J11:J40,N17:N25) 0 =COUNTIF(J12:J41,N18:N26)