[점수(100점 만점)] : 50
[상세점수] :
[과제(배점:100점)] : 50
[문제] : 과제, 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 73.75 =H10/4 90.75 =H11/4 87.5 =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 =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 363 =D11+E11+F11+G11 350 =D12+E12+F12+G12 320 =D13+E13+F13+G13
[문제] : 과제, C4:C13, [틀림]한자변환 안됨(中學校)
[정답] : D中學校 B中學校 D中學校 D中學校 C中學校 D中學校 B中學校 A中學校 A中學校 C中學校
[학생] : D中學敎 B中學敎 D中學敎 D中學敎 C中學敎 D中學敎 B中學敎 A中學敎 A中學敎 C中學敎
[문제] : 과제, 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(D4:D23) 100 =MAX(E4:E23) 100 =MAX(F4:F23) 100 =MAX(G4:G23) 363 =MAX(H4:H23) 90.75 =MAX(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.15 =AVERAGE(G4:G23) 312.15 =AVERAGE(H4:H23) 78.0375 =AVERAGE(I4:I23)