根据吉林省大学考试办公室下发的《高等学校计算机水平考试（吉林省考区）》文件精神，按

照高校大学计算机基础课程教学大纲的要求，计算机办公自动化上机考试重在考查学生的计算机

知识水平和应用能力。为了使学生适应新的考试方法，提升实践操作能力，顺利地通过计算机水

平考试，特编写本书。本书包含了考试题库、操作过程分析、上机考试真题等内容。

本书内容全面、实践操作解析清晰，适合考生使用，也可以作为高校师生的大学计算机基础

课程的实践教材和参考书。

无

第一部分 计算机应用基础习题与参考答案

第1 章 计算机基础知识········································································································· 1

第2 章 Windows 7 操作系统······················································································12

第3 章 计算机网络与网络安全···················································································19

第4 章 多媒体技术基础·····························································································30

第5 章 IT 新技术·······································································································36

第二部分 上机考试实践指导

第6 章 Word 2010 文字处理软件···············································································40

案例1 ······························································································································· 40

案例2 ······························································································································· 46

案例3 ······························································································································· 55

案例4 ······························································································································· 63

案例5 ······························································································································· 73

案例6 ······························································································································· 80

第7 章 Excel 2010 电子表格处理软件········································································89

案例1 ······························································································································· 89

案例2 ······························································································································· 92

案例3 ······························································································································· 95

案例4 ······························································································································· 98

案例5 ······························································································································103

案例6 ······························································································································108

案例7 ······························································································································112

案例8 ······························································································································121

第8 章 PowerPoint 2010 演示文稿制作软件·····························································129

案例1 ······························································································································129

案例2 ······························································································································132

案例3 ······························································································································137

案例4 ······························································································································141

CONTENTS

目录

II 计算机等级考试习题汇编（二级 办公自动化）（第2 版）

案例5 ······························································································································144

案例6 ······························································································································148

第三部分 高等学校计算机水平考试（吉林省考区）办公自动化真题

试题1 ······························································································································154

试题2 ······························································································································158

试题3 ······························································································································162

试题4 ······························································································································165

试题5 ······························································································································168

试题6 ······························································································································170

附录 高等学校计算机水平考试（吉林省考区）办公自动化上机考试大纲·······174

根据吉林省大学考试办公室下发的《高等学校计算机水平考试（吉林省考区）》文件精神，按

照高校大学计算机基础课程教学大纲的要求，计算机办公自动化上机考试重在考查学生的计算机

知识水平和应用能力。为了使学生适应新的考试方法，提升实践操作能力，顺利地通过计算机水

平考试，特编写本书。本书包含了考试题库、操作过程分析、上机考试真题等内容。

本书内容全面、实践操作解析清晰，适合考生使用，也可以作为高校师生的大学计算机基础

课程的实践教材和参考书。

根据吉林省大学考试办公室下发的《高等学校计算机水平考试（吉林省考区）》文件精神，按照高校大学计算机基础课程教学大纲的要求，计算机办公自动化上机考试重在考查学生的计算机知识水平和应用能力。