2017,16년 ITQ엑셀 기출문제

2017년 11월

GE11-11A.pdf    GE11-11B.pdf    GE11-11C.pdf

GE11-11A.xlsx    GE11-11B.xlsx    GE11-11C.xlsx

 

 

2017년 10월

GE10-14Asx.pdf    GE10-14B.pdf    GE10-14C.pdf

GE10-14A.xlsx    GE10-14B.xlsx    GE10-14C.xlsx

 

 

2017년 9월

GE09-09A.pdf    GE09-09B.pdf    GE09-09C.pdf

GE09-09A.xlsx    GE09-09B.xlsx    GE09-09C.xlsx

 

 

2017년 8월 부분합

GE08-14A.pdf        GE08-14B.pdf        GE08-14C.pdf

GE08-14A.xlsx        GE08-14B.xlsx        GE08-14C.xlsx

A형

(1)  =RANK(H5,임대규모)

(2)  =MID(B5,2,3)

(3)  =COUNTIF(F5:F12,"<5000")

(4)  =MIN(F5:F12)

(5)  =ROUND(DAVERAGE(B4:H12,6,D4:D5),-4)

(6)  =DAY(VLOOKUP(H14,C5:H12,3,FALSE))&"일"

 

 

2017년 7월 피벗테이블

GE07-08A.pdf    GE07-08B.pdf    GE07-08C.pdf

GE07-08A.xlsx    GE07-08B.xlsx    GE07-08C.xlsx    

A형

(1)  =DATE(2016,MID(B5,5,2),MID(B5,7,2))

(2)  =IF(H5<=50,"추가주문","")

(3)  =ROUNDUP(DAVERAGE(B4:H12,6,D4:D5),0)

(4)  =RANK(H11,H5:H12)&"위"

(5)  =SMALL(판매금액,1)

(6)  =VLOOKUP(H14,B5:H12,4,0)

 

2017년 6월 피벗테이블

GE06-10A.pdf    GE06-10B.pdf    GE06-10C.pdf

GE06-10A.xlsx    GE06-10B.xlsx    GE06-10C.xlsx

(1)  =CHOOSE(MID(B5,3,1),"1박2일","2박3일","3박4일")

(2)  =H5*IF(D5="회원",0.8,0.9)

(3)  =COUNTIF(E5:E12,"골드")&"건"

(4)  =MIN(예약일)

(5)  =ROUNDUP(DAVERAGE(B4:H12,7,D4:D5),-3)

(6)  =VLOOKUP(H14,C5:H12,6,FALSE)

 

2017년 5월 피벗테이블

GE05-13A.pdf     GE05-13B.pdf     GE05-13C.pdf

GE05-13A.xlsx     GE05-13B.xlsx     GE05-13C.xlsx

=IF(RIGHT(B5,1)="M","남성용",IF(RIGHT(B5,1)="W","여성용",""))

=REPT("★",H5)&REPT("☆",5-H5)

=LARGE(판매금액,2)

=COUNTIF(D5:D12,"운동화")

=ROUND(DAVERAGE(B4:J12,G4,D4:D5),0)

=VLOOKUP(H14,B5:H12,6,FALSE)

 

2017년 4월 피벗테이블

GE04-08A.pdf     GE04-08B.pdf     GE04-08C.pdf

GE04-08A.xlsx     GE04-08B.xlsx     GE04-08C.xlsx 

A형

(1)  =ROUND(H5*IF(H5<=2500000,3%,4%),-3)

(2)  =RANK(E5,$E$5:$E$12)&"위"

(3)  =DSUM(B4:H12,E4,D4:D5)

(4)  =SUMIF(D5:D12,"기획",H5:H12)/COUNTIF(D5:D12,"기획")

(5)  =SMALL(평균경력,1)

(6)  =VLOOKUP(H14,C5:H12,6,0)

 

2017년 3월 부분합

GE03-11A.pdf    GE03-11B.pdf     GE03-11C.pdf

GE03-11A.xlsx   GE03-11B.xlsx   GE03-11C.xlsx

 

2017년 2월 부분합

GE02-11A.pdf  GE02-11B.pdf  GE02-11C.pdf

GE02-11A.xlsx  GE02-11B.xlsx  GE02-11C.xlsx

 

 

2017년 1월

GE01-14A.pdf  GE01-14B.pdf GE01-14C.pdf

GE01-14A.xlsx  GE01-14B.xlsx  GE01-14C.xlsx

 

 

12월

GE12-10A.pdf GE12-10B.pdf  GE12-10C.pdf

GE12-10A.xlsx  GE12-10B.xlsx  GE12-10C.xlsx

 

 

11월

GE11-12A.pdfGE11-12B.pdfGE11-12C.pdf

GE11-12A.xlsxGE11-12B.xlsxGE11-12C.xlsx

10월

GE10-08A.pdfGE10-08B.pdfGE10-08C.pdf

GE10-08A.xlsxGE10-08B.xlsxGE10-08C.xlsx

9월

GE09-10A.pdfGE09-10B.pdfGE09-10C.pdf

GE09-10A.xlsxGE09-10B.xlsxGE09-10C.xlsx

8월

GE08-13A.pdfGE08-13B.pdfGE08-13C.pdf 

GE08-13A.xlsxGE08-13B.xlsxGE08-13C.xlsx

7월

GE07-09A.pdfGE07-09B.pdfGE07-09C.pdf

GE07-09A.xlsxGE07-09B.xlsxGE07-09C.xlsx

6월

GE06-11A.pdfGE06-11B.pdfGE06-11C.pdf

GE06-11A.xlsxGE06-11B.xlsxGE06-11C.xlsx

5월

GE05-14A.pdfGE05-14B.pdfGE05-14C.pdf

  

답안

GE05-14A.xlsxGE05-14B.xlsxGE05-14C.xlsx

4월

GE04-09A.pdfGE04-09B.pdfGE04-09C.pdf

GE04-09A.xlsxGE04-09B.xlsxGE04-09C.xlsx

3월

GE03-12A.pdfGE03-12B.pdfGE03-12C.pdf

GE03-12A.xlsxGE03-12B.xlsxGE03-12C.xlsx

2월

GE02-13A.pdfGE02-13B.pdfGE02-13C.pdf

GE02-13A.xlsxGE02-13B.xlsxGE02-13C.xlsx

1월

GE01-09A.pdfGE01-09B.pdfGE01-09C.pdf

GE01-09A.xlsxGE01-09B.xlsxGE01-09C.xlsx