EXCL1906_201922051_신나연_134474_assignsubmission_file_EXCL1906_ 201922051 신나연.xlsm

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

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

[문제] : 과제, True, [틀림]축의 최대값이 틀렸습니다.
[정답] : 6,100
[학생] : 6,90

[문제] : 과제, True, [틀림]축의 주단위가 틀렸습니다.
[정답] : 1,20
[학생] : 1,10

[문제] : 과제, True, [틀림]차트 범례 위치가 틀렸습니다.
[정답] : xlLegendPositionTop
[학생] : xlLegendPositionCustom

[문제] : 과제, Q14:Q23, [틀림]평균점수 계산이 틀렸습니다.

[정답] : 	68.26	=AVERAGEIF($B$4:$B$33,N14,$J$4:$J$33)
	79.3	=AVERAGEIF($B$4:$B$33,N15,$J$4:$J$33)
	83.15	=AVERAGEIF($B$4:$B$33,N16,$J$4:$J$33)
	71.3	=AVERAGEIF($B$4:$B$33,N17,$J$4:$J$33)
	77.48	=AVERAGEIF($B$4:$B$33,N18,$J$4:$J$33)
	76.9333333333333	=AVERAGEIF($B$4:$B$33,N19,$J$4:$J$33)
	81.95	=AVERAGEIF($B$4:$B$33,N20,$J$4:$J$33)
	81.5	=AVERAGEIF($B$4:$B$33,N21,$J$4:$J$33)
	69.225	=AVERAGEIF($B$4:$B$33,N22,$J$4:$J$33)
	78.4	=AVERAGEIF($B$4:$B$33,N23,$J$4:$J$33)

[학생] : 	68.26	=AVERAGEIF(C4:C33,O14,J4:J33)
	79.3	=AVERAGEIF(C5:C34,O15,J5:J34)
	70.5	=AVERAGEIF(C6:C35,O16,J6:J35)
	71.3	=AVERAGEIF(C7:C36,O17,J7:J36)
	74.675	=AVERAGEIF(C8:C37,O18,J8:J37)
	73	=AVERAGEIF(C9:C38,O19,J9:J38)
	81.95	=AVERAGEIF(C10:C39,O20,J10:J39)
	81.5	=AVERAGEIF(C11:C40,O21,J11:J40)
	69.225	=AVERAGEIF(C4:C33,O22,J4:J33)
	78.4	=AVERAGEIF(C13:C42,O23,J13:J42)

[문제] : 과제, P14:P23, [틀림]학생수 계산이 틀렸습니다.

[정답] : 	5	=COUNTIF($B$4:$B$33,N14)
	2	=COUNTIF($B$4:$B$33,N15)
	2	=COUNTIF($B$4:$B$33,N16)
	2	=COUNTIF($B$4:$B$33,N17)
	5	=COUNTIF($B$4:$B$33,N18)
	3	=COUNTIF($B$4:$B$33,N19)
	2	=COUNTIF($B$4:$B$33,N20)
	2	=COUNTIF($B$4:$B$33,N21)
	4	=COUNTIF($B$4:$B$33,N22)
	3	=COUNTIF($B$4:$B$33,N23)

[학생] : 	5	5
	2	2
	2	2
	2	2
	5	5
	3	3
	2	2
	2	2
	4	4
	3	3