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

line 빠른상담신청

전문교재

PROFESSIONAL BOOKS

  • 직접수령상품

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


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

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

책소개

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


목차

01. 기본작업

  1. 데이터 입 력 ·································································· 8 
  2. 셀서식 ·············································································· 10 
  3. 선택하여 붙여넣기/ 연결하여 붙여넣기 ············ 25 
  4. 외부 데이 터 가져오 기 ············································ 28 
  5. 텍스트 나 누기 ····························································· 36 
  6. 조건부 서 식 ································································· 41 
  7. 자동필 터 ······································································· 50 
  8. 고급필 터 ······································································· 58
02. 계산작업
  1. 날짜와 시 간 함수 ···················································· 65 
  2. 논리 함수 ···································································· 73 
  3. 데이터 베이스 함 수 ··············································· 77 
  4. 문자열 함 수 ······························································ 81 
  5. 수학과 삼 각 함수 ··················································· 88 
  6. 통계 함수 ···································································· 96 
  7. 찾기/ 참조 함수 ························································109 
  8. 함수문 제  유 형 1 ~ 3 ········································ 116
03. 분석작업
  1. 정렬 ············································································· 124 
  2. 부분합 ········································································· 128
  3. 통합 ············································································· 135 
  4. 목표값 찾 기 ···························································· 138 
  5. 시나리 오 ····································································141 
  6. 데이터 표 ·································································· 152 
  7. 피벗 테이 블 ···························································· 156
04. 기타작업
  1. 매크로 ··································································· 168 
  2. 차트 ······································································· 186
05. 기출문제 유형
  1. 기출문 제유형 1 ······················································ 200 
  2. 기출문 제유형 2 ······················································ 233 
  3. 기출문 제유형 3 ······················································ 256
부록 : 함수사전
        실전 계산작업 유형

펼쳐보기
접기