[점수(100점 만점)] : 25
[상세점수] :
[과제(배점:100점)] : 25
[문제] : 과제, True, [틀림]차트의 데이터레이블이 틀렸습니다.
[정답] : ,,,,,,,,,,,,,,,,81.95,,69.23,,
[학생] :
[문제] : 과제, True, [틀림]축의 최대값이 틀렸습니다.
[정답] : 6,100
[학생] :
[문제] : 과제, True, [틀림]축의 주단위가 틀렸습니다.
[정답] : 1,20
[학생] :
[문제] : 과제, True, [틀림]차트 범례 위치가 틀렸습니다.
[정답] : xlLegendPositionTop
[학생] :
[문제] : 과제, True, [틀림]차트제목이 틀렸습니다.
[정답] : 학과코드별 학생수와 평균
[학생] :
[문제] : 과제, True, [틀림]차트의 데이터값이 틀렸습니다.
[정답] : =SERIES(과제!$P$13,과제!$N$14:$N$23,과제!$P$14:$P$23,1)=SERIES(과제!$Q$13,과제!$N$14:$N$23,과제!$Q$14:$Q$23,2)
[학생] :
[문제] : 과제, True, [틀림]차트의 시리즈에 대한 축이 틀렸습니다.
[정답] : xlPrimaryxlSecondary
[학생] :
[문제] : 과제, True, [틀림]차트종류가 틀렸습니다
[정답] : xlColumnClusteredxlLineMarkers
[학생] :
[문제] : 과제, 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 68.26 79.3 79.3 83.15 83.15 71.3 71.3 77.48 77.48 76.93 76.93 81.95 81.95 81.5 81.5 69.23 69.23 78.4 78.4
[문제] : 과제, 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
[문제] : 과제, J4:J33, [틀림]점수 계산이 틀렸습니다.
[정답] : 95.8 =SUMPRODUCT(F4:I4,$N$5:$Q$5) 88.7 =SUMPRODUCT(F5:I5,$N$5:$Q$5) 84.8 =SUMPRODUCT(F6:I6,$N$5:$Q$5) 72.4 =SUMPRODUCT(F7:I7,$N$5:$Q$5) 60.3 =SUMPRODUCT(F8:I8,$N$5:$Q$5) 78.7 =SUMPRODUCT(F9:I9,$N$5:$Q$5) 63.5 =SUMPRODUCT(F10:I10,$N$5:$Q$5) 76.1 =SUMPRODUCT(F11:I11,$N$5:$Q$5) 70.4 =SUMPRODUCT(F12:I12,$N$5:$Q$5) 82.5 =SUMPRODUCT(F13:I13,$N$5:$Q$5) 76.1 =SUMPRODUCT(F14:I14,$N$5:$Q$5) 94.6 =SUMPRODUCT(F15:I15,$N$5:$Q$5) 88.8 =SUMPRODUCT(F16:I16,$N$5:$Q$5) 63.5 =SUMPRODUCT(F17:I17,$N$5:$Q$5) 75.3 =SUMPRODUCT(F18:I18,$N$5:$Q$5) 71.9 =SUMPRODUCT(F19:I19,$N$5:$Q$5) 82.1 =SUMPRODUCT(F20:I20,$N$5:$Q$5) 70.5 =SUMPRODUCT(F21:I21,$N$5:$Q$5) 66.3 =SUMPRODUCT(F22:I22,$N$5:$Q$5) 78.7 =SUMPRODUCT(F23:I23,$N$5:$Q$5) 75.1 =SUMPRODUCT(F24:I24,$N$5:$Q$5) 79.9 =SUMPRODUCT(F25:I25,$N$5:$Q$5) 72.8 =SUMPRODUCT(F26:I26,$N$5:$Q$5) 83.6 =SUMPRODUCT(F27:I27,$N$5:$Q$5) 56.9 =SUMPRODUCT(F28:I28,$N$5:$Q$5) 77.1 =SUMPRODUCT(F29:I29,$N$5:$Q$5) 87.7 =SUMPRODUCT(F30:I30,$N$5:$Q$5) 59.9 =SUMPRODUCT(F31:I31,$N$5:$Q$5) 66.5 =SUMPRODUCT(F32:I32,$N$5:$Q$5) 65.5 =SUMPRODUCT(F33:I33,$N$5:$Q$5)
[학생] : 95.8 =F4*$N$5+G4*$O$5+H4*$P$5+I4*$Q$5 88.7 =F5*$N$5+G5*$O$5+H5*$P$5+I5*$Q$5 84.8 =F6*$N$5+G6*$O$5+H6*$P$5+I6*$Q$5 72.4 =F7*$N$5+G7*$O$5+H7*$P$5+I7*$Q$5 60.3 =F8*$N$5+G8*$O$5+H8*$P$5+I8*$Q$5 78.7 =F9*$N$5+G9*$O$5+H9*$P$5+I9*$Q$5 63.5 =F10*$N$5+G10*$O$5+H10*$P$5+I10*$Q$5 76.1 =F11*$N$5+G11*$O$5+H11*$P$5+I11*$Q$5 70.4 =F12*$N$5+G12*$O$5+H12*$P$5+I12*$Q$5 82.5 =F13*$N$5+G13*$O$5+H13*$P$5+I13*$Q$5 76.1 =F14*$N$5+G14*$O$5+H14*$P$5+I14*$Q$5 94.6 =F15*$N$5+G15*$O$5+H15*$P$5+I15*$Q$5 88.8 =F16*$N$5+G16*$O$5+H16*$P$5+I16*$Q$5 63.5 =F17*$N$5+G17*$O$5+H17*$P$5+I17*$Q$5 75.3 =F18*$N$5+G18*$O$5+H18*$P$5+I18*$Q$5 71.9 =F19*$N$5+G19*$O$5+H19*$P$5+I19*$Q$5 82.1 =F20*$N$5+G20*$O$5+H20*$P$5+I20*$Q$5 70.5 =F21*$N$5+G21*$O$5+H21*$P$5+I21*$Q$5 66.3 =F22*$N$5+G22*$O$5+H22*$P$5+I22*$Q$5 78.7 =F23*$N$5+G23*$O$5+H23*$P$5+I23*$Q$5 75.1 =F24*$N$5+G24*$O$5+H24*$P$5+I24*$Q$5 79.9 =F25*$N$5+G25*$O$5+H25*$P$5+I25*$Q$5 72.8 =F26*$N$5+G26*$O$5+H26*$P$5+I26*$Q$5 83.6 =F27*$N$5+G27*$O$5+H27*$P$5+I27*$Q$5 56.9 =F28*$N$5+G28*$O$5+H28*$P$5+I28*$Q$5 77.1 =F29*$N$5+G29*$O$5+H29*$P$5+I29*$Q$5 87.7 =F30*$N$5+G30*$O$5+H30*$P$5+I30*$Q$5 59.9 =F31*$N$5+G31*$O$5+H31*$P$5+I31*$Q$5 66.5 =F32*$N$5+G32*$O$5+H32*$P$5+I32*$Q$5 65.5 =F33*$N$5+G33*$O$5+H33*$P$5+I33*$Q$5