상담신청
캠퍼스*
문의과목*
이름*
연락처*
- -
문의사항
내용확인

line 빠른상담신청

웹디자인 윙배너
모션그래픽 윙배네
DTP 윙배너
CG/VFX 윙배너
인테리어 윙배너

전문교재

PROFESSIONAL BOOKS

  • 직접수령상품

  • Let’s 컴퓨터 활용능력 2급 실기


    저자 김혜은 ISBN 9788965121350
    출간일 2021년 05월 14일 도서정보 308쪽 / 188*257

    정가
    20,000원
    판매가 18,000 (10%할인)
    수량
    1
    +
    총 구매금액 18,000 바로구매
교재 소개

책소개

Let's Spread sheet
출제빈도가 높은 문제 중심의 합격 기본서
컴퓨터 활용능력 2급 실기


목차

01. 기본작업
데이터 입 력 ·································································· 8 
셀서식 ·············································································· 10 
선택하여 붙여넣기/연결하여 붙여넣기 ············ 25 
외부 데이터 가져오기 ············································ 28 
텍스트 나누기 ····························································· 36 
조건부 서식 ································································· 41 
자동필터 ······································································· 50 
고급필터 ······································································· 58

02. 계산작업
날짜와 시간 함수 ···················································· 65 
논리 함수 ···································································· 73 
데이터 베이스 함수 ··············································· 77 
문자열 함수 ······························································ 81 
수학과 삼각 함수 ··················································· 88 
통계 함수 ···································································· 96 
찾기/참조 함수 ························································109 
함수문제  유형 1~3 ········································ 116

03. 분석작업
정렬 ············································································· 124 
부분합 ········································································· 128
통합 ············································································· 135 
목표값 찾기 ···························································· 138 
시나리오 ····································································141 
데이터 표 ·································································· 152 
피벗 테이블 ···························································· 156

04. 기타작업
매크로 ··································································· 168 
차트 ······································································· 186

05. 기출문제유형
기출문제유형 1 ······················································ 200 
기출문제유형 2 ······················································ 233 
기출문제유형 3 ······················································ 256

부록 : 함수사전
실전 계산작업 유형 1~5

펼쳐보기
접기