EXCL1913_201978024_한민수.xlsm

[점수(100점 만점)] : 96.36

[상세점수] :
        [과제(배점:40점)] : 36.36
        [과제(배점:25점)] : 25
        [과제(배점:35점)] : 35

[문제] : 과제, D4:D13, [틀림]학과 계산이 틀렸습니다.

[정답] : 	부동산	=VLOOKUP(C4,$Q$12:$R$18,2,FALSE)
	물류무역	=VLOOKUP(C5,$Q$12:$R$18,2,FALSE)
	경영학과	=VLOOKUP(C6,$Q$12:$R$18,2,FALSE)
	물리치료	=VLOOKUP(C7,$Q$12:$R$18,2,FALSE)
	부동산	=VLOOKUP(C8,$Q$12:$R$18,2,FALSE)
	금융보험	=VLOOKUP(C9,$Q$12:$R$18,2,FALSE)
	금융보험	=VLOOKUP(C10,$Q$12:$R$18,2,FALSE)
	물류무역	=VLOOKUP(C11,$Q$12:$R$18,2,FALSE)
	재활학과	=VLOOKUP(C12,$Q$12:$R$18,2,FALSE)
	부동산	=VLOOKUP(C13,$Q$12:$R$18,2,FALSE)

[학생] : 	부동산	=VLOOKUP(C4,$Q$11:$T$18,2)
	물류무역	=VLOOKUP(C5,$Q$11:$T$18,2)
	상담심리	=VLOOKUP(C6,$Q$11:$T$18,2)
	물리치료	=VLOOKUP(C7,$Q$11:$T$18,2)
	부동산	=VLOOKUP(C8,$Q$11:$T$18,2)
	상담심리	=VLOOKUP(C9,$Q$11:$T$18,2)
	상담심리	=VLOOKUP(C10,$Q$11:$T$18,2)
	물류무역	=VLOOKUP(C11,$Q$11:$T$18,2)
	재활학과	=VLOOKUP(C12,$Q$11:$T$18,2)
	부동산	=VLOOKUP(C13,$Q$11:$T$18,2)