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)