EXCL1906_201922011_박현우_134493_assignsubmission_file_EXCL1906_함수2.xlsm
[점수(100점 만점)] : 60
[상세점수] :
[과제(배점:100점)] : 60
[문제] : 과제, True, [틀림]축의 최대값이 틀렸습니다.
[정답] : 6,100
[학생] : 100,6
[문제] : 과제, True, [틀림]축의 주단위가 틀렸습니다.
[정답] : 1,20
[학생] : 20,1
[문제] : 과제, True, [틀림]차트의 시리즈에 대한 축이 틀렸습니다.
[정답] : xlPrimaryxlSecondary
[학생] : xlSecondaryxlPrimary
[문제] : 과제, P14:P23, [틀림]학생수 계산이 틀렸습니다.
[정답] : 5 =COUNTIF($B$4:$B$33,N14) 2 =COUNTIF($B$4:$B$33,N15) 2 =COUNTIF($B$4:$B$33,N16) 2 =COUNTIF($B$4:$B$33,N17) 5 =COUNTIF($B$4:$B$33,N18) 3 =COUNTIF($B$4:$B$33,N19) 2 =COUNTIF($B$4:$B$33,N20) 2 =COUNTIF($B$4:$B$33,N21) 4 =COUNTIF($B$4:$B$33,N22) 3 =COUNTIF($B$4:$B$33,N23)
[학생] : 5 =COUNTIF(C4:C33,"경영학과") 2 =COUNTIF(C4:C34,"금융보험학과") 2 =COUNTIF(C4:C35,"물류무역학과") 2 =COUNTIF(C4:C36,"물리치료학과") 4 =COUNTIF(C8:C37,"부동산학과") 3 =COUNTIF(C4:C38,"상담심리학과") 2 =COUNTIF(C4:C38,"재활학과") 2 =COUNTIF(C4:C38,"한국어문학과") 4 =COUNTIF(C4:C38,"한식조리학과") 3 =COUNTIF(C4:C38,"환경보건학과")
[문제] : 과제, K4:K33, [틀림]학점 계산이 틀렸습니다.
[정답] : A+ =HLOOKUP(J4,$O$8:$W$10,3) B+ =HLOOKUP(J5,$O$8:$W$10,3) B =HLOOKUP(J6,$O$8:$W$10,3) C =HLOOKUP(J7,$O$8:$W$10,3) D =HLOOKUP(J8,$O$8:$W$10,3) C+ =HLOOKUP(J9,$O$8:$W$10,3) D =HLOOKUP(J10,$O$8:$W$10,3) C+ =HLOOKUP(J11,$O$8:$W$10,3) C =HLOOKUP(J12,$O$8:$W$10,3) B =HLOOKUP(J13,$O$8:$W$10,3) C+ =HLOOKUP(J14,$O$8:$W$10,3) A =HLOOKUP(J15,$O$8:$W$10,3) B+ =HLOOKUP(J16,$O$8:$W$10,3) D =HLOOKUP(J17,$O$8:$W$10,3) C+ =HLOOKUP(J18,$O$8:$W$10,3) C =HLOOKUP(J19,$O$8:$W$10,3) B =HLOOKUP(J20,$O$8:$W$10,3) C =HLOOKUP(J21,$O$8:$W$10,3) D+ =HLOOKUP(J22,$O$8:$W$10,3) C+ =HLOOKUP(J23,$O$8:$W$10,3) C+ =HLOOKUP(J24,$O$8:$W$10,3) C+ =HLOOKUP(J25,$O$8:$W$10,3) C =HLOOKUP(J26,$O$8:$W$10,3) B =HLOOKUP(J27,$O$8:$W$10,3) F =HLOOKUP(J28,$O$8:$W$10,3) C+ =HLOOKUP(J29,$O$8:$W$10,3) B+ =HLOOKUP(J30,$O$8:$W$10,3) F =HLOOKUP(J31,$O$8:$W$10,3) D+ =HLOOKUP(J32,$O$8:$W$10,3) D+ =HLOOKUP(J33,$O$8:$W$10,3)
[학생] : A+ =HLOOKUP(J4,$P$8:$W$10,3) B+ =HLOOKUP(J5,$P$8:$W$10,3) B =HLOOKUP(J6,$P$8:$W$10,3) C =HLOOKUP(J7,$P$8:$W$10,3) D =HLOOKUP(J8,$P$8:$W$10,3) C+ =HLOOKUP(J9,$P$8:$W$10,3) D =HLOOKUP(J10,$P$8:$W$10,3) C+ =HLOOKUP(J11,$P$8:$W$10,3) C =HLOOKUP(J12,$P$8:$W$10,3) B =HLOOKUP(J13,$P$8:$W$10,3) C+ =HLOOKUP(J14,$P$8:$W$10,3) A =HLOOKUP(J15,$P$8:$W$10,3) B+ =HLOOKUP(J16,$P$8:$W$10,3) D =HLOOKUP(J17,$P$8:$W$10,3) C+ =HLOOKUP(J18,$P$8:$W$10,3) C =HLOOKUP(J19,$P$8:$W$10,3) B =HLOOKUP(J20,$P$8:$W$10,3) C =HLOOKUP(J21,$P$8:$W$10,3) D+ =HLOOKUP(J22,$P$8:$W$10,3) C+ =HLOOKUP(J23,$P$8:$W$10,3) C+ =HLOOKUP(J24,$P$8:$W$10,3) C+ =HLOOKUP(J25,$P$8:$W$10,3) C =HLOOKUP(J26,$P$8:$W$10,3) B =HLOOKUP(J27,$P$8:$W$10,3) -2146826246 =HLOOKUP(J28,$P$8:$W$10,3) C+ =HLOOKUP(J29,$P$8:$W$10,3) B+ =HLOOKUP(J30,$P$8:$W$10,3) -2146826246 =HLOOKUP(J31,$P$8:$W$10,3) D+ =HLOOKUP(J32,$P$8:$W$10,3) D+ =HLOOKUP(J33,$P$8:$W$10,3)