EXCL1910_201935022_조희진.xlsm
[점수(100점 만점)] : 95
[상세점수] :
[과제1(배점:20점)] : 20
[과제2(배점:30점)] : 25
[과제3(배점:50점)] : 50
[문제] : 과제2, E23:I23, [틀림]상의 개수 계산이 틀렸습니다.
[정답] : 7 =COUNTIF(E3:E22,"상") 8 =COUNTIF(F3:F22,"상") 3 =COUNTIF(G3:G22,"상") 7 =COUNTIF(H3:H22,"상") 4 =COUNTIF(I3:I22,"상")
[학생] : 7 =COUNTIF(E3:E22,E3) 8 =COUNTIF(F3:F22,F3) 7 =COUNTIF(G3:G22,G3) 9 =COUNTIF(H3:H22,H3) 7 =COUNTIF(I3:I22,I3)