EXCL1902_201979004_김세희_128746_assignsubmission_file_EXCL1902_데이터입력.xlsm
<p>[점수(100점 만점)] : 60</p><p>[상세점수] : <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[과제(배점:100점)] : 60<br/></p><p>[문제] : <b>과제, C4:C13, <font color=red>[틀림]한자변환 안됨(中學校)</font></b><br/><pre>[정답] : 	<font color=red>D中學校</font>
	<font color=red>B中學校</font>
	<font color=red>D中學校</font>
	<font color=red>D中學校</font>
	<font color=red>C中學校</font>
	<font color=red>D中學校</font>
	<font color=red>B中學校</font>
	<font color=red>A中學校</font>
	<font color=red>A中學校</font>
	<font color=red>C中學校</font>
</pre><br/><pre>[학생] : 	D중학교
	B중학교
	D중학교
	D중학교
	C중학교
	D중학교
	B중학교
	A중학교
	A중학교
	C중학교
</pre><br/></p>
<p>[문제] : <b>과제, D27:I27, <font color=red>[틀림]최저값 틀림</font></b><br/><pre>[정답] : 	55	=MIN(D4:D23)	<font color=red>55	=MIN(E4:E23)</font>	<font color=red>55	=MIN(F4:F23)</font>	<font color=red>45	=MIN(G4:G23)</font>	<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	55	55	55	45	45	265	265	66	66
</pre><br/></p>
<p>[문제] : <b>과제, D26:I26, <font color=red>[틀림]최고값 틀림</font></b><br/><pre>[정답] : 	100	=MAX(D4:D23)	<font color=red>100	=MAX(E4:E23)</font>	<font color=red>100	=MAX(F4:F23)</font>	<font color=red>100	=MAX(G4:G23)</font>	<font color=red>360	=MAX(H4:H23)</font>	<font color=red>90	=MAX(I4:I23)</font>
</pre><br/><pre>[학생] : 	100	=MAX(D4:D23)	100	100	100	100	100	100	360	360	90	90
</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)	312	=AVERAGE(H4:H23)	<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)	312	=AVERAGE(H4:H23)	78	78
</pre><br/></p>