EXCL1904_201922002_구가을_131683_assignsubmission_file_EXCL1904_차트201922002.xlsm
[점수(100점 만점)] : 40
[상세점수] :
[과제(배점:100점)] : 40
[문제] : 과제, I4:I33, [틀림]점수 계산이 틀렸습니다.
[정답] : 95.8 =E4*$N$4+F4*$N$5+G4*$N$6+H4*$N$7 88.7 =E5*$N$4+F5*$N$5+G5*$N$6+H5*$N$7 84.8 =E6*$N$4+F6*$N$5+G6*$N$6+H6*$N$7 72.4 =E7*$N$4+F7*$N$5+G7*$N$6+H7*$N$7 60.3 =E8*$N$4+F8*$N$5+G8*$N$6+H8*$N$7 78.7 =E9*$N$4+F9*$N$5+G9*$N$6+H9*$N$7 63.5 =E10*$N$4+F10*$N$5+G10*$N$6+H10*$N$7 76.1 =E11*$N$4+F11*$N$5+G11*$N$6+H11*$N$7 70.4 =E12*$N$4+F12*$N$5+G12*$N$6+H12*$N$7 82.5 =E13*$N$4+F13*$N$5+G13*$N$6+H13*$N$7 76.1 =E14*$N$4+F14*$N$5+G14*$N$6+H14*$N$7 94.6 =E15*$N$4+F15*$N$5+G15*$N$6+H15*$N$7 88.8 =E16*$N$4+F16*$N$5+G16*$N$6+H16*$N$7 63.5 =E17*$N$4+F17*$N$5+G17*$N$6+H17*$N$7 75.3 =E18*$N$4+F18*$N$5+G18*$N$6+H18*$N$7 71.9 =E19*$N$4+F19*$N$5+G19*$N$6+H19*$N$7 82.1 =E20*$N$4+F20*$N$5+G20*$N$6+H20*$N$7 70.5 =E21*$N$4+F21*$N$5+G21*$N$6+H21*$N$7 66.3 =E22*$N$4+F22*$N$5+G22*$N$6+H22*$N$7 78.7 =E23*$N$4+F23*$N$5+G23*$N$6+H23*$N$7 75.1 =E24*$N$4+F24*$N$5+G24*$N$6+H24*$N$7 79.9 =E25*$N$4+F25*$N$5+G25*$N$6+H25*$N$7 72.8 =E26*$N$4+F26*$N$5+G26*$N$6+H26*$N$7 83.6 =E27*$N$4+F27*$N$5+G27*$N$6+H27*$N$7 56.9 =E28*$N$4+F28*$N$5+G28*$N$6+H28*$N$7 77.1 =E29*$N$4+F29*$N$5+G29*$N$6+H29*$N$7 87.7 =E30*$N$4+F30*$N$5+G30*$N$6+H30*$N$7 59.9 =E31*$N$4+F31*$N$5+G31*$N$6+H31*$N$7 66.5 =E32*$N$4+F32*$N$5+G32*$N$6+H32*$N$7 65.5 =E33*$N$4+F33*$N$5+G33*$N$6+H33*$N$7
[학생] : 94.3 =E4*$N$4+F4*$N$5+F4*$N$6+H4*$N$7 91.7 =E5*$N$4+F5*$N$5+F5*$N$6+H5*$N$7 85.7 =E6*$N$4+F6*$N$5+F6*$N$6+H6*$N$7 72.4 =E7*$N$4+F7*$N$5+F7*$N$6+H7*$N$7 52.5 =E8*$N$4+F8*$N$5+F8*$N$6+H8*$N$7 74.5 =E9*$N$4+F9*$N$5+F9*$N$6+H9*$N$7 64.7 =E10*$N$4+F10*$N$5+F10*$N$6+H10*$N$7 76.1 =E11*$N$4+F11*$N$5+F11*$N$6+H11*$N$7 59.9 =E12*$N$4+F12*$N$5+F12*$N$6+H12*$N$7 81.3 =E13*$N$4+F13*$N$5+F13*$N$6+H13*$N$7 70.1 =E14*$N$4+F14*$N$5+F14*$N$6+H14*$N$7 95.5 =E15*$N$4+F15*$N$5+F15*$N$6+H15*$N$7 88.2 =E16*$N$4+F16*$N$5+F16*$N$6+H16*$N$7 59.3 =E17*$N$4+F17*$N$5+F17*$N$6+H17*$N$7 71.7 =E18*$N$4+F18*$N$5+F18*$N$6+H18*$N$7 68.9 =E19*$N$4+F19*$N$5+F19*$N$6+H19*$N$7 84.5 =E20*$N$4+F20*$N$5+F20*$N$6+H20*$N$7 66.3 =E21*$N$4+F21*$N$5+F21*$N$6+H21*$N$7 72 =E22*$N$4+F22*$N$5+F22*$N$6+H22*$N$7 74.5 =E23*$N$4+F23*$N$5+F23*$N$6+H23*$N$7 72.1 =E24*$N$4+F24*$N$5+F24*$N$6+H24*$N$7 73.3 =E25*$N$4+F25*$N$5+F25*$N$6+H25*$N$7 72.8 =E26*$N$4+F26*$N$5+F26*$N$6+H26*$N$7 83.6 =E27*$N$4+F27*$N$5+F27*$N$6+H27*$N$7 51.2 =E28*$N$4+F28*$N$5+F28*$N$6+H28*$N$7 66.3 =E29*$N$4+F29*$N$5+F29*$N$6+H29*$N$7 87.4 =E30*$N$4+F30*$N$5+F30*$N$6+H30*$N$7 52.1 =E31*$N$4+F31*$N$5+F31*$N$6+H31*$N$7 67.1 =E32*$N$4+F32*$N$5+F32*$N$6+H32*$N$7 55.9 =E33*$N$4+F33*$N$5+F33*$N$6+H33*$N$7
[문제] : 과제, J4:J33, [틀림]학점 계산이 틀렸습니다.
[정답] : A+ =VLOOKUP(I4,$M$10:$N$18,2) B+ =VLOOKUP(I5,$M$10:$N$18,2) B =VLOOKUP(I6,$M$10:$N$18,2) C =VLOOKUP(I7,$M$10:$N$18,2) D =VLOOKUP(I8,$M$10:$N$18,2) C+ =VLOOKUP(I9,$M$10:$N$18,2) D =VLOOKUP(I10,$M$10:$N$18,2) C+ =VLOOKUP(I11,$M$10:$N$18,2) C =VLOOKUP(I12,$M$10:$N$18,2) B =VLOOKUP(I13,$M$10:$N$18,2) C+ =VLOOKUP(I14,$M$10:$N$18,2) A =VLOOKUP(I15,$M$10:$N$18,2) B+ =VLOOKUP(I16,$M$10:$N$18,2) D =VLOOKUP(I17,$M$10:$N$18,2) C+ =VLOOKUP(I18,$M$10:$N$18,2) C =VLOOKUP(I19,$M$10:$N$18,2) B =VLOOKUP(I20,$M$10:$N$18,2) C =VLOOKUP(I21,$M$10:$N$18,2) D+ =VLOOKUP(I22,$M$10:$N$18,2) C+ =VLOOKUP(I23,$M$10:$N$18,2) C+ =VLOOKUP(I24,$M$10:$N$18,2) C+ =VLOOKUP(I25,$M$10:$N$18,2) C =VLOOKUP(I26,$M$10:$N$18,2) B =VLOOKUP(I27,$M$10:$N$18,2) F =VLOOKUP(I28,$M$10:$N$18,2) C+ =VLOOKUP(I29,$M$10:$N$18,2) B+ =VLOOKUP(I30,$M$10:$N$18,2) F =VLOOKUP(I31,$M$10:$N$18,2) D+ =VLOOKUP(I32,$M$10:$N$18,2) D+ =VLOOKUP(I33,$M$10:$N$18,2)
[학생] : -2146826246 =VLOOKUP(I4,M10:N18,I4,0) A =VLOOKUP(I5,M11:$N$18,2) B+ =VLOOKUP(I6,M12:$N$18,2) C =VLOOKUP(I7,M13:$N$18,2) -2146826246 =VLOOKUP(I8,M14:$N$18,2) -2146826246 =VLOOKUP(I9,M15:$N$18,2) -2146826246 =VLOOKUP(I10,M16:$N$18,2) -2146826246 =VLOOKUP(I11,M17:$N$18,2) -2146826246 =VLOOKUP(I12,M18:$N$18,2) -2146826246 =VLOOKUP(I13,M$18:$N19,2) -2146826246 =VLOOKUP(I14,M$18:$N20,2) A+ =VLOOKUP(I15,M$18:$N21,2) -2146826246 =VLOOKUP(I16,M$18:$N22,2) -2146826246 =VLOOKUP(I17,M$18:$N23,2) -2146826246 =VLOOKUP(I18,M$18:$N24,2) -2146826246 =VLOOKUP(I19,M$18:$N25,2) -2146826246 =VLOOKUP(I20,M$18:$N26,2) -2146826246 =VLOOKUP(I21,M$18:$N27,2) -2146826246 =VLOOKUP(I22,M$18:$N28,2) -2146826246 =VLOOKUP(I23,M$18:$N29,2) -2146826246 =VLOOKUP(I24,M$18:$N30,2) -2146826246 =VLOOKUP(I25,M$18:$N31,2) -2146826246 =VLOOKUP(I26,M$18:$N32,2) -2146826246 =VLOOKUP(I27,M$18:$N33,2) -2146826246 =VLOOKUP(I28,M$18:$N34,2) -2146826246 =VLOOKUP(I29,M$18:$N35,2) -2146826246 =VLOOKUP(I30,M$18:$N36,2) -2146826246 =VLOOKUP(I31,M$18:$N37,2) -2146826246 =VLOOKUP(I32,M$18:$N38,2) -2146826246 =VLOOKUP(I33,M$18:$N39,2)
[문제] : 과제, K4:K33, [틀림]등수 계산이 틀렸습니다.
[정답] : 1 =RANK.EQ(I4,$I$4:$I$33) 4 =RANK.EQ(I5,$I$4:$I$33) 6 =RANK.EQ(I6,$I$4:$I$33) 19 =RANK.EQ(I7,$I$4:$I$33) 28 =RANK.EQ(I8,$I$4:$I$33) 11 =RANK.EQ(I9,$I$4:$I$33) 26 =RANK.EQ(I10,$I$4:$I$33) 14 =RANK.EQ(I11,$I$4:$I$33) 22 =RANK.EQ(I12,$I$4:$I$33) 8 =RANK.EQ(I13,$I$4:$I$33) 14 =RANK.EQ(I14,$I$4:$I$33) 2 =RANK.EQ(I15,$I$4:$I$33) 3 =RANK.EQ(I16,$I$4:$I$33) 26 =RANK.EQ(I17,$I$4:$I$33) 16 =RANK.EQ(I18,$I$4:$I$33) 20 =RANK.EQ(I19,$I$4:$I$33) 9 =RANK.EQ(I20,$I$4:$I$33) 21 =RANK.EQ(I21,$I$4:$I$33) 24 =RANK.EQ(I22,$I$4:$I$33) 11 =RANK.EQ(I23,$I$4:$I$33) 17 =RANK.EQ(I24,$I$4:$I$33) 10 =RANK.EQ(I25,$I$4:$I$33) 18 =RANK.EQ(I26,$I$4:$I$33) 7 =RANK.EQ(I27,$I$4:$I$33) 30 =RANK.EQ(I28,$I$4:$I$33) 13 =RANK.EQ(I29,$I$4:$I$33) 5 =RANK.EQ(I30,$I$4:$I$33) 29 =RANK.EQ(I31,$I$4:$I$33) 23 =RANK.EQ(I32,$I$4:$I$33) 25 =RANK.EQ(I33,$I$4:$I$33)
[학생] : 2 =RANK(I4,$I$4:$I$33) 3 =RANK(I5,$I$4:$I$33) 6 =RANK(I6,$I$4:$I$33) 15 =RANK(I7,$I$4:$I$33) 28 =RANK(I8,$I$4:$I$33) 11 =RANK(I9,$I$4:$I$33) 24 =RANK(I10,$I$4:$I$33) 10 =RANK(I11,$I$4:$I$33) 25 =RANK(I12,$I$4:$I$33) 9 =RANK(I13,$I$4:$I$33) 19 =RANK(I14,$I$4:$I$33) 1 =RANK(I15,$I$4:$I$33) 4 =RANK(I16,$I$4:$I$33) 26 =RANK(I17,$I$4:$I$33) 18 =RANK(I18,$I$4:$I$33) 20 =RANK(I19,$I$4:$I$33) 7 =RANK(I20,$I$4:$I$33) 22 =RANK(I21,$I$4:$I$33) 17 =RANK(I22,$I$4:$I$33) 11 =RANK(I23,$I$4:$I$33) 16 =RANK(I24,$I$4:$I$33) 13 =RANK(I25,$I$4:$I$33) 14 =RANK(I26,$I$4:$I$33) 8 =RANK(I27,$I$4:$I$33) 30 =RANK(I28,$I$4:$I$33) 22 =RANK(I29,$I$4:$I$33) 5 =RANK(I30,$I$4:$I$33) 29 =RANK(I31,$I$4:$I$33) 21 =RANK(I32,$I$4:$I$33) 27 =RANK(I33,$I$4:$I$33)
[문제] : 과제, Q4:U4, [틀림]평균점수 계산이 틀렸습니다.
[정답] : 70 =AVERAGE(E4:E33) 70.7666666666667 =AVERAGE(F4:F33) 79.6666666666667 =AVERAGE(G4:G33) 76.2 =AVERAGE(H4:H33) 75.5333333333333 =AVERAGE(I4:I33)
[학생] : 70 =AVERAGE(E4:E33) 70.7666666666667 =AVERAGE(F4:F33) 79.6666666666667 =AVERAGE(G4:G33) 76.2 =AVERAGE(H4:H33) 72.8633333333333 =AVERAGE(I4:I33)
[문제] : 과제, Q5:U5, [틀림]최고점수 계산이 틀렸습니다.
[정답] : 99 =MAX(E4:E33) 98 =MAX(F4:F33) 97 =MAX(G4:G33) 96 =MAX(H4:H33) 95.8 =MAX(I4:I33)
[학생] : 99 =MAX(E4:E33) 98 =MAX(F4:F33) 97 =MAX(G4:G33) 96 =MAX(H4:H33) 95.5 =MAX(I4:I33)
[문제] : 과제, Q6:U6, [틀림]최저점수 계산이 틀렸습니다.
[정답] : 41 =MIN(E4:E33) 45 =MIN(F4:F33) 64 =MIN(G4:G33) 55 =MIN(H4:H33) 56.9 =MIN(I4:I33)
[학생] : 41 =MIN(E4:E33) 45 =MIN(F4:F33) 64 =MIN(G4:G33) 55 =MIN(H4:H33) 51.2 =MIN(I4:I33)
[문제] : 과제, O10:O18, [틀림]인원이 틀렸습니다.
[정답] : 2 =COUNTIF($J$4:$J$33,N10) 3 =COUNTIF($J$4:$J$33,N11) 3 =COUNTIF($J$4:$J$33,N12) 5 =COUNTIF($J$4:$J$33,N13) 8 =COUNTIF($J$4:$J$33,N14) 4 =COUNTIF($J$4:$J$33,N15) 3 =COUNTIF($J$4:$J$33,N16) 1 =COUNTIF($J$4:$J$33,N17) 1 =COUNTIF($J$4:$J$33,N18)
[학생] :