EXCL1911_201921040_이예나.xlsm
[점수(100점 만점)] : 95
[상세점수] :
[과제(배점:100점)] : 95
[문제] : 과제, J4:J13, [틀림]평균 계산이 틀렸습니다.
[정답] : 70.25 =AVERAGE(F4:I4) 62.25 =AVERAGE(F5:I5) 73.25 =AVERAGE(F6:I6) 75.25 =AVERAGE(F7:I7) 64.25 =AVERAGE(F8:I8) 72.25 =AVERAGE(F9:I9) 59.75 =AVERAGE(F10:I10) 64 =AVERAGE(F11:I11) 69.25 =AVERAGE(F12:I12) 63.25 =AVERAGE(F13:I13)
[학생] : 70.25 =SUMPRODUCT(F4:I4/4) 62.25 =SUMPRODUCT(F5:I5/4) 73.25 =SUMPRODUCT(F6:I6/4) 75.25 =SUMPRODUCT(F7:I7/4) 64.25 =SUMPRODUCT(F8:I8/4) 72.25 =SUMPRODUCT(F9:I9/4) 59.75 =SUMPRODUCT(F10:I10/4) 64 =SUMPRODUCT(F11:I11/4) 69.25 =SUMPRODUCT(F12:I12/4) 63.25 =SUMPRODUCT(F13:I13/4)