EXCL1913_201921040_이예나.xlsm
[점수(100점 만점)] : 93.18
[상세점수] :
[과제(배점:40점)] : 36.36
[과제(배점:25점)] : 25
[과제(배점:35점)] : 31.82
[문제] : 과제, J4:J13, [틀림]평균 계산이 틀렸습니다.
[정답] : 85.25 =AVERAGE(F4:I4) 72.25 =AVERAGE(F5:I5) 70.5 =AVERAGE(F6:I6) 84 =AVERAGE(F7:I7) 70 =AVERAGE(F8:I8) 74.5 =AVERAGE(F9:I9) 80 =AVERAGE(F10:I10) 68.25 =AVERAGE(F11:I11) 76.75 =AVERAGE(F12:I12) 75.75 =AVERAGE(F13:I13)
[학생] : 85.25 =SUMPRODUCT(F4:I4/4) 72.25 =SUMPRODUCT(F5:I5/4) 70.5 =SUMPRODUCT(F6:I6/4) 84 =SUMPRODUCT(F7:I7/4) 70 =SUMPRODUCT(F8:I8/4) 74.5 =SUMPRODUCT(F9:I9/4) 80 =SUMPRODUCT(F10:I10/4) 68.25 =SUMPRODUCT(F11:I11/4) 76.75 =SUMPRODUCT(F12:I12/4) 75.75 =SUMPRODUCT(F13:I13/4)
[문제] : 과제, , [틀림]매페이지마다반복
[정답] : $3:$3
[학생] :