[점수(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
[학생] : 310.952380952381 =AVERAGE(H4,$H$4:$H$23) 314.047619047619 =AVERAGE(H5,$H$4:$H$23) 310 =AVERAGE(H6,$H$4:$H$23) 311.666666666667 =AVERAGE(H7,$H$4:$H$23) 309.761904761905 =AVERAGE(H8,$H$4:$H$23) 311.190476190476 =AVERAGE(H9,$H$4:$H$23) 311.190476190476 =AVERAGE(H10,$H$4:$H$23) 314.285714285714 =AVERAGE(H11,$H$4:$H$23) 313.809523809524 =AVERAGE(H12,$H$4:$H$23) 312.380952380952 =AVERAGE(H13,$H$4:$H$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 55 55 55 55 55 45 45 265 265 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 100 100 100 100 100 100 100 360 360 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)
[학생] : 81 81 77 77 82 82 73 73 312 312 78 78