EXCL1902_201922002_구가을_128564_assignsubmission_file_EXCL1902_데이터입력.xlsm
<p>[점수(100점 만점)] : 55</p><p>[상세점수] : <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[과제(배점:100점)] : 55<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>[정답] : 	<font color=red>55	=MIN(D4:D23)</font>	<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>[학생] : 												
</pre><br/></p>
<p>[문제] : <b>과제, D26:I26, <font color=red>[틀림]최고값 틀림</font></b><br/><pre>[정답] : 	<font color=red>100	=MAX(D4:D23)</font>	<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>[학생] : 	55	=MIN(D4:D23)	55	=MIN(E4:E23)	55	=MIN(F4:F23)	45	=MIN(G4:G23)	265	=MIN(H4:H23)	66.25	=MIN(I4:I23)
</pre><br/></p>
<p>[문제] : <b>과제, D25:I25, <font color=red>[틀림]평균 틀림</font></b><br/><pre>[정답] : 	<font color=red>80.5	=AVERAGE(D4:D23)</font>	<font color=red>76.5	=AVERAGE(E4:E23)</font>	<font color=red>82	=AVERAGE(F4:F23)</font>	<font color=red>73	=AVERAGE(G4:G23)</font>	<font color=red>312	=AVERAGE(H4:H23)</font>	<font color=red>78	=AVERAGE(I4:I23)</font>
</pre><br/><pre>[학생] : 	100	=MAX(D4:D23)	100	=MAX(E4:E24)	100	=MAX(F4:F24)	100	=MAX(G4:G24)	360	=MAX(H4:H24)	90	=MAX(I4:I24)
</pre><br/></p>