교재특징
수험생의 목적은 합격이며 절대평가의 방식인 컴퓨터활용능력 1급 필기에서는
만점을 받는 것이 중요한 것이 아니라 합격하는 것이 중요하다는 전제아래 기존
의 교재집필 방식을 탈피하여 시험문제 출제 빈도수가 낮은 부분의 설명은 과감
히 생략하고, 기출빈도가 높은 부분을 위주로 저술하였습니다.
목차
CHAPTER 01 기출 문제를 통한 핵심 이론 정리
1과목 컴퓨터 일반 ···································································· 9
SECTION 01 한글 Windows 10 ∙ 10
SECTION 02 컴퓨터 시스템 ∙ 34
SECTION 03 컴퓨터 하드웨어 ∙ 38
SECTION 04 컴퓨터 소프트웨어 ∙ 55
SECTION 05 인터넷 활용 ∙ 64
SECTION 06 멀티미디어 활용 ∙ 78
SECTION 07 컴퓨터 시스템 보안 ∙ 84
2과목 스프레드시트 ······························································· 93
SECTION 01 기본 작업 ∙ 94
SECTION 02 계산 작업 ∙ 125
SECTION 03 분석 작업 ∙ 140
SECTION 04 기타 작업 ∙ 153
3과목 데이터베이스 ······························································ 167
SECTION 01 데이터베이스 일반 ∙ 168
SECTION 02 DB구축 ∙ 175
SECTION 03 입력 및 수정 ∙ 185
SECTION 04 조회 및 출력 ∙ 198
SECTION 05 매크로 & 프로그래밍 ∙ 207
SECTION 06 질의(Query) ∙ 211
CHAPTER 02 기출문제 문제
01 2020년 2회 기출문제 ·············································· 224
02 2020년 1회 기출문제 ··············································· 238
03 2019년 2회 기출문제 ················································ 251
04 2019년 1회 기출문제 ················································ 264
05 2018년 2회 기출문제 ················································ 277
06 2018년 1회 기출문제 ················································ 291
CHAPTER 03 실전 모의고사
01 실전 모의고사 ··························································· 306
02 실전 모의고사 ····························································· 315
03 실전 모의고사 ···························································· 325
04 실전 모의고사 ···························································· 335
05 실전 모의고사 ···························································· 345
06 실전 모의고사 ···························································· 355
실전 모의고사 정답 및 해설 ······································ 366
