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