EXCL1903_201921037_전세미_129596_assignsubmission_file_201921037 전세미.xlsm
[점수(100점 만점)] : 50
[상세점수] :
[과제(배점:100점)] : 50
[문제] : 과제, D19, [틀림]평균 구하기 틀림
[정답] : 79.55 =AVERAGE(H4:H13)
[학생] : 79.55 79.55
[문제] : 과제, D18, [틀림]인원 구하기 틀림
[정답] : 10 =COUNT(H4:H13)
[학생] : 10 10
[문제] : 과제, J4:J13, [틀림]등수 구하기 틀림
[정답] : 1 =RANK.EQ(H4,$H$4:$H$13) 4 =RANK.EQ(H5,$H$4:$H$13) 3 =RANK.EQ(H6,$H$4:$H$13) 9 =RANK.EQ(H7,$H$4:$H$13) 7 =RANK.EQ(H8,$H$4:$H$13) 10 =RANK.EQ(H9,$H$4:$H$13) 6 =RANK.EQ(H10,$H$4:$H$13) 5 =RANK.EQ(H11,$H$4:$H$13) 8 =RANK.EQ(H12,$H$4:$H$13) 2 =RANK.EQ(H13,$H$4:$H$13)
[학생] : 1 1 4 4 3 3 9 9 7 7 10 10 6 6 5 5 8 8 2 2
[문제] : 과제, H4:H13, [틀림]점수 구하기 틀림
[정답] : 90 =D4*$D$15+E4*$E$15+F4*$F$15+G4*$G$15 86 =D5*$D$15+E5*$E$15+F5*$F$15+G5*$G$15 86.5 =D6*$D$15+E6*$E$15+F6*$F$15+G6*$G$15 72 =D7*$D$15+E7*$E$15+F7*$F$15+G7*$G$15 73.5 =D8*$D$15+E8*$E$15+F8*$F$15+G8*$G$15 67.5 =D9*$D$15+E9*$E$15+F9*$F$15+G9*$G$15 74 =D10*$D$15+E10*$E$15+F10*$F$15+G10*$G$15 83.5 =D11*$D$15+E11*$E$15+F11*$F$15+G11*$G$15 73 =D12*$D$15+E12*$E$15+F12*$F$15+G12*$G$15 89.5 =D13*$D$15+E13*$E$15+F13*$F$15+G13*$G$15
[학생] : 90 90 86 86 86.5 86.5 72 72 73.5 73.5 67.5 67.5 74 74 83.5 83.5 73 73 89.5 89.5