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)