EXCL1904_201921037_전세미_131751_assignsubmission_file_201921037 전세미.xlsm
[점수(100점 만점)] : 80
[상세점수] :
[과제(배점:100점)] : 80
[문제] : 과제, 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 2 3 3 3 3 5 5 8 8 4 4 3 3 1 1 1 1
[문제] : 과제, 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+