EXCL1902_201922019_정보석_128559_assignsubmission_file_EXCL1902_데이터입력 (1).xlsm
<p>[점수(100점 만점)] : 60</p><p>[상세점수] : <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[과제(배점:100점)] : 60<br/></p><p>[문제] : <b>과제, A1, <font color=red>[틀림]특수문자(태극무늬) 틀림</font></b><br/>[정답] : <font color=red>♣2018년 A高等學校 반편성 시험J</font><br/>[학생] : 2018년 A高等學校 반편성 시험<br/></p>
<p>[문제] : <b>과제, A1, <font color=red>[틀림]특수문자(하트) 틀림</font></b><br/>[정답] : <font color=red>♣2018년 A高等學校 반편성 시험J</font><br/>[학생] : 2018년 A高等學校 반편성 시험<br/></p>
<p>[문제] : <b>과제, D27:I27, <font color=red>[틀림]최저값 틀림</font></b><br/><pre>[정답] : 	55	=MIN(D4:D23)	55	=MIN(E4:E23)	55	=MIN(F4:F23)	45	=MIN(G4:G23)	<font color=red>265	=MIN(H4:H23)</font>	<font color=red>66.25	=MIN(I4:I23)</font>
</pre><br/><pre>[학생] : 	55	=MIN(D4:D23)	55	=MIN(E4:E23)	55	=MIN(F6:F26)	45	=MIN(G4:G23)				
</pre><br/></p>
<p>[문제] : <b>과제, D26:I26, <font color=red>[틀림]최고값 틀림</font></b><br/><pre>[정답] : 	100	=MAX(D4:D23)	100	=MAX(E4:E23)	100	=MAX(F4:F23)	100	=MAX(G4:G23)	<font color=red>360	=MAX(H4:H23)</font>	<font color=red>90	=MAX(I4:I23)</font>
</pre><br/><pre>[학생] : 	100	=MAX(D4:D23)	100	=MAX(E4:E23)	100	=MAX(F4:F23)	100	=MAX(G4:G23)				
</pre><br/></p>
<p>[문제] : <b>과제, D25:I25, <font color=red>[틀림]평균 틀림</font></b><br/><pre>[정답] : 	80.5	=AVERAGE(D4:D23)	76.5	=AVERAGE(E4:E23)	82	=AVERAGE(F4:F23)	73	=AVERAGE(G4:G23)	<font color=red>312	=AVERAGE(H4:H23)</font>	<font color=red>78	=AVERAGE(I4:I23)</font>
</pre><br/><pre>[학생] : 	80.5	=AVERAGE(D4:D23)	76.5	=AVERAGE(E4:E23)	82	=AVERAGE(F4:F23)	73	=AVERAGE(G4:G23)				
</pre><br/></p>