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