EXCL1906_201960034_최원석_134701_assignsubmission_file_EXCL1906_201960034 최원석.xlsm
[점수(100점 만점)] : 90
[상세점수] :
[과제(배점:100점)] : 90
[문제] : 과제, P14:P23, [틀림]학생수 계산이 틀렸습니다.
[정답] : 5 =COUNTIF($B$4:$B$33,N14) 2 =COUNTIF($B$4:$B$33,N15) 2 =COUNTIF($B$4:$B$33,N16) 2 =COUNTIF($B$4:$B$33,N17) 5 =COUNTIF($B$4:$B$33,N18) 3 =COUNTIF($B$4:$B$33,N19) 2 =COUNTIF($B$4:$B$33,N20) 2 =COUNTIF($B$4:$B$33,N21) 4 =COUNTIF($B$4:$B$33,N22) 3 =COUNTIF($B$4:$B$33,N23)
[학생] : 5 =COUNTIF($C$4:$C$33,O14) S S 2 =COUNTIF($C$4:$C$33,O16) 2 =COUNTIF($C$4:$C$33,O17) 5 =COUNTIF($C$4:$C$33,O18) 3 =COUNTIF($C$4:$C$33,O19) 2 =COUNTIF($C$4:$C$33,O20) 2 =COUNTIF($C$4:$C$33,O21) 4 =COUNTIF($C$4:$C$33,O22) 3 =COUNTIF($C$4:$C$33,O23)