EXCL1904_201813141_어용에르덴(A)_131691_assignsubmission_file_EXCL1904_차트_학번201813141.xlsm
[점수(100점 만점)] : 80
[상세점수] :
[과제(배점:100점)] : 80
[문제] : 과제, J4:J33, [틀림]학점 계산이 틀렸습니다.
[정답] : A+ =VLOOKUP(I4,$M$10:$N$18,2) B+ =VLOOKUP(I5,$M$10:$N$18,2) B =VLOOKUP(I6,$M$10:$N$18,2) C =VLOOKUP(I7,$M$10:$N$18,2) D =VLOOKUP(I8,$M$10:$N$18,2) C+ =VLOOKUP(I9,$M$10:$N$18,2) D =VLOOKUP(I10,$M$10:$N$18,2) C+ =VLOOKUP(I11,$M$10:$N$18,2) C =VLOOKUP(I12,$M$10:$N$18,2) B =VLOOKUP(I13,$M$10:$N$18,2) C+ =VLOOKUP(I14,$M$10:$N$18,2) A =VLOOKUP(I15,$M$10:$N$18,2) B+ =VLOOKUP(I16,$M$10:$N$18,2) D =VLOOKUP(I17,$M$10:$N$18,2) C+ =VLOOKUP(I18,$M$10:$N$18,2) C =VLOOKUP(I19,$M$10:$N$18,2) B =VLOOKUP(I20,$M$10:$N$18,2) C =VLOOKUP(I21,$M$10:$N$18,2) D+ =VLOOKUP(I22,$M$10:$N$18,2) C+ =VLOOKUP(I23,$M$10:$N$18,2) C+ =VLOOKUP(I24,$M$10:$N$18,2) C+ =VLOOKUP(I25,$M$10:$N$18,2) C =VLOOKUP(I26,$M$10:$N$18,2) B =VLOOKUP(I27,$M$10:$N$18,2) F =VLOOKUP(I28,$M$10:$N$18,2) C+ =VLOOKUP(I29,$M$10:$N$18,2) B+ =VLOOKUP(I30,$M$10:$N$18,2) F =VLOOKUP(I31,$M$10:$N$18,2) D+ =VLOOKUP(I32,$M$10:$N$18,2) D+ =VLOOKUP(I33,$M$10:$N$18,2)
[학생] : A+ A+ B+ B+ B B C C D D C+ C+ D D C+ C+ C C B B C+ C+ A A B+ B+ D D C+ C+ C C B B C C D+ D+ C+ C+ C+ C+ C+ C+ C C B B F F C+ C+ B+ B+ F F D+ D+ D+ D+
[문제] : 과제, O10:O18, [틀림]인원이 틀렸습니다.
[정답] : 2 =COUNTIF($J$4:$J$33,N10) 3 =COUNTIF($J$4:$J$33,N11) 3 =COUNTIF($J$4:$J$33,N12) 5 =COUNTIF($J$4:$J$33,N13) 8 =COUNTIF($J$4:$J$33,N14) 4 =COUNTIF($J$4:$J$33,N15) 3 =COUNTIF($J$4:$J$33,N16) 1 =COUNTIF($J$4:$J$33,N17) 1 =COUNTIF($J$4:$J$33,N18)
[학생] : 2 =COUNTIF(J4:J33,N10) 3 =COUNTIF(J5:J34,N11) 3 =COUNTIF(J6:J35,N12) 5 =COUNTIF(J7:J36,N13) 8 =COUNTIF(J8:J37,N14) 3 =COUNTIF(J9:J38,N15) 2 =COUNTIF(J10:J39,N16) 1 =COUNTIF(J11:J40,N17) 1 1