[점수(100점 만점)] : 35
[상세점수] :
[과제(배점:100점)] : 35
[문제] : 과제, 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
[학생] :
[문제] : 과제, 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 =COUNTIF(C4:$C$33,O14) 2 =COUNTIF(C5:$C$33,O15) 1 =COUNTIF(C6:$C$33,O16) 2 =COUNTIF(C7:$C$33,O17) 4 =COUNTIF(C8:$C$33,O18) 2 =COUNTIF(C9:$C$33,O19) 2 =COUNTIF(C10:$C$33,O20) 2 =COUNTIF(C11:$C$33,O21) 3 =COUNTIF(C12:$C$33,O22) 3 =COUNTIF(C13:$C$33,O23)
[문제] : 과제, 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 =I4*$Q$5+H4*$P$5+G4*$O$5+F4*$N$5 88.7 =I5*$Q$5+H5*$P$5+G5*$O$5+F5*$N$5 84.8 =I6*$Q$5+H6*$P$5+G6*$O$5+F6*$N$5 72.4 =I7*$Q$5+H7*$P$5+G7*$O$5+F7*$N$5 60.3 =I8*$Q$5+H8*$P$5+G8*$O$5+F8*$N$5 78.7 =I9*$Q$5+H9*$P$5+G9*$O$5+F9*$N$5 63.5 =I10*$Q$5+H10*$P$5+G10*$O$5+F10*$N$5 76.1 =I11*$Q$5+H11*$P$5+G11*$O$5+F11*$N$5 70.4 =I12*$Q$5+H12*$P$5+G12*$O$5+F12*$N$5 82.5 =I13*$Q$5+H13*$P$5+G13*$O$5+F13*$N$5 76.1 =I14*$Q$5+H14*$P$5+G14*$O$5+F14*$N$5 94.6 =I15*$Q$5+H15*$P$5+G15*$O$5+F15*$N$5 88.8 =I16*$Q$5+H16*$P$5+G16*$O$5+F16*$N$5 63.5 =I17*$Q$5+H17*$P$5+G17*$O$5+F17*$N$5 75.3 =I18*$Q$5+H18*$P$5+G18*$O$5+F18*$N$5 71.9 =I19*$Q$5+H19*$P$5+G19*$O$5+F19*$N$5 82.1 =I20*$Q$5+H20*$P$5+G20*$O$5+F20*$N$5 70.5 =I21*$Q$5+H21*$P$5+G21*$O$5+F21*$N$5 66.3 =I22*$Q$5+H22*$P$5+G22*$O$5+F22*$N$5 78.7 =I23*$Q$5+H23*$P$5+G23*$O$5+F23*$N$5 75.1 =I24*$Q$5+H24*$P$5+G24*$O$5+F24*$N$5 79.9 =I25*$Q$5+H25*$P$5+G25*$O$5+F25*$N$5 72.8 =I26*$Q$5+H26*$P$5+G26*$O$5+F26*$N$5 83.6 =I27*$Q$5+H27*$P$5+G27*$O$5+F27*$N$5 56.9 =I28*$Q$5+H28*$P$5+G28*$O$5+F28*$N$5 77.1 =I29*$Q$5+H29*$P$5+G29*$O$5+F29*$N$5 87.7 =I30*$Q$5+H30*$P$5+G30*$O$5+F30*$N$5 59.9 =I31*$Q$5+H31*$P$5+G31*$O$5+F31*$N$5 66.5 =I32*$Q$5+H32*$P$5+G32*$O$5+F32*$N$5 65.5 =I33*$Q$5+H33*$P$5+G33*$O$5+F33*$N$5