根据吉林省大学考试办公室下发的《高等学校计算机水平考试（吉林省考区）》文件精神，按
照高校大学计算机基础课程教学大纲的要求，计算机办公自动化上机考试重在考查学生的计算机
知识水平和应用能力。为了使学生适应新的考试方法，提升实践操作能力，顺利地通过计算机水
平考试，特编写本书。本书包含了考试题库、操作过程分析、上机考试真题等内容。
本书内容全面、实践操作解析清晰，适合考生使用，也可以作为高校师生的大学计算机基础
课程的实践教材和参考书。

高等学校计算机水平考试（吉林省考区）上机考试已经开展多年，为了更好地帮助考生理解
上机考试要求，适应上机考试题目，顺利地通过考试，编者根据吉林省大学考试办公室下发的《高
等学校计算机水平考试（吉林省考区）》文件精神，对计算机二级考试科目—办公自动化的要
求进行了深入的理解、分析和调研，结合高校大学计算机基础课程大纲、教学案例、上机考试真
题以及上机考试系统编写本书。全书共分为计算机应用基础习题与参考答案、上机考试实践指导、
高等学校计算机水平考试（吉林省考区）办公自动化真题三大部分。其中，上机考试实践指导部
分包含了Word 2010、Excel 2010、PowerPoint 2010 不同类型的难、中、易相结合的案例，指导考
生循序渐进地提高计算机操作水平。
上机考试是对学生计算机应用能力的综合考核，是能较科学地衡量学生计算机知识水平、操
作技能的考试方法，上机考试内容覆盖了大学计算机基础课程大纲的要求。为了帮助学生系统地
学习该门课程，本书汇编了大量的案例考试题目，每个案例均有案例描述、相关知识、操作要求
和操作步骤，案例解析清晰、透彻，操作准确，有助于学生通过上机实践练习来分析考试题目类
型、掌握试题重点和难点、理清解题思路，使学生的实践操作能力在短时间内得到提升，顺利通
过上机考试。
每个案例操作的相关素材可以从中国铁道出版社有限公司网站（ http://www.tdpress.com/
51eds/）的下载区下载。另外，本书涉及的计算机操作系统是Windows 7，办公自动化软件是Word
2010 文字处理软件、Excel 2010 电子表格处理软件、PowerPoint 2010 演示文稿制作软件。
本书第一部分由梁燕编写，第二部分第6 章由孙开岩、孙继刚编写，第二部分第7 章由韩智颖、
王菲菲编写，第二部分第8 章由张丽明编写，第三部分由梁燕、何威编写，附录由梁燕、韩智颖
编写，全书由梁燕、韩智颖统稿，何桥主审。
本书经过多年的应用，得到了广大考生和兄弟院校的认可。为了适应高等学校计算机水平考
试（吉林省考区）的新要求，满足广大考生的需求，编者在第一版的基础上进行了修订与升级，
结合了考试软件的升级与实际应用，对上机考试大纲、习题、案例进行了填充与更新，并新增了
近三年的高等学校计算机水平考试（吉林省考区）办公自动化试题内容。
由于编者水平有限，书中难免有不足之处，欢迎读者对本书提出宝贵意见和建议。
编 者
2019 年6 月

第一部分 计算机应用基础习题与参考答案
第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

梁燕：吉林华桥外国语学院公共教育学院计算机部主任，教授，现兼任吉林省高校计算机共同课教学专业委员会理事，全国大学生计算机办公自动化考试（吉林省考区）试题负责人。参与编写并公开出版教材9部，其中主编教材5部，主编的《办公自动化案例教程》荣获吉林省高校优秀教材一等奖；公开发表论文30余篇；参与省、校级教改项目16项，其中主持省级重点项目3项、校级重点项目4项，荣获吉林省教学成果三等奖；荣获国家、省级、校级各类奖项30余项，被评为我校“师德标兵”、“优秀教师”、“教学创新工作先进个人”、“科研工作先进个人”等。韩智颖：吉林华桥外国语学院计算机教研室主任，副教授，计算机教学与应用，大学计算机基础、办公自动化、平面图形设计。