本书是根据教育部考试中心制定的《全国计算机等级考试二级MS Office 高级应用考试大纲》（2018年版）中对MS Office 高级应用的要求编写的，主要内容包括计算机应用基础、利用Word 2010 编排文档、利用Excel 2010 创建与处理电子表格、利用PowerPoint 2010 制作演示文稿，涵盖了Office 等级考试（Windows）的核心内容。本书注重Office 基础知识的系统性，更强调实用性和应用性。本书既有丰富的理论知识，又有大量难易适中、涉及广泛的实例，突出应用、强化技能。全书内容丰富、层次清晰、案例翔实、实用性强。本书可以作为各类高等院校非计算机专业计算机基础课程的教学用书，也可以作为计算机一级、二级等级考试的复习用书，以及计算机培训机构Office 高级应用的教学用书和计算机爱好者的自学用书。

前 言 随着信息技术的迅速发展，各行各业的信息化进程不断加速前进，Office 办公软件得到了迅速普及和广泛应用，各行各业几乎都离不开Office 办公软件的使用，因此Office 办公软件的学习变得越来越重要。为读者提供一本既有理论基础，又注重操作技能的Office实用教程显得尤为必要。 本书是根据教育部考试中心制定的《全国计算机等级考试二级MS Office 高级应用考试大纲》（2018 年版）中对MS Office 高级应用的要求编写的，本书不仅注重Office 办公软件基础知识的系统性，而且更强调实用性和应用性。在掌握Office 办公软件基本应用的基础上，对Word、Excel、PowerPoint 3 个组件的高级功能，以及各组件之间的共享进行了详细的解析，旨在提高读者办公综合应用的能力和处理复杂事务的能力，真正达到学以致用。 本书包括四大部分：计算机应用基础、利用Word 2010 编排文档、利用Excel 2010 创建与处理电子表格、利用PowerPoint 2010 制作演示文稿。每章包括多个实例，Word、Excel、PowerPoint 3 个组件的知识点分布在各个实例中，每个实例均以“操作步骤+知识讲解+图形演示+效果图展示”的方式进行浅显易懂的讲解。同时，本书还配有上机操作的习题、上机操作最终效果图，方便读者对知识点的掌握和使用，切实提高读者的上机操作能力。 本书主要有以下4 个特色。 （1）内容重点突出。按照全国计算机等级考试的要求由浅入深地安排章节次序，注重理论知识和实践操作的紧密结合，书中知识点涵盖了Office 等级考试（Windows）的核心内容。 （2）实例新颖独特。本书突出应用、强化技能，既有丰富的理论知识，又有大量难易适中、涉及广泛的实例，分布在Offie 的各知识点中，达到理论和实践融会贯通的目的。 （3）图文并茂。操作部分配有文字讲解和操作实例图，形象生动，清晰明了，使读者一学就会，即学即用。 （4）配套微课视频讲解。本书提供111 个同步微课视频，讲解重要知识点，手机扫码即可观看，方便、快捷、学习更高效。 本书由唐永华、陈奋编写。第1 篇、第3 篇、附录A、附录B 由唐永华编写，第2 篇、第4 篇由陈奋编写。由于编著者水平有限，书中难免存在疏漏与不足之处，恳请读者批评指正。 编著者

