EXCL1910_201979022_김가은A.xlsm
<p>[점수(100점 만점)] : 95</p><p>[상세점수] : <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[과제1(배점:20점)] : 15<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[과제2(배점:30점)] : 30<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[과제3(배점:50점)] : 50<br/></p><p>[문제] : <b>과제1, P6:P25, <font color=red>[틀림]결과 계산이 틀렸습니다.</font></b><br/><pre>[정답] : 	Pass	=IF(AND(H6="Pass",O6="A"),"Pass","Fail")
	Pass	=IF(AND(H7="Pass",O7="A"),"Pass","Fail")
	<font color=red>Fail	=IF(AND(H8="Pass",O8="A"),"Pass","Fail")</font>
	Pass	=IF(AND(H9="Pass",O9="A"),"Pass","Fail")
	Pass	=IF(AND(H10="Pass",O10="A"),"Pass","Fail")
	<font color=red>Fail	=IF(AND(H11="Pass",O11="A"),"Pass","Fail")</font>
	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")
	<font color=red>Fail	=IF(AND(H17="Pass",O17="A"),"Pass","Fail")</font>
	<font color=red>Fail	=IF(AND(H18="Pass",O18="A"),"Pass","Fail")</font>
	<font color=red>Fail	=IF(AND(H19="Pass",O19="A"),"Pass","Fail")</font>
	<font color=red>Fail	=IF(AND(H20="Pass",O20="A"),"Pass","Fail")</font>
	Pass	=IF(AND(H21="Pass",O21="A"),"Pass","Fail")
	<font color=red>Fail	=IF(AND(H22="Pass",O22="A"),"Pass","Fail")</font>
	<font color=red>Fail	=IF(AND(H23="Pass",O23="A"),"Pass","Fail")</font>
	Pass	=IF(AND(H24="Pass",O24="A"),"Pass","Fail")
	Pass	=IF(AND(H25="Pass",O25="A"),"Pass","Fail")
</pre><br/><pre>[학생] : 	Pass	=IF(AND(H6="pass",O6="A"),"Pass","Faill")
	Pass	=IF(AND(H7="pass",O7="A"),"Pass","Faill")
	Faill	=IF(AND(H8="pass",O8="A"),"Pass","Faill")
	Pass	=IF(AND(H9="pass",O9="A"),"Pass","Faill")
	Pass	=IF(AND(H10="pass",O10="A"),"Pass","Faill")
	Faill	=IF(AND(H11="pass",O11="A"),"Pass","Faill")
	Pass	=IF(AND(H12="pass",O12="A"),"Pass","Faill")
	Pass	=IF(AND(H13="pass",O13="A"),"Pass","Faill")
	Pass	=IF(AND(H14="pass",O14="A"),"Pass","Faill")
	Pass	=IF(AND(H15="pass",O15="A"),"Pass","Faill")
	Pass	=IF(AND(H16="pass",O16="A"),"Pass","Faill")
	Faill	=IF(AND(H17="pass",O17="A"),"Pass","Faill")
	Faill	=IF(AND(H18="pass",O18="A"),"Pass","Faill")
	Faill	=IF(AND(H19="pass",O19="A"),"Pass","Faill")
	Faill	=IF(AND(H20="pass",O20="A"),"Pass","Faill")
	Pass	=IF(AND(H21="pass",O21="A"),"Pass","Faill")
	Faill	=IF(AND(H22="pass",O22="A"),"Pass","Faill")
	Faill	=IF(AND(H23="pass",O23="A"),"Pass","Faill")
	Pass	=IF(AND(H24="pass",O24="A"),"Pass","Faill")
	Pass	=IF(AND(H25="pass",O25="A"),"Pass","Faill")
</pre><br/></p>