최신 기출문제 함수 정답(1~10회)

(1)

- 1 -

제1회 최신 기출문제 함수 정답

① =RANK(F5,$F$5:$F$12)&"위"

② =CHOOSE(WEEKDAY(H5,2),"월요일","화요일","수요일","목요일","금요일","토요 일","일요일")

③ =SUMIF(D5:D12,"대한항공",F5:F12)/COUNTIF(D5:D12,"대한항공")

④ =SUMPRODUCT(F5:F12,상품금액)

⑤ =LARGE(상품금액,2)

⑥ =VLOOKUP(H14,C5:H12,5,0)

① =RANK(F5,$F$5:$F$12,1)

② =IF(RIGHT(B5,1)="1","세계3대",IF(RIGHT(B5,1)="2","세계4대",""))

③ =MAX(개최횟수)

④ =COUNTIF(G5:G12,">="&AVERAGE(G5:G12))&"개"

⑤ =DSUM(B4:H12,G4,E4:E5)

⑥ =VLOOKUP(H14,B5:H12,3,0)

① =IF(D5="건어물",G5*10%,G5*5%)

② =CHOOSE(MID(B5,5,1),"냉장보관","건냉한 장소","냉동보관")

③ =COUNTIF(H5:H12,"<"&MEDIAN(H5:H12))&"개"

④ =DAVERAGE(B4:H12,G4,D4:D5)

⑤ =MAX(판매가)

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

① =RANK(G5,$G$5:$G$12,1)

② =IF(RIGHT(B5,1)="1","서아시아",IF(RIGHT(B5,1)="2","동아시아","미주"))

③ =COUNTIF(용도,"*호텔*")

④ =DMAX(B4:H12,7,D4:D5)

⑤ =YEAR(TODAY())-G9&"년"

⑥ =VLOOKUP(H14,C5:H12,4,0)

① =CHOOSE(WEEKDAY(F5,2),"월요일","화요일","수요일","목요일","금요일","토요 일","일요일")

② =RANK(G5,$G$5:$G$12)&"위"

③ =ROUND(DAVERAGE(B4:H12,H4,D4:D5),0)

④ =SUMIF(D5:D12,"기획",G5:G12)

⑤ =SMALL(전시기간,1)

⑥ =VLOOKUP(H14,C5:H12,5,0)

① =IF(RANK(G5,$G$5:$G$12)<=3,RANK(G5,$G$5:$G$12),"")

② =RIGHT(B5,4)

③ =MAX(가격)

④ =COUNTIF(D5:D12,"기능성")&"개"

⑤ =ROUND(DAVERAGE(B4:H12,G4,D4:D5),-2)

⑥ =VLOOKUP(H14,C5:H12,4,0)*VLOOKUP(H14,C5:H12,5,0)