EXCL1903_201912012_위한이_129528_assignsubmission_file_EXCL1903_수식_201912012.xlsm

[점수(100점 만점)] : 40

[상세점수] :
[과제(배점:100점)] : 40

[문제] : 과제, D20, [틀림]최대값 구하기 틀림

[정답] : 90	=MAX(H4:H13)

[학생] : 90	90

[문제] : 과제, D19, [틀림]평균 구하기 틀림

[정답] : 79.55	=AVERAGE(H4:H13)

[학생] : 79.55	79.55

[문제] : 과제, D18, [틀림]인원 구하기 틀림

[정답] : 10	=COUNT(H4:H13)

[학생] : 10	10

[문제] : 과제, J4:J13, [틀림]등수 구하기 틀림

[정답] : 	1	=RANK.EQ(H4,$H$4:$H$13)
	4	=RANK.EQ(H5,$H$4:$H$13)
	3	=RANK.EQ(H6,$H$4:$H$13)
	9	=RANK.EQ(H7,$H$4:$H$13)
	7	=RANK.EQ(H8,$H$4:$H$13)
	10	=RANK.EQ(H9,$H$4:$H$13)
	6	=RANK.EQ(H10,$H$4:$H$13)
	5	=RANK.EQ(H11,$H$4:$H$13)
	8	=RANK.EQ(H12,$H$4:$H$13)
	2	=RANK.EQ(H13,$H$4:$H$13)

[학생] : 	1	1
	4	4
	3	3
	9	9
	7	7
	10	10
	6	6
	5	5
	8	8
	2	2