기본모의고사 1~4회

[리비아]

가전예상실적.txt

고객분류.txt

과목코드.txt

기본모의고사1회.xlsm

기본모의고사2회.xlsm

기본모의고사3회.xlsm

기본모의고사4회.xlsm

정답파일!!

기본모의고사1회(정답).xlsm

기본모의고사2회(정답).xlsm

기본모의고사3회(정답).xlsm

기본모의고사4회(정답).xlsm

기본모의고사 1번

=CHOOSE(RANK(E4,$E$4:$E$11),"대상","금상","은상","동상","","","","")

=DATE(LEFT(I4,2),MID(I4,3,2),MID(I4,5,2))

=VLOOKUP(C16,$G$17:$H$20,2,0)*D16

=DCOUNT(J15:M23,3,J25:K26)&"명"

=IF(AND(C27>=AVERAGE($C$27:$C$32),D27>=AVERAGE($D$27:$D$32)),"합격했네","미친놈")

기본모의고사 2번

=DSUM(B2:D10,D2,A12:A13)/SUM(D3:D10)

=IF(G3>=3,H3+12*J3,H3+12*I3)

=DATE(MID(B17,1,2),MID(B17,3,2),MID(B17,5,2))

=TIME(HOUR(H17),MINUTE(H17)+I17*J17,0)

=VLOOKUP(B27,$F$27:$G$31,2,0)*C27

기본모의고사 3번

=IF(RANK(B3,$B$3:$B$11)=1,"대상",IF(RANK(B3,$B$3:$B$11)<=3,"금상",IF(RANK(B3,$B$3:$B$11)<=6,"동상","")))

=ROUNDUP(DAVERAGE(E2:G11,G2,H2:H3),-3)

=IF(IF(B16="필",C16+3,C16)>=AVERAGE($C$16:$C$23),"합격","불합격")

=IFERROR(HLOOKUP(AVERAGE(G16:H16),$G$25:$J$27,3,1),"병슝")

=IF(DAY(B27)<=10,"상순",IF(DAY(B27)<=20,"중순","하순"))

기본모의고사 4번

=IF(DAY(B3)>=15,B3+10,B3+7)

=ROUND(SUM(F3:F10)/SUM(G3:G10)*100,1)

=ROUNDDOWN(DAVERAGE(A13:C21,C13,A23:A24),-3)

=VLOOKUP(F15,$J$16:$L$19,3,1)+G15

=CHOOSE(RANK(C28,$C$28:$C$34),"100%","90%","80%","","","")