EXCL1902_201922038_김우진_128561_assignsubmission_file_EXCL1902_데이터입력.xlsm
[점수(100점 만점)] : 55
[상세점수] :
[과제(배점:100점)] : 55
[문제] : 과제, J4:J13, [틀림]등수 구하기 틀림
[정답] : 16 =RANK(I4,$I$4:$I$23) 2 =RANK(I5,$I$4:$I$23) 18 =RANK(I6,$I$4:$I$23) 11 =RANK(I7,$I$4:$I$23) 19 =RANK(I8,$I$4:$I$23) 13 =RANK(I9,$I$4:$I$23) 13 =RANK(I10,$I$4:$I$23) 1 =RANK(I11,$I$4:$I$23) 4 =RANK(I12,$I$4:$I$23) 8 =RANK(I13,$I$4:$I$23)
[학생] : 16 =RANK(I4,$I$4:$I$23) 3 =RANK(I5,$I$4:$I$23) 18 =RANK(I6,$I$4:$I$23) 11 =RANK(I7,$I$4:$I$23) 19 =RANK(I8,$I$4:$I$23) 13 =RANK(I9,$I$4:$I$23) 13 =RANK(I10,$I$4:$I$23) 1 =RANK(I11,$I$4:$I$23) 4 =RANK(I12,$I$4:$I$23) 8 =RANK(I13,$I$4:$I$23)
[문제] : 과제, C4:C13, [틀림]한자변환 안됨(中學校)
[정답] : D中學校 B中學校 D中學校 D中學校 C中學校 D中學校 B中學校 A中學校 A中學校 C中學校
[학생] : D중학교 B중학교 D중학교 D중학교 C중학교 D중학교 B중학교 A중학교 A중학교 C중학교
[문제] : 과제, D27:I27, [틀림]최저값 틀림
[정답] : 55 =MIN(D4:D23) 55 =MIN(E4:E23) 55 =MIN(F4:F23) 45 =MIN(G4:G23) 265 =MIN(H4:H23) 66.25 =MIN(I4:I23)
[학생] : 55 =MIN(D4:D23) 55 =MIN(E4:E23) 55 =MIN(F4:F23) 45 =MIN(G4:G23) 255 =MIN(H4:H23) 66.25 =MIN(I4:I23)
[문제] : 과제, D25:I25, [틀림]평균 틀림
[정답] : 80.5 =AVERAGE(D4:D23) 76.5 =AVERAGE(E4:E23) 82 =AVERAGE(F4:F23) 73 =AVERAGE(G4:G23) 312 =AVERAGE(H4:H23) 78 =AVERAGE(I4:I23)
[학생] : 80.5 =AVERAGE(D4:D23) 76.5 =AVERAGE(E4:E23) 82 =AVERAGE(F4:F23) 73 =AVERAGE(G4:G23) 312 312 78.0125 =AVERAGE(I4:I23)