[점수(100점 만점)] : 95
[상세점수] :
[과제1(배점:20점)] : 15
[과제2(배점:30점)] : 30
[과제3(배점:50점)] : 50
[문제] : 과제1, P6:P25, [틀림]결과 계산이 틀렸습니다.
[정답] : Pass =IF(AND(H6="Pass",O6="A"),"Pass","Fail") Pass =IF(AND(H7="Pass",O7="A"),"Pass","Fail") Fail =IF(AND(H8="Pass",O8="A"),"Pass","Fail") Pass =IF(AND(H9="Pass",O9="A"),"Pass","Fail") Pass =IF(AND(H10="Pass",O10="A"),"Pass","Fail") Fail =IF(AND(H11="Pass",O11="A"),"Pass","Fail") Pass =IF(AND(H12="Pass",O12="A"),"Pass","Fail") Pass =IF(AND(H13="Pass",O13="A"),"Pass","Fail") Pass =IF(AND(H14="Pass",O14="A"),"Pass","Fail") Pass =IF(AND(H15="Pass",O15="A"),"Pass","Fail") Pass =IF(AND(H16="Pass",O16="A"),"Pass","Fail") Fail =IF(AND(H17="Pass",O17="A"),"Pass","Fail") Fail =IF(AND(H18="Pass",O18="A"),"Pass","Fail") Fail =IF(AND(H19="Pass",O19="A"),"Pass","Fail") Fail =IF(AND(H20="Pass",O20="A"),"Pass","Fail") Pass =IF(AND(H21="Pass",O21="A"),"Pass","Fail") Fail =IF(AND(H22="Pass",O22="A"),"Pass","Fail") Fail =IF(AND(H23="Pass",O23="A"),"Pass","Fail") Pass =IF(AND(H24="Pass",O24="A"),"Pass","Fail") Pass =IF(AND(H25="Pass",O25="A"),"Pass","Fail")
[학생] : Pass =IF(O6="A","Pass","Fail") Pass =IF(O7="A","Pass","Fail") Fail =IF(O8="A","Pass","Fail") Pass =IF(O9="A","Pass","Fail") Pass =IF(O10="A","Pass","Fail") Fail =IF(O11="A","Pass","Fail") Pass =IF(O12="A","Pass","Fail") Pass =IF(O13="A","Pass","Fail") Pass =IF(O14="A","Pass","Fail") Pass =IF(O15="A","Pass","Fail") Pass =IF(O16="A","Pass","Fail") Pass =IF(O17="A","Pass","Fail") Fail =IF(O18="A","Pass","Fail") Fail =IF(O19="A","Pass","Fail") Fail =IF(O20="A","Pass","Fail") Pass =IF(O21="A","Pass","Fail") Fail =IF(O22="A","Pass","Fail") Pass =IF(O23="A","Pass","Fail") Pass =IF(O24="A","Pass","Fail") Pass =IF(O25="A","Pass","Fail")