EXCL1910_201979021_김진우_.xlsm

[점수(100점 만점)] : 95

[상세점수] :
        [과제1(배점:20점)] : 15
        [과제2(배점:30점)] : 30
        [과제3(배점:50점)] : 50

[문제] : 과제1, H6:H25, [틀림]중간평가 계산이 틀렸습니다.

[정답] : 	Pass	=IF(G6>=140, "Pass", "재시험")
	Pass	=IF(G7>=140, "Pass", "재시험")
	재시험	=IF(G8>=140, "Pass", "재시험")
	Pass	=IF(G9>=140, "Pass", "재시험")
	Pass	=IF(G10>=140, "Pass", "재시험")
	재시험	=IF(G11>=140, "Pass", "재시험")
	Pass	=IF(G12>=140, "Pass", "재시험")
	Pass	=IF(G13>=140, "Pass", "재시험")
	Pass	=IF(G14>=140, "Pass", "재시험")
	Pass	=IF(G15>=140, "Pass", "재시험")
	Pass	=IF(G16>=140, "Pass", "재시험")
	재시험	=IF(G17>=140, "Pass", "재시험")
	재시험	=IF(G18>=140, "Pass", "재시험")
	재시험	=IF(G19>=140, "Pass", "재시험")
	재시험	=IF(G20>=140, "Pass", "재시험")
	Pass	=IF(G21>=140, "Pass", "재시험")
	재시험	=IF(G22>=140, "Pass", "재시험")
	재시험	=IF(G23>=140, "Pass", "재시험")
	Pass	=IF(G24>=140, "Pass", "재시험")
	Pass	=IF(G25>=140, "Pass", "재시험")

[학생] : 	pass	=IF(G6>=140,"pass","재시험")
	pass	=IF(G7>=140,"pass","재시험")
	재시험	=IF(G8>=140,"pass","재시험")
	pass	=IF(G9>=140,"pass","재시험")
	pass	=IF(G10>=140,"pass","재시험")
	재시험	=IF(G11>=140,"pass","재시험")
	pass	=IF(G12>=140,"pass","재시험")
	pass	=IF(G13>=140,"pass","재시험")
	pass	=IF(G14>=140,"pass","재시험")
	pass	=IF(G15>=140,"pass","재시험")
	pass	=IF(G16>=140,"pass","재시험")
	재시험	=IF(G17>=140,"pass","재시험")
	재시험	=IF(G18>=140,"pass","재시험")
	재시험	=IF(G19>=140,"pass","재시험")
	재시험	=IF(G20>=140,"pass","재시험")
	pass	=IF(G21>=140,"pass","재시험")
	재시험	=IF(G22>=140,"pass","재시험")
	재시험	=IF(G23>=140,"pass","재시험")
	pass	=IF(G24>=140,"pass","재시험")
	pass	=IF(G25>=140,"pass","재시험")