[점수(100점 만점)] : 85
[상세점수] :
[과제(배점:100점)] : 85
[문제] : 과제, 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)
[학생] : =SERIES(과제!$Z$41,과제!$Y$42:$Y$51,과제!$Z$42:$Z$51,1)=SERIES(과제!$AA$41,과제!$Y$42:$Y$51,과제!$AA$42:$AA$51,2)
[문제] : 과제, 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)
[학생] : A+ =VLOOKUP(J4,$P$40:$R$48,3) B+ =VLOOKUP(J5,$P$40:$R$48,3) B =VLOOKUP(J6,$P$40:$R$48,3) C =VLOOKUP(J7,$P$40:$R$48,3) D =VLOOKUP(J8,$P$40:$R$48,3) C+ =VLOOKUP(J9,$P$40:$R$48,3) D =VLOOKUP(J10,$P$40:$R$48,3) C+ =VLOOKUP(J11,$P$40:$R$48,3) C =VLOOKUP(J12,$P$40:$R$48,3) B =VLOOKUP(J13,$P$40:$R$48,3) C+ =VLOOKUP(J14,$P$40:$R$48,3) A =VLOOKUP(J15,$P$40:$R$48,3) B+ =VLOOKUP(J16,$P$40:$R$48,3) D =VLOOKUP(J17,$P$40:$R$48,3) C+ =VLOOKUP(J18,$P$40:$R$48,3) C =VLOOKUP(J19,$P$40:$R$48,3) B =VLOOKUP(J20,$P$40:$R$48,3) C =VLOOKUP(J21,$P$40:$R$48,3) D+ =VLOOKUP(J22,$P$40:$R$48,3) C+ =VLOOKUP(J23,$P$40:$R$48,3) C+ =VLOOKUP(J24,$P$40:$R$48,3) C+ =VLOOKUP(J25,$P$40:$R$48,3) C =VLOOKUP(J26,$P$40:$R$48,3) B =VLOOKUP(J27,$P$40:$R$48,3) F =VLOOKUP(J28,$P$40:$R$48,3) C+ =VLOOKUP(J29,$P$40:$R$48,3) B+ =VLOOKUP(J30,$P$40:$R$48,3) F =VLOOKUP(J31,$P$40:$R$48,3) D+ =VLOOKUP(J32,$P$40:$R$48,3) D+ =VLOOKUP(J33,$P$40:$R$48,3)