EXCL1910_201921036_강지은.xlsm
[점수(100점 만점)] : 95
[상세점수] :
[과제1(배점:20점)] : 15
[과제2(배점:30점)] : 30
[과제3(배점:50점)] : 50
[문제] : 과제1, O6:O25, [틀림]최종평가 계산이 틀렸습니다.
[정답] : A =IF(N6>=240,"A",IF(N6>=230,"B","C")) A =IF(N7>=240,"A",IF(N7>=230,"B","C")) C =IF(N8>=240,"A",IF(N8>=230,"B","C")) A =IF(N9>=240,"A",IF(N9>=230,"B","C")) A =IF(N10>=240,"A",IF(N10>=230,"B","C")) C =IF(N11>=240,"A",IF(N11>=230,"B","C")) A =IF(N12>=240,"A",IF(N12>=230,"B","C")) A =IF(N13>=240,"A",IF(N13>=230,"B","C")) A =IF(N14>=240,"A",IF(N14>=230,"B","C")) A =IF(N15>=240,"A",IF(N15>=230,"B","C")) A =IF(N16>=240,"A",IF(N16>=230,"B","C")) A =IF(N17>=240,"A",IF(N17>=230,"B","C")) B =IF(N18>=240,"A",IF(N18>=230,"B","C")) B =IF(N19>=240,"A",IF(N19>=230,"B","C")) B =IF(N20>=240,"A",IF(N20>=230,"B","C")) A =IF(N21>=240,"A",IF(N21>=230,"B","C")) C =IF(N22>=240,"A",IF(N22>=230,"B","C")) A =IF(N23>=240,"A",IF(N23>=230,"B","C")) A =IF(N24>=240,"A",IF(N24>=230,"B","C")) A =IF(N25>=240,"A",IF(N25>=230,"B","C"))
[학생] : A =IF(N6>=240,"A",IF(M6>=130,"B","C")) A =IF(N7>=240,"A",IF(M7>=130,"B","C")) C =IF(N8>=240,"A",IF(M8>=130,"B","C")) A =IF(N9>=240,"A",IF(M9>=130,"B","C")) A =IF(N10>=240,"A",IF(M10>=130,"B","C")) C =IF(N11>=240,"A",IF(M11>=130,"B","C")) A =IF(N12>=240,"A",IF(M12>=130,"B","C")) A =IF(N13>=240,"A",IF(M13>=130,"B","C")) A =IF(N14>=240,"A",IF(M14>=130,"B","C")) A =IF(N15>=240,"A",IF(M15>=130,"B","C")) A =IF(N16>=240,"A",IF(M16>=130,"B","C")) A =IF(N17>=240,"A",IF(M17>=130,"B","C")) C =IF(N18>=240,"A",IF(M18>=130,"B","C")) C =IF(N19>=240,"A",IF(M19>=130,"B","C")) C =IF(N20>=240,"A",IF(M20>=130,"B","C")) A =IF(N21>=240,"A",IF(M21>=130,"B","C")) C =IF(N22>=240,"A",IF(M22>=130,"B","C")) A =IF(N23>=240,"A",IF(M23>=130,"B","C")) A =IF(N24>=240,"A",IF(M24>=130,"B","C")) A =IF(N25>=240,"A",IF(M25>=130,"B","C"))