本书主要介绍了计算机和网络基础知识、Windows7的基本使用方法和使用技巧、Office2010（Word、Excel和PowerPoint）的基本使用方法和使用技巧。本书包括10章，详细介绍了28个案例。采用案例带动知识点学习的方法进行讲解，按节细化知识点，并结合案例介绍了相关的知识点。每个案例均由案例描述、操作步骤及相关知识组成，每章配有思考与练习。案例描述中介绍了学习此案例的目的，包括案例描述和使用的相关知识简介；操作步骤中介绍了案例的制作方法和操作技巧；相关知识中介绍了与此案例有关的知识；思考与练习给出一些题目供读者练习。本书所提供的案例有详细的讲解，易懂、易学。读者可以边进行案例制作，边学习相关知识和技巧。本书适合作为中等职业学校计算机基础课程的教材或参考书，也可作为自学用书。

本书主要介绍了计算机和网络基础知识、Windows 7 的基本使用方法和使用技巧、中文 Office 2010（包括 Word、Excel 和 PowerPoint）的基本使用方法和使用技巧。 本书共 10 章：第 1 章主要介绍计算机的基本工作原理、计算机中常用的数制和编码、微机的 硬件系统和软件系统组成，以及网络的基本概念和常识等；第 2 章～第 4 章主要介绍 Windows  7的 常规操作和基本常识，Windows 7对话框等主要界面要素的特点和操作方法，Windows 7的注销 和关闭操作，Windows 7的文件管理、文件搜索、快捷方式操作，Windows 7的附件、控制面板、 “开始”菜单、注册表的基本操作等；第 5 章～第 7 章主要介绍中文 Word 2010 的基本使用方法和 操作技巧；第 8 章和第 9 章主要介绍中文 Excel 2010 的基本使用方法和操作技巧；第 10 章主要 介绍中文 PowerPoint 2010 的基本使用方法和操作技巧。 根据时代发展变化和职业能力需求提升的要求，本版在前一版基础上对第5章～第 10 章部 分案例进行替换和修改，增加部分案例的操作视频。 本书不涉及高深理论，而是针对计算机综合应用的基本常识和常规技能，从实用角度出发， 系统地介绍了与计算机相关的必备知识和实际操作，知识点丰富，练习内容实用性强，渗透能 力本位职业教育的思想，使读者可以用较短的时间获得实用的计算机知识。 本书采用案例带动知识点学习的方法进行讲解，读者可以通过学习 28 个案例的制作方法， 掌握中文 Windows 7 和中文 Office 2010 软件的操作方法和操作技巧。本书按节细化知识点，并 结合实例介绍相关的知识点。每个案例均由案例描述、操作步骤、相关知识和思考与练习 4 部 分组成。案例描述中介绍了学习此案例的目的，包括案例描述和使用的相关知识；操作步骤中 介绍了案例的制作方法和操作技巧；相关知识中介绍了与此案例有关的知识；思考与练习给出 了一些题目供读者练习。 本书由曾昊、沈大林任主编，朱顺、王爱赪、朱立、姜萍任副主编。参加本书编写工作的 主要人员有张伦、郑淑晖、沈昕、肖柠朴、郑瑜、王浩轩、 玥崔、万忠、郝侠、丰金兰、郑鹤、 闫怀兵、李维宁、郭海、王小兵、徐晓雅、苏飞等。 由于编者水平有限，书中难免存在疏漏和不足之处，敬请广大读者批评指正。
编 者 2018 年 6 月

