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
[학생] :