第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