第 1 章 计算机和网络基础知识 ············ 1 1.1 计算机基本原理和分类 ················ 1 1.1.1 计算机基本原理 ····················· 1 1.1.2 计算机的分类和主要 性能指标 ································· 2 1.2 微型计算机系统 ··························· 4 1.2.1 微型计算机的硬件系统 ········· 4 1.2.2 微型计算机的软件系统 ······· 10 1.3 数制与编码 ································· 12 1.3.1 计算机中常用的数制 ··········· 12 1.3.2 数据的编码 ··························· 12 1.4 网络基础知识 ····························· 14 1.4.1 网络基本概念 ······················· 14 1.4.2 网络设备 ······························ 15 1.4.3 互联网 ·································· 17 思考与练习 ·········································· 20 第 2 章 Windows 7 基本操作 和文件管理 ······························· 23 2.1 【案例 1】了解 Windows 7 界面和窗口 ································· 23
● 了解 Windows 7 ······················· 29 ● 鼠标的基本操作 ······················· 30 ● 键盘的基本操作 ······················· 30 ● 关机和注销 ······························ 31 思考与练习 2-1 ··································· 32 2.2 【案例 2】个性化桌面 ················ 32
● 菜单的种类 ······························ 39 ● 菜单命令形式和约定 ··············· 39 ● 键盘操作菜单的方法 ··············· 40 思考与练习 2-2 ··································· 41 2.3 【案例 3】创建和编辑路径结构 ····· 41
● 文件命名规则 ·························· 45 ● 文件夹的树形结构 ·················· 45 ● 文件的创建与命名 ·················· 45 ● 选中文件和文件夹 ·················· 46 ● 复制、移动和删除文件与 文件夹 ······································ 47 思考与练习 2-3 ··································· 48 2.4 【案例 4】搜索符合条件的文档 ····· 48
● 搜索的日期范围 ······················ 49 ● 搜索的种类 ····························· 50 ● 查看文件的属性 ······················ 50 思考与练习 2-4 ··································· 51 2.5 【案例 5】创建快捷方式 和小工具 ····································· 51
● 创建和删除快捷方式 ·············· 54 ● 设置文件的打开方式 ·············· 54 思考与练习 2-5 ··································· 55 第 3 章 Windows 7 附件应用程序 ····· 56 3.1 【案例 6】计算器的复杂计算 ····· 56
● 计算器特殊按钮的作用 ·········· 58 ● 特殊计算 ································· 58 思考与练习 3-1 ··································· 60 3.2 【案例 7】绘制“小火车” 图像 ·············································· 60
●“颜色”组功能 ······················· 64 ●“形状”和“粗细”组功能 ··· 64 ●“工具”和“刷子”组功能 ··· 65 ● 输入文本 ································ 65
CONTENTS 目 录
相关知识
相关知识
相关知识
相关知识
相关知识
相关知识
相关知识
2 计算机应用基础（第三版）
思考与练习 3-2 ··································· 66 3.3 【案例 8】北京故宫博物院 宣传单 ········································· 66
● 在“写字板”软件中插入表格 ··· 70 ● 录音机的使用 ·························· 71 思考与练习 3-3 ··································· 71 第 4 章 Windows 7 控制面板 ·············· 72 4.1 【案例 9】自定义格式与区域 和语言设置 ································· 72
● 窗口颜色设置 ·························· 75 ● 屏幕保护设置 ·························· 76 ● 显示器设置 ······························ 77 ● 屏幕放大镜的使用 ··················· 79 思考与练习 4-1 ··································· 80 4.2 【案例 10】系统体验和属性 设置 ············································ 81
● 文件夹选项的设置 ··················· 86 ● Windows 7 测试工具 ·············· 87 思考与练习 4-2 ··································· 90 4.3 【案例 11】系统保护和程序 卸载 ············································ 90
● 系统备份和还原设置 ··············· 93 ● 电源管理 ·································· 95 思考与练习 4-3 ··································· 97 第 5 章 Word 2010 文字和表格 编辑 ············································ 98 5.1 【案例 12】八一建军节和十一 国庆节 ········································· 98
● 光标定位 ································ 104 ● 选中文本 ································ 104 ● 复制和移动文本 ····················· 105 ● 撤销与恢复 ···························· 106 ● 设置字体 ································ 106 ● 打开文档 ································ 107
思考与练习 5-1 ································· 108 5.2 【案例 13】每日一菜 ················ 108
● 添加边框和底纹 ·····················113 ● 添加项目符号和编号 ·············113 ● 复制格式 ································115 ● 段落编辑 ································116 ● 查找与替换 ····························117 ● 特殊符号的简单输入 ·············119 思考与练习 5-2 ································· 120 5.3 【案例 14】职工档案表 ············ 121
● 光标定位和选中表格 ·············126 ● 插入行、列和单元格 ·············127 ● 删除表格、行、列和 单元格 ····································127 ● 拆分单元格 ····························128 ● 改变文字方向和重复表格 标题 ·········································128 ● 套用内置表格样式 ·················129 ●“表格属性”对话框 ··············129 思考与练习 5-3 ································· 130 第 6 章 Word 2010 文档美化 ············ 131 6.1 【案例 15】菊花—色艳 群芳 ·········································· 131
● 图片和剪贴画的调整 ·············137 ● 图片和剪贴画的排列调整 ·····139 ● 图片和剪贴画的大小调整 ·····142 ● 艺术字格式设置 ·····················142 ● 创建和编辑文本框 ·················144 ● 给文本框添加对象 ·················145 思考与练习 6-1 ································· 146 6.2 【案例 16】企业组织图 ············ 146
● 插入和编辑 SmartArt 图形 ····149 ● SmartArt 图形的布局、 样式、颜色 ····························151 思考与练习 6-2 ································· 152
相关知识
相关知识
相关知识
相关知识
相关知识
相关知识
相关知识
相关知识
相关知识

