[점수(100점 만점)] : 10
[상세점수] :
[과제(배점:100점)] : 10
[문제] : 과제, 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)
[학생] :
[문제] : 과제, 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)
[학생] :
[문제] : 과제, L4:L33, [틀림]등수 계산이 틀렸습니다.
[정답] : 1 =RANK.EQ(J4,$J$4:$J$33) 4 =RANK.EQ(J5,$J$4:$J$33) 6 =RANK.EQ(J6,$J$4:$J$33) 19 =RANK.EQ(J7,$J$4:$J$33) 28 =RANK.EQ(J8,$J$4:$J$33) 11 =RANK.EQ(J9,$J$4:$J$33) 26 =RANK.EQ(J10,$J$4:$J$33) 14 =RANK.EQ(J11,$J$4:$J$33) 22 =RANK.EQ(J12,$J$4:$J$33) 8 =RANK.EQ(J13,$J$4:$J$33) 14 =RANK.EQ(J14,$J$4:$J$33) 2 =RANK.EQ(J15,$J$4:$J$33) 3 =RANK.EQ(J16,$J$4:$J$33) 26 =RANK.EQ(J17,$J$4:$J$33) 16 =RANK.EQ(J18,$J$4:$J$33) 20 =RANK.EQ(J19,$J$4:$J$33) 9 =RANK.EQ(J20,$J$4:$J$33) 21 =RANK.EQ(J21,$J$4:$J$33) 24 =RANK.EQ(J22,$J$4:$J$33) 11 =RANK.EQ(J23,$J$4:$J$33) 17 =RANK.EQ(J24,$J$4:$J$33) 10 =RANK.EQ(J25,$J$4:$J$33) 18 =RANK.EQ(J26,$J$4:$J$33) 7 =RANK.EQ(J27,$J$4:$J$33) 30 =RANK.EQ(J28,$J$4:$J$33) 13 =RANK.EQ(J29,$J$4:$J$33) 5 =RANK.EQ(J30,$J$4:$J$33) 29 =RANK.EQ(J31,$J$4:$J$33) 23 =RANK.EQ(J32,$J$4:$J$33) 25 =RANK.EQ(J33,$J$4:$J$33)
[학생] :
[문제] : 과제, K4:K33, [틀림]학점 계산이 틀렸습니다.
[정답] : A+ =HLOOKUP(J4,$O$8:$W$10,3) B+ =HLOOKUP(J5,$O$8:$W$10,3) B =HLOOKUP(J6,$O$8:$W$10,3) C =HLOOKUP(J7,$O$8:$W$10,3) D =HLOOKUP(J8,$O$8:$W$10,3) C+ =HLOOKUP(J9,$O$8:$W$10,3) D =HLOOKUP(J10,$O$8:$W$10,3) C+ =HLOOKUP(J11,$O$8:$W$10,3) C =HLOOKUP(J12,$O$8:$W$10,3) B =HLOOKUP(J13,$O$8:$W$10,3) C+ =HLOOKUP(J14,$O$8:$W$10,3) A =HLOOKUP(J15,$O$8:$W$10,3) B+ =HLOOKUP(J16,$O$8:$W$10,3) D =HLOOKUP(J17,$O$8:$W$10,3) C+ =HLOOKUP(J18,$O$8:$W$10,3) C =HLOOKUP(J19,$O$8:$W$10,3) B =HLOOKUP(J20,$O$8:$W$10,3) C =HLOOKUP(J21,$O$8:$W$10,3) D+ =HLOOKUP(J22,$O$8:$W$10,3) C+ =HLOOKUP(J23,$O$8:$W$10,3) C+ =HLOOKUP(J24,$O$8:$W$10,3) C+ =HLOOKUP(J25,$O$8:$W$10,3) C =HLOOKUP(J26,$O$8:$W$10,3) B =HLOOKUP(J27,$O$8:$W$10,3) F =HLOOKUP(J28,$O$8:$W$10,3) C+ =HLOOKUP(J29,$O$8:$W$10,3) B+ =HLOOKUP(J30,$O$8:$W$10,3) F =HLOOKUP(J31,$O$8:$W$10,3) D+ =HLOOKUP(J32,$O$8:$W$10,3) D+ =HLOOKUP(J33,$O$8:$W$10,3)
[학생] :
[문제] : 과제, C4:C33, [틀림]학과 계산이 틀렸습니다.
[정답] : 물류무역학과 =VLOOKUP(B4,$N$14:$O$23,2,FALSE) 부동산학과 =VLOOKUP(B5,$N$14:$O$23,2,FALSE) 상담심리학과 =VLOOKUP(B6,$N$14:$O$23,2,FALSE) 경영학과 =VLOOKUP(B7,$N$14:$O$23,2,FALSE) 경영학과 =VLOOKUP(B8,$N$14:$O$23,2,FALSE) 한식조리학과 =VLOOKUP(B9,$N$14:$O$23,2,FALSE) 상담심리학과 =VLOOKUP(B10,$N$14:$O$23,2,FALSE) 부동산학과 =VLOOKUP(B11,$N$14:$O$23,2,FALSE) 경영학과 =VLOOKUP(B12,$N$14:$O$23,2,FALSE) 상담심리학과 =VLOOKUP(B13,$N$14:$O$23,2,FALSE) 물리치료학과 =VLOOKUP(B14,$N$14:$O$23,2,FALSE) 환경보건학과 =VLOOKUP(B15,$N$14:$O$23,2,FALSE) 재활학과 =VLOOKUP(B16,$N$14:$O$23,2,FALSE) 환경보건학과 =VLOOKUP(B17,$N$14:$O$23,2,FALSE) 한국어문학과 =VLOOKUP(B18,$N$14:$O$23,2,FALSE) 경영학과 =VLOOKUP(B19,$N$14:$O$23,2,FALSE) 부동산학과 =VLOOKUP(B20,$N$14:$O$23,2,FALSE) 물류무역학과 =VLOOKUP(B21,$N$14:$O$23,2,FALSE) 경영학과 =VLOOKUP(B22,$N$14:$O$23,2,FALSE) 금융보험학과 =VLOOKUP(B23,$N$14:$O$23,2,FALSE) 재활학과 =VLOOKUP(B24,$N$14:$O$23,2,FALSE) 금융보험학과 =VLOOKUP(B25,$N$14:$O$23,2,FALSE) 한식조리학과 =VLOOKUP(B26,$N$14:$O$23,2,FALSE) 부동산학과 =VLOOKUP(B27,$N$14:$O$23,2,FALSE) 부동산학과 =VLOOKUP(B28,$N$14:$O$23,2,FALSE) 환경보건학과 =VLOOKUP(B29,$N$14:$O$23,2,FALSE) 한국어문학과 =VLOOKUP(B30,$N$14:$O$23,2,FALSE) 한식조리학과 =VLOOKUP(B31,$N$14:$O$23,2,FALSE) 물리치료학과 =VLOOKUP(B32,$N$14:$O$23,2,FALSE) 한식조리학과 =VLOOKUP(B33,$N$14:$O$23,2,FALSE)
[학생] : 물류무역학과 =VLOOKUP(B4,N14:O23,2,0) 부동산학과 =VLOOKUP(B5,N15:O24,2,0) 상담심리학과 =VLOOKUP(B6,N16:O25,2,0) -2146826246 =VLOOKUP(B7,N17:O26,2,0) -2146826246 =VLOOKUP(B8,N18:O27,2,0) 한식조리학과 =VLOOKUP(B9,N19:O28,2,0) -2146826246 =VLOOKUP(B10,N20:O29,2,0) -2146826246 =VLOOKUP(B11,N21:O30,2,0) -2146826246 =VLOOKUP(B12,N22:O31,2,0) -2146826246 =VLOOKUP(B13,N23:O32,2,0) -2146826246 =VLOOKUP(B14,N24:O33,2,0) -2146826246 =VLOOKUP(B15,N25:O34,2,0) -2146826246 =VLOOKUP(B16,N26:O35,2,0) -2146826246 =VLOOKUP(B17,N27:O36,2,0) -2146826246 =VLOOKUP(B18,N28:O37,2,0) -2146826246 =VLOOKUP(B19,N29:O38,2,0) -2146826246 =VLOOKUP(B20,N30:O39,2,0) -2146826246 =VLOOKUP(B21,N31:O40,2,0) -2146826246 =VLOOKUP(B22,N32:O41,2,0) -2146826246 =VLOOKUP(B23,N33:O42,2,0) -2146826246 =VLOOKUP(B24,N34:O43,2,0) -2146826246 =VLOOKUP(B25,N35:O44,2,0) -2146826246 =VLOOKUP(B26,N36:O45,2,0) -2146826246 =VLOOKUP(B27,N37:O46,2,0) -2146826246 =VLOOKUP(B28,N38:O47,2,0) -2146826246 =VLOOKUP(B29,N39:O48,2,0) -2146826246 =VLOOKUP(B30,N40:O49,2,0) -2146826246 =VLOOKUP(B31,N41:O50,2,0) -2146826246 =VLOOKUP(B32,N42:O51,2,0) -2146826246 =VLOOKUP(B33,N43:O52,2,0)