EXCL1910_201979018_한승우 .xlsm
<p>[점수(100점 만점)] : 87.5</p><p>[상세점수] : <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[과제1(배점:20점)] : 20<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[과제2(배점:30점)] : 20<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[과제3(배점:50점)] : 47.5<br/></p><p>[문제] : <b>과제2, E23:I23, <font color=red>[틀림]상의 개수 계산이 틀렸습니다.</font></b><br/><pre>[정답] : 	<font color=red>7	=COUNTIF(E3:E22,"상")</font>	<font color=red>8	=COUNTIF(F3:F22,"상")</font>	<font color=red>3	=COUNTIF(G3:G22,"상")</font>	<font color=red>7	=COUNTIF(H3:H22,"상")</font>	<font color=red>4	=COUNTIF(I3:I22,"상")</font>
</pre><br/><pre>[학생] : 										
</pre><br/></p>
<p>[문제] : <b>과제2, J24, <font color=red>[틀림]30점 이상 평균 계산이 틀렸습니다.</font></b><br/><pre>[정답] : <font color=red>36.1666666666667	=AVERAGEIF(J3:J22,">=30")</font></pre><br/>[학생] : <br/></p>
<p>[문제] : <b>과제3, True, <font color=red>[틀림]차트종류가 틀렸습니다</font></b><br/>[정답] : <font color=red>xlColumnClusteredxlLineMarkers</font><br/>[학생] : xlColumnClusteredxlLineMarkersStacked<br/></p>