3 目 录
第 7 章 Word 2010 高级操作 ············ 154 7.1 【案例 17】编辑长文档 ············ 154
● 样式 ········································ 159 ● 大纲视图 ································ 163 ●“导航”任务窗格 ·················· 164 思考与练习 7-1 ································· 165 7.2 【案例 18】整理长文档 ············ 166
● 创建页眉和页脚 ····················· 169 ● 编辑页眉和页脚 ····················· 170 ● 插入页码 ································ 170 思考与练习 7-2 ································· 171 7.3 【案例 19】审批长文档 ············ 171
● 选择浏览对象定位 ················· 175 ● 脚注和尾注 ···························· 176 ● 行号 ········································ 177 ● 自动浏览 ································ 177 思考与练习 7-3 ································· 178 7.4 【案例 20】数学试题 ················ 178
●“结构”和“符号”组 ·········· 181 ●“工具”组 ····························· 181 ● 其他公式 ································ 181 思考与练习 7-4 ································· 182 第 8 章 Excel 2010 基本操作 ··········· 183 8.1 【案例 21】建立一个学生 档案 ·········································· 183
● 单元格内输入数据 ················· 189 ● 输入序列 ································ 190 ● 插入与删除单元格、 行和列 ···································· 192 ● 修改和删除单元格中的 数据 ········································ 193 ● 移动和复制数据 ····················· 194 思考与练习 8-1 ································· 195
8.2 【案例 22】修饰“肖柠朴” 工作表 ······································· 196
● 设置数据的格式 ·····················200 ● 设置默认字体和大小以及自动 套用格式 ·································201 ● 条件格式化工作表 ·················202 ● 设置单元格的边框和填充 ·····203 ● 插入对象 ································204 思考与练习 8-2 ································· 204 8.3 【案例 23】学生档案集 ············ 205
● 在工作表间切换 ·····················208 ● 改变工作表的默认个数 ·········208 ● 插入工作表 ····························209 ● 复制工作表 ····························209 ● 向多个工作表中同时输入 数据 ·········································210 思考与练习 8-3 ································· 210 第 9 章 Excel 2010 的计算、分类和 图表功能 ··································· 211 9.1 【案例 24】学生各学期成绩 统计表 ········································ 211
● 给单元格命名 ·························213 ● 输入公式 ································214 ● 隐藏公式 ································215 ● 保护工作表 ····························215 ● 取消隐藏公式 ·························216 ● 其他命名和命名操作 ·············216 ● 单元格的引用 ·························217 ● 内置函数 ································219 ● 常用函数 ································220 ● 自动求和 ································221 思考与练习 9-1 ································· 222 9.2 【案例 25】产品销售数量排序 和统计分析图 ··························· 223
相关知识
相关知识
相关知识
相关知识
相关知识
相关知识
相关知识
相关知识
4 计算机应用基础（第三版）
● 建立数据清单 ························ 225 ● 数据清单的编辑 ····················· 227 ● 简单排序和多列排序 ············· 227 ● 更改和删除图表中的数据 ····· 229 ● 移动、调整图表和改变图表 类型 ········································ 229 ● 设置图表中垂直轴的格式 ····· 230 ● 设置图表中水平轴的格式 ····· 231 ● 设置图表区格式和绘图区 格式 ········································ 232 思考与练习 9-2 ································· 232 9.3 【案例 26】学生成绩分类汇总 和数据透视表 ··························· 233
● 分类汇总的嵌套 ····················· 239 ● 数据透视表 ···························· 240 ● 更新数据透视表中的数据 ····· 241 ● 数据透视图 ···························· 242
思考与练习 9-3 ································· 243 第 10 章 PowerPoint 2010 幻灯片 制作 ········································ 244 10.1 【案例 27】制作“八大行星” 首张幻灯片 ····························· 244
● 创建新演示文稿 ·····················250 ● 输入和编辑文本 ·····················252 ● 母版和母版编辑 ·····················254 ● 设计主题 ································254 思考与练习 10-1 ······························· 256 10.2 【案例 28】制作“八大行星” 其他张幻灯片 ························· 256
● 编辑幻灯片 ····························262 ● 插入 Flash 动画图标 ··············263 ● 插入编号、日期和时间与页眉和 页脚 ·········································263 思考与练习 10-2 ······························· 264
相

0