EXCL1906_201912030_김다빈_134506_assignsubmission_file_201912030 김다빈.xlsm
[점수(100점 만점)] : 90
[상세점수] :
[과제(배점:100점)] : 90
[문제] : 과제, C4:C33, [틀림]학과 계산이 틀렸습니다.
[정답] : 물류무역학과 =VLOOKUP(B4,$N$14:$O$23,2,FALSE) 부동산학과 =VLOOKUP(B5,$N$14:$O$23,2,FALSE) 상담심리학과 =VLOOKUP(B6,$N$14:$O$23,2,FALSE) 경영학과 =VLOOKUP(B7,$N$14:$O$23,2,FALSE) 경영학과 =VLOOKUP(B8,$N$14:$O$23,2,FALSE) 한식조리학과 =VLOOKUP(B9,$N$14:$O$23,2,FALSE) 상담심리학과 =VLOOKUP(B10,$N$14:$O$23,2,FALSE) 부동산학과 =VLOOKUP(B11,$N$14:$O$23,2,FALSE) 경영학과 =VLOOKUP(B12,$N$14:$O$23,2,FALSE) 상담심리학과 =VLOOKUP(B13,$N$14:$O$23,2,FALSE) 물리치료학과 =VLOOKUP(B14,$N$14:$O$23,2,FALSE) 환경보건학과 =VLOOKUP(B15,$N$14:$O$23,2,FALSE) 재활학과 =VLOOKUP(B16,$N$14:$O$23,2,FALSE) 환경보건학과 =VLOOKUP(B17,$N$14:$O$23,2,FALSE) 한국어문학과 =VLOOKUP(B18,$N$14:$O$23,2,FALSE) 경영학과 =VLOOKUP(B19,$N$14:$O$23,2,FALSE) 부동산학과 =VLOOKUP(B20,$N$14:$O$23,2,FALSE) 물류무역학과 =VLOOKUP(B21,$N$14:$O$23,2,FALSE) 경영학과 =VLOOKUP(B22,$N$14:$O$23,2,FALSE) 금융보험학과 =VLOOKUP(B23,$N$14:$O$23,2,FALSE) 재활학과 =VLOOKUP(B24,$N$14:$O$23,2,FALSE) 금융보험학과 =VLOOKUP(B25,$N$14:$O$23,2,FALSE) 한식조리학과 =VLOOKUP(B26,$N$14:$O$23,2,FALSE) 부동산학과 =VLOOKUP(B27,$N$14:$O$23,2,FALSE) 부동산학과 =VLOOKUP(B28,$N$14:$O$23,2,FALSE) 환경보건학과 =VLOOKUP(B29,$N$14:$O$23,2,FALSE) 한국어문학과 =VLOOKUP(B30,$N$14:$O$23,2,FALSE) 한식조리학과 =VLOOKUP(B31,$N$14:$O$23,2,FALSE) 물리치료학과 =VLOOKUP(B32,$N$14:$O$23,2,FALSE) 한식조리학과 =VLOOKUP(B33,$N$14:$O$23,2,FALSE)
[학생] : 한식조리학과 =VLOOKUP(B4:B33,$N$14:$O$23,2) 부동산학과 =VLOOKUP(B5:B34,$N$14:$O$23,2) 경영학과 =VLOOKUP(B6:B35,$N$14:$O$23,2) 경영학과 =VLOOKUP(B7:B36,$N$14:$O$23,2) 경영학과 =VLOOKUP(B8:B37,$N$14:$O$23,2) 경영학과 =VLOOKUP(B9:B38,$N$14:$O$23,2) 경영학과 =VLOOKUP(B10:B39,$N$14:$O$23,2) 부동산학과 =VLOOKUP(B11:B40,$N$14:$O$23,2) 경영학과 =VLOOKUP(B12:B41,$N$14:$O$23,2) 경영학과 =VLOOKUP(B13:B42,$N$14:$O$23,2) 한식조리학과 =VLOOKUP(B14:B43,$N$14:$O$23,2) 환경보건학과 =VLOOKUP(B15:B44,$N$14:$O$23,2) 한식조리학과 =VLOOKUP(B16:B45,$N$14:$O$23,2) 환경보건학과 =VLOOKUP(B17:B46,$N$14:$O$23,2) 경영학과 =VLOOKUP(B18:B47,$N$14:$O$23,2) 경영학과 =VLOOKUP(B19:B48,$N$14:$O$23,2) 부동산학과 =VLOOKUP(B20:B49,$N$14:$O$23,2) 한식조리학과 =VLOOKUP(B21:B50,$N$14:$O$23,2) 경영학과 =VLOOKUP(B22:B51,$N$14:$O$23,2) 금융보험학과 =VLOOKUP(B23:B52,$N$14:$O$23,2) 한식조리학과 =VLOOKUP(B24:B53,$N$14:$O$23,2) 금융보험학과 =VLOOKUP(B25:B54,$N$14:$O$23,2) 경영학과 =VLOOKUP(B26:B55,$N$14:$O$23,2) 부동산학과 =VLOOKUP(B27:B56,$N$14:$O$23,2) 부동산학과 =VLOOKUP(B28:B57,$N$14:$O$23,2) 환경보건학과 =VLOOKUP(B29:B58,$N$14:$O$23,2) 경영학과 =VLOOKUP(B30:B59,$N$14:$O$23,2) 경영학과 =VLOOKUP(B31:B60,$N$14:$O$23,2) 한식조리학과 =VLOOKUP(B32:B61,$N$14:$O$23,2) 경영학과 =VLOOKUP(B33:B62,$N$14:$O$23,2)