EXCL1911_201914034_서고운.xlsm
[점수(100점 만점)] : 77.5
[상세점수] :
[과제(배점:100점)] : 77.5
[문제] : 과제, S12:S18, [틀림]학생수 계산이 틀렸습니다.
[정답] : 16 =COUNTIF($D$4:$D$103,R12) 18 =COUNTIF($D$4:$D$103,R13) 20 =COUNTIF($D$4:$D$103,R14) 15 =COUNTIF($D$4:$D$103,R15) 11 =COUNTIF($D$4:$D$103,R16) 9 =COUNTIF($D$4:$D$103,R17) 11 =COUNTIF($D$4:$D$103,R18)
[학생] : 16 =COUNTIF(D4:D103,$R$12:$R$18) 18 =COUNTIF(D5:D104,$R$12:$R$18) 18 =COUNTIF(D6:D105,$R$12:$R$18) 15 =COUNTIF(D7:D106,$R$12:$R$18) 11 =COUNTIF(D8:D107,$R$12:$R$18) 9 =COUNTIF(D9:D108,$R$12:$R$18) 11 =COUNTIF(D10:D109,$R$12:$R$18)
[문제] : 과제, T12:T18, [틀림]평균점수 계산이 틀렸습니다.
[정답] : 79.359375 =AVERAGEIF($D$4:$D$103,R12,$J$4:$J$103) 80.9166666666667 =AVERAGEIF($D$4:$D$103,R13,$J$4:$J$103) 72.0875 =AVERAGEIF($D$4:$D$103,R14,$J$4:$J$103) 78.4333333333333 =AVERAGEIF($D$4:$D$103,R15,$J$4:$J$103) 77.7954545454545 =AVERAGEIF($D$4:$D$103,R16,$J$4:$J$103) 74.25 =AVERAGEIF($D$4:$D$103,R17,$J$4:$J$103) 81.5454545454545 =AVERAGEIF($D$4:$D$103,R18,$J$4:$J$103)
[학생] : 72.0875 =AVERAGEIF($D$4:$D$103,R14,$J$4:$J$103) 62.25 =AVERAGEIF($R$12:$R$18,R13,$J$4:$J$103) 73.25 =AVERAGEIF($R$12:$R$18,R14,$J$4:$J$103) 75.25 =AVERAGEIF($R$12:$R$18,R15,$J$4:$J$103) 64.25 =AVERAGEIF($R$12:$R$18,R16,$J$4:$J$103) 72.25 =AVERAGEIF($R$12:$R$18,R17,$J$4:$J$103) 59.75 =AVERAGEIF($R$12:$R$18,R18,$J$4:$J$103)
[문제] : 과제, True, [틀림]차트 범례 위치가 틀렸습니다.
[정답] : xlLegendPositionTop
[학생] : xlLegendPositionBottom
[문제] : 과제, True, [틀림]축의 최소값이 틀렸습니다.
[정답] : 0,50,,
[학생] : 5,50,,
[문제] : 과제, True, [틀림]차트의 데이터레이블이 틀렸습니다.
[정답] : ,, 20 ,,,,,,,,,,,81.55,
[학생] : ,,,,,,,,,,,,,,