第1 篇 计算机应用基础 第1 章 计算机基础知识 ·················································································.2 1.1 计算机的发展 ···················································································.2 1.1.1 计算机的诞生 ··········································································.2 1.1.2 计算机的发展历程及未来发展趋势 ···············································.3 1.1.3 计算机发展的新热点 ·································································.6 1.2 计算机系统的组成与工作原理 ····························································.12 1.2.1 计算机系统的组成 ··································································.12 1.2.2 微型计算机的硬件系统 ····························································.12 1.2.3 微型计算机的软件系统 ····························································.23 1.2.4 计算机的工作原理 ··································································.24 1.3 计算机中信息的表示与存储 ·······························································.26 1.3.1 信息表示的形式 ·····································································.26 1.3.2 数值型数据编码 ·····································································.29 1.3.3 非数值型数据编码 ··································································.33 1.4 计算机病毒与防治 ···········································································.36 1.4.1 计算机病毒 ···········································································.36 1.4.2 计算机病毒的预防与清除 ·························································.38 1.5 计算机网络基础与应用 ·····································································.39 1.5.1 计算机网络基础 ·····································································.39 1.5.2 Internet 基础 ··········································································.43 1.5.3 Internet 应用 ··········································································.46 习题一 ·································································································.51 第2 篇 利用Word 2010 编排文档 第2 章 创建和编辑文档 ···············································································.54 2.1 创建文档 ·······················································································.54 2.1.1 Word 2010 的窗口组成 ·····························································.54 2.1.2 创建空白文档 ········································································.56 2.1.3 利用模板创建文档 ··································································.57 2.2 Word 2010 的基本操作 ······································································.58 2.2.1 输入文本 ··············································································.58 2.2.2 编辑文本 ··············································································.60 2.2.3 查找和替换 ···········································································.62 2.2.4 保存和打印文档 ·····································································.65 第3 章 Word 文档排版 ················································································.71 3.1 设置文档的格式 ··············································································.71 3.1.1 设置字符格式 ········································································.71 3.1.2 设置段落格式 ········································································.74 3.1.3 设置边框和底纹 ·····································································.76 3.1.4 分栏和首字下沉 ·····································································.79 3.1.5 页面设置 ··············································································.80 3.1.6 设置文档背景 ········································································.81 3.1.7 实例练习 ··············································································.84 3.2 文档的图文混排 ··············································································.86 3.2.1 插入图片 ··············································································.86 3.2.2 插入图形 ··············································································.90 3.2.3 插入SmartArt 图形 ·································································.93 3.2.4 插入文本框 ···········································································.94 3.2.5 插入艺术字 ···········································································.95 3.2.6 插入公式 ··············································································.96 3.2.7 实例练习 ··············································································.97 3.3 在文档中编辑表格 ··········································································.107 3.3.1 创建表格 ·············································································.107 3.3.2 编辑表格 ·············································································.109 3.3.3 表格格式化 ··········································································.112 3.3.4 表格与文本的相互转换 ···························································.113 3.3.5 表格数据转化成图表 ······························································.115 3.3.6 表格的排序和计算 ·································································.116 3.3.7 实例练习 ·············································································.119 第4 章 长文档的编辑 ·················································································.121 4.1 创建和使用样式 ·············································································.121 4.1.1 在文档中应用样式 ·································································.121 4.1.2 创建新样式 ··········································································.122 4.1.3 修改样式 ·············································································.123 4.2 插入项目符号和编号 ·······································································.124 4.2.1 插入项目符号 ·······································································.124 4.2.2 插入编号 ·············································································.124 4.3 设置页眉和页脚 ·············································································.125 4.3.1 插入分页和分节 ····································································.125 4.3.2 插入页码 ·············································································.127 4.3.3 插入页眉和页脚 ····································································.127 4.3.4 删除页眉和页脚 ····································································.129 4.4 在文档中添加引用的内容 ·································································.129 4.4.1 插入脚注和尾注 ····································································.129 4.4.2 插入题注 ·············································································.130 4.4.3 插入交叉引用 ·······································································.131 4.5 创建文档目录 ················································································.132 4.5.1 自动生成目录 ·······································································.132 4.5.2 更新目录 ·············································································.136 4.6 审阅和修订文档 ·············································································.137 4.6.1 拼写和语法检查 ····································································.137 4.6.2 使用批注 ·············································································.138 4.6.3 修订内容 ·············································································.138 4.7 邮件合并 ······················································································.140 习题二 ································································································.145 第3 篇 利用Excel 2010 创建与处理电子表格 第5 章 Excel 2010 创建电子表格 ·································································.148 5.1 输入和编辑数据 ·············································································.148 5.1.1 Excel 2010 窗口 ····································································.148 5.1.2 Excel 2010 的基本概念 ···························································.149 5.1.3 输入数据 ·············································································.150 5.1.4 编辑数据 ·············································································.154 5.2 表格的格式化 ················································································.155 5.2.1 行列操作 ·············································································.155 5.2.2 设置单元格格式 ····································································.156 5.2.3 自动套用格式 ·······································································.160 5.2.4 条件格式设置 ·······································································.161 5.2.5 实例练习 ·············································································.163 5.3 工作表的打印输出 ··········································································.165 5.3.1 页面设置 ·············································································.165 5.3.2 设置打印区域 ·······································································.166 5.3.3 打印预览和打印文档 ······························································.168 5.4 编辑工作簿和工作表 ·······································································.169 5.4.1 工作簿的基本操作 ·································································.169 5.4.2 工作表的基本操作 ·································································.171 5.4.3 对多个工作表同时进行操作 ·····················································.174 5.4.4 工作表窗口的操作 ·································································.176 第6 章 公式和函数 ····················································································.180 6.1 公式的使用 ···················································································.180 6.1.1 公式的组成 ··········································································.180 6.1.2 公式中的运算符 ····································································.180 6.1.3 公式的输入与编辑 ·································································.181 6.1.4 单元格引用 ··········································································.182 6.1.5 更正公式中的错误 ·································································.183 6.1.6 实例练习 ·············································································.184 6.2 函数的使用 ···················································································.185 6.2.1 函数的组成 ··········································································.186 6.2.2 函数的输入 ··········································································.186 6.2.3 常用函数的应用 ····································································.188 6.2.4 实例练习 ·············································································.190 第7 章 图表在数据分析中的应用 ··································································.193 7.1 迷你图 ·························································································.193 7.2 图表 ····························································································.194 7.2.1 创建图表 ·············································································.194 7.2.2 编辑图表 ·············································································.195 7.2.3 格式化图表 ··········································································.198 7.2.4 实例练习 ·············································································.199 第8 章 Excel 2010 数据处理与分析 ······························································.202 8.1 数据排序 ······················································································.202 8.1.1 单列数据排序 ·······································································.202 8.1.2 多列数据同时排序 ·································································.203 8.1.3 自定义序列排序 ····································································.204 8.2 数据筛选 ······················································································.206 8.2.1 自动筛选 ·············································································.206 8.2.2 多列筛选 ·············································································.208 8.2.3 高级筛选 ·············································································.210 8.3 数据分类汇总 ················································································.211 8.3.1 创建分类汇总 ·······································································.211 8.3.2 分级显示 ·············································································.213 8.3.3 删除分类汇总 ·······································································.216 8.4 数据透视表和数据透视图 ·································································.216 8.4.1 创建数据透视表 ····································································.216 8.4.2 编辑数据透视表 ····································································.219 8.4.3 格式化数据透视表 ·································································.221 8.4.4 创建数据透视图 ····································································.222 8.4.5 删除数据透视表或数据透视图 ··················································.223 8.4.6 实例练习 ·············································································.223 习题三 ································································································.226 第4 篇 利用PowerPoint 2010 制作演示文稿 第9 章 创建和编辑演示文稿 ········································································.230 9.1 创建演示文稿的方法 ·······································································.230 9.1.1 新建空白演示文稿 ·································································.230 9.1.2 利用模板创建演示文稿 ···························································.231 9.1.3 利用主题创建演示文稿 ···························································.232 9.1.4 PowerPoint 2010 的视图分类 ····················································.232 9.2 幻灯片的基本操作 ··········································································.233 9.2.1 插入和删除幻灯片 ·································································.233 9.2.2 复制或移动幻灯片 ·································································.234 9.2.3 重用幻灯片 ··········································································.235 9.2.4 幻灯片节的设置 ····································································.236 9.2.5 幻灯片编号的添加 ·································································.237 9.2.6 幻灯片日期和时间的添加 ························································.237 9.3 在幻灯片中添加内容 ·······································································.238 9.3.1 添加文本 ·············································································.238 9.3.2 添加艺术字 ··········································································.239 9.3.3 添加图形对象 ·······································································.239 9.3.4 添加音频和视频 ····································································.243 9.4 修饰演示文稿 ················································································.244 9.4.1 利用主题修饰演示文稿 ···························································.244 9.4.2 利用配色方案修饰演示文稿 ·····················································.245 9.4.3 利用背景修饰演示文稿 ···························································.246 9.4.4 利用母版修饰演示文稿 ···························································.247 9.5 设置演示文稿的播放效果 ·································································.249 9.5.1 幻灯片对象的动画效果 ···························································.249 9.5.2 幻灯片切换效果 ····································································.252 9.5.3 超链接 ················································································.253 9.5.4 放映方式的设置 ····································································.254 第10 章 演示文稿的打印和发布 ···································································.259 10.1 演示文稿的打印 ············································································.259 10.1.1 打印幻灯片 ········································································.259 10.1.2 将演示文稿发送至Word 进行打印 ···········································.260 10.2 演示文稿的发布 ············································································.261 10.2.1 发布为视频文件 ··································································.261 10.2.2 发布为PDF 文件 ·································································.262 10.2.3 打包为CD 数据包 ·······························································.263 习题四 ································································································.264 附录A 全国计算机等级考试二级MS Office 试题 ··············································.265 附录B 全国计算机等级考试二级MS Office 试题答案 ·······································.268 参考文献 ···································································································.274

http://www.hxedu.com.cn/hxedu/fg/book/bookinfo.html?code=G0383620