EXCL1906_201978009_박건우_134698_assignsubmission_file_EXCL1906_201978009 박건우.xlsm
[점수(100점 만점)] : 90
[상세점수] :
[과제(배점:100점)] : 90
[문제] : 과제, J4:J33, [틀림]점수 계산이 틀렸습니다.
[정답] : 95.8 =SUMPRODUCT(F4:I4,$N$5:$Q$5) 88.7 =SUMPRODUCT(F5:I5,$N$5:$Q$5) 84.8 =SUMPRODUCT(F6:I6,$N$5:$Q$5) 72.4 =SUMPRODUCT(F7:I7,$N$5:$Q$5) 60.3 =SUMPRODUCT(F8:I8,$N$5:$Q$5) 78.7 =SUMPRODUCT(F9:I9,$N$5:$Q$5) 63.5 =SUMPRODUCT(F10:I10,$N$5:$Q$5) 76.1 =SUMPRODUCT(F11:I11,$N$5:$Q$5) 70.4 =SUMPRODUCT(F12:I12,$N$5:$Q$5) 82.5 =SUMPRODUCT(F13:I13,$N$5:$Q$5) 76.1 =SUMPRODUCT(F14:I14,$N$5:$Q$5) 94.6 =SUMPRODUCT(F15:I15,$N$5:$Q$5) 88.8 =SUMPRODUCT(F16:I16,$N$5:$Q$5) 63.5 =SUMPRODUCT(F17:I17,$N$5:$Q$5) 75.3 =SUMPRODUCT(F18:I18,$N$5:$Q$5) 71.9 =SUMPRODUCT(F19:I19,$N$5:$Q$5) 82.1 =SUMPRODUCT(F20:I20,$N$5:$Q$5) 70.5 =SUMPRODUCT(F21:I21,$N$5:$Q$5) 66.3 =SUMPRODUCT(F22:I22,$N$5:$Q$5) 78.7 =SUMPRODUCT(F23:I23,$N$5:$Q$5) 75.1 =SUMPRODUCT(F24:I24,$N$5:$Q$5) 79.9 =SUMPRODUCT(F25:I25,$N$5:$Q$5) 72.8 =SUMPRODUCT(F26:I26,$N$5:$Q$5) 83.6 =SUMPRODUCT(F27:I27,$N$5:$Q$5) 56.9 =SUMPRODUCT(F28:I28,$N$5:$Q$5) 77.1 =SUMPRODUCT(F29:I29,$N$5:$Q$5) 87.7 =SUMPRODUCT(F30:I30,$N$5:$Q$5) 59.9 =SUMPRODUCT(F31:I31,$N$5:$Q$5) 66.5 =SUMPRODUCT(F32:I32,$N$5:$Q$5) 65.5 =SUMPRODUCT(F33:I33,$N$5:$Q$5)
[학생] : 95.8 =SUMPRODUCT(F4:I4,$N$5:$Q$5) 88.7 =F5*$N$5+G5*$O$5+H5*$P$5+I5*$Q$5 84.8 =F6*$N$5+G6*$O$5+H6*$P$5+I6*$Q$5 72.4 =F7*$N$5+G7*$O$5+H7*$P$5+I7*$Q$5 60.3 =F8*$N$5+G8*$O$5+H8*$P$5+I8*$Q$5 78.7 =F9*$N$5+G9*$O$5+H9*$P$5+I9*$Q$5 63.5 =F10*$N$5+G10*$O$5+H10*$P$5+I10*$Q$5 76.1 =F11*$N$5+G11*$O$5+H11*$P$5+I11*$Q$5 70.4 =F12*$N$5+G12*$O$5+H12*$P$5+I12*$Q$5 82.5 =F13*$N$5+G13*$O$5+H13*$P$5+I13*$Q$5 76.1 =F14*$N$5+G14*$O$5+H14*$P$5+I14*$Q$5 94.6 =F15*$N$5+G15*$O$5+H15*$P$5+I15*$Q$5 88.8 =F16*$N$5+G16*$O$5+H16*$P$5+I16*$Q$5 63.5 =F17*$N$5+G17*$O$5+H17*$P$5+I17*$Q$5 75.3 =F18*$N$5+G18*$O$5+H18*$P$5+I18*$Q$5 71.9 =F19*$N$5+G19*$O$5+H19*$P$5+I19*$Q$5 82.1 =F20*$N$5+G20*$O$5+H20*$P$5+I20*$Q$5 70.5 =F21*$N$5+G21*$O$5+H21*$P$5+I21*$Q$5 66.3 =F22*$N$5+G22*$O$5+H22*$P$5+I22*$Q$5 78.7 =F23*$N$5+G23*$O$5+H23*$P$5+I23*$Q$5 75.1 =F24*$N$5+G24*$O$5+H24*$P$5+I24*$Q$5 79.9 =F25*$N$5+G25*$O$5+H25*$P$5+I25*$Q$5 72.8 =F26*$N$5+G26*$O$5+H26*$P$5+I26*$Q$5 83.6 =F27*$N$5+G27*$O$5+H27*$P$5+I27*$Q$5 56.9 =F28*$N$5+G28*$O$5+H28*$P$5+I28*$Q$5 77.1 =F29*$N$5+G29*$O$5+H29*$P$5+I29*$Q$5 87.7 =F30*$N$5+G30*$O$5+H30*$P$5+I30*$Q$5 59.9 =F31*$N$5+G31*$O$5+H31*$P$5+I31*$Q$5 66.5 =F32*$N$5+G32*$O$5+H32*$P$5+I32*$Q$5 65.5 =F33*$N$5+G33*$O$5+H33*$P$5+I33*$Q$5