강사와 사람들

세종사이버대 e-Test 엑셀 자료

연습문제 1
3번함수
=ROUNDUP(E4/SUM($E$4:$E$19)*100,0)
4번함수
=IF(OR(MID(A4,3,1)="북",MID(A4,3,1)="남"),RANK.EQ(E4,$E$4:$E$19,0),SUM(B4:E4))
5번함수
=VLOOKUP(A4,'수식 데이터'!$A$3:$C$19,3,FALSE)

연습문제 2
3번함수
=ROUNDDOWN(D4-AVERAGEA($D$4:$D$19),1)
4번함수
=iF(LEN(A4)=5,RANK.EQ(B4,$B$4:$B$19,0),AVERAGE(B4:E4))
5번함수
=AVERAGEIF($A$4:$A$19,A4,'수식 데이터'!$C$3:$C$66)

연습문제 3

3번함수
=ROUNDUP(B4-AVERAGE($B$4:$B$19),-1)
4번함수
=IF(OR(MOD(LEFT(A4,4),3)=0,MOD(LEFT(A4,4),4)=0),RANK.EQ(D4,$D$4:$D$19,0),SUM(B4:E4))
5번함수
=VLOOKUP(VALUE(LEFT(A4,2)),'수식 데이터'!$A$1:$C$3,3,FALSE)