EXCL1906_201924033_하승우_134578_assignsubmission_file_201924033 하승우.xlsm
[점수(100점 만점)] : 85
[상세점수] :
[과제(배점:100점)] : 85
[문제] : 과제, True, [틀림]차트 범례 위치가 틀렸습니다.
[정답] : xlLegendPositionTop
[학생] : xlLegendPositionCustom
[문제] : 과제, 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,O14) 2 =COUNTIF(C5:C34,O15) 1 =COUNTIF(C6:C35,O16) 2 =COUNTIF(C7:C36,O17) 4 =COUNTIF(C8:C37,O18) 2 =COUNTIF(C9:C38,O19) 2 =COUNTIF(C10:C39,O20) 2 =COUNTIF(C11:C40,O21) 3 =COUNTIF(C12:C41,O22) 3 =COUNTIF(C13:C42,O23)