EXCL1903_201915038_호티프엉_129555_assignsubmission_file_201915038.xlsm
<p>[점수(100점 만점)] : 75</p><p>[상세점수] : <br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[과제(배점:100점)] : 75<br/></p><p>[문제] : <b>과제, J4:J13, <font color=red>[틀림]등수 구하기 틀림</font></b><br/><pre>[정답] : 	1	=RANK.EQ(H4,$H$4:$H$13)
	<font color=red>4	=RANK.EQ(H5,$H$4:$H$13)</font>
	<font color=red>3	=RANK.EQ(H6,$H$4:$H$13)</font>
	<font color=red>9	=RANK.EQ(H7,$H$4:$H$13)</font>
	<font color=red>7	=RANK.EQ(H8,$H$4:$H$13)</font>
	<font color=red>10	=RANK.EQ(H9,$H$4:$H$13)</font>
	<font color=red>6	=RANK.EQ(H10,$H$4:$H$13)</font>
	<font color=red>5	=RANK.EQ(H11,$H$4:$H$13)</font>
	<font color=red>8	=RANK.EQ(H12,$H$4:$H$13)</font>
	<font color=red>2	=RANK.EQ(H13,$H$4:$H$13)</font>
</pre><br/><pre>[학생] : 	1	=RANK(H4,H4:H13)
	3	=RANK(H5,H5:H14)
	2	=RANK(H6,H6:H15)
	6	=RANK(H7,H7:H16)
	4	=RANK(H8,H8:H17)
	5	=RANK(H9,H9:H18)
	3	=RANK(H10,H10:H19)
	2	=RANK(H11,H11:H20)
	2	=RANK(H12,H12:H21)
	1	=RANK(H13,H13:H22)
</pre><br/></p>
<p>[문제] : <b>과제, A4:A13, <font color=red>[틀림]순서를 1~10까지로 수정되지 않음</font></b><br/><pre>[정답] : 	1
	2
	3
	<font color=red>4</font>
	<font color=red>5</font>
	<font color=red>6</font>
	<font color=red>7</font>
	<font color=red>8</font>
	<font color=red>9</font>
	<font color=red>10</font>
</pre><br/><pre>[학생] : 	1
	2
	3
	5
	6
	7
	9
	10
	11
	12
</pre><br/></p>