[점수(100점 만점)] : 30
[상세점수] :
[과제(배점:100점)] : 30
[문제] : 과제, 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)
[학생] : 15 =RANK(I4,$I$4:$I$23)
[문제] : 과제, I4:I13, [틀림]평균 구하기 틀림
[정답] : 72.5 =H4/4 88.75 =H5/4 67.5 =H6/4 76.25 =H7/4 66.25 =H8/4 73.75 =H9/4 73.75 =H10/4 90 =H11/4 87.5 =H12/4 80 =H13/4
[학생] : 72.5 =H4/4 88.75 =H5/4 67.5 =H6/4 76.25 =H7/4 66.25 =H8/4 73.75 =H9/4 78.75 =H10/4 82.5 =H11/4 85 =H12/4 80 =H13/4
[문제] : 과제, H4:H13, [틀림]총점 구하기 틀림
[정답] : 290 =D4+E4+F4+G4 355 =D5+E5+F5+G5 270 =D6+E6+F6+G6 305 =D7+E7+F7+G7 265 =D8+E8+F8+G8 295 =D9+E9+F9+G9 295 =D10+E10+F10+G10 360 =D11+E11+F11+G11 350 =D12+E12+F12+G12 320 =D13+E13+F13+G13
[학생] : 290 =G4+F4+E4+D4 355 =G5+F5+E5+D5 270 =G6+F6+E6+D6 305 =G7+F7+E7+D7 265 =G8+F8+E8+D8 295 =G9+F9+E9+D9 315 =G10+F10+E10+D10 330 =G11+F11+E11+D11 340 =G12+F12+E12+D12 320 =G13+F13+E13+D13
[문제] : 과제, C4:C13, [틀림]한자변환 안됨(中學校)
[정답] : D中學校 B中學校 D中學校 D中學校 C中學校 D中學校 B中學校 A中學校 A中學校 C中學校
[학생] : D중학교 B중학교 D중학교 D중학교 C중학교 D중학교 F중학교 B중학교 A중학교 E중학교
[문제] : 과제, 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(E4:E23) 60 =MIN(F4:F23) 45 =MIN(G4:G23) 265 =MIN(H4:H23) 66.25 =MIN(I4:I23) 66 66
[문제] : 과제, D26:I26, [틀림]최고값 틀림
[정답] : 100 =MAX(D4:D23) 100 =MAX(E4:E23) 100 =MAX(F4:F23) 100 =MAX(G4:G23) 360 =MAX(H4:H23) 90 =MAX(I4:I23)
[학생] : 100 =MAX(E4:E23) 100 =MAX(F4:F23) 100 =MAX(G4:G23) 365 =MAX(H4:H23) 91.25 =MAX(I4:I23) 90 90
[문제] : 과제, 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)
[학생] : 75.5 =AVERAGE(E4:E23) 84.5 =AVERAGE(F4:F23) 73 =AVERAGE(G4:G23) 313.5 =AVERAGE(H4:H23) 78.375 =AVERAGE(I4:I23) 78 78