本书为“大学计算机基础”公共课程的配套实训教材。全书分为三部分，内容涵盖了新修订的全国计算机等级考试（一级）考试大纲的内容。第一部分为“计算机基础实训”，包括计算机启动及指法练习、Windows 7操作实训、Word 2010操作实训、Excel 2010操作实训、PowerPoint 2010操作实训、网络基础与Internet应用操作实训、多媒体基础操作、常用工具软件操作；第二部分为计算机基础习题及参考答案；第三部分为计算机上机模拟试题。



        本书提供了大量的实例，可操作性强，对提高学生的计算机操作水平大有帮助，适合作为各类高等院校非计算机专业计算机基础课程的配套用书，也可以作为全国计算机等级考试一、二级的复习用书，以及各类计算机培训班的辅导教材或初学者的自学用书。

无

目 录

CONTENTS

第一部分计算机基础实训实训1 计算机启动及指法练习..................................................................................3 

实训　计算机启动、指法练习及汉字输入法..............................................................3

实训2 Windows 7 操作实训.................................................................................... 11

实训2–1 　Windows 7 基本操作....................................................................................11

实训2–2 　Windows 7 文件管理....................................................................................19

实训2–3 　Windows 7 实用工具....................................................................................24

实训2–4 　Windows 7 综合应用....................................................................................27

实训3 Word 2010 操作实训....................................................................................29

实训3–1 　Word 2010 基本操作....................................................................................29

实训3–2 　图形和图文混排..........................................................................................33

实训3–3 　表格操作......................................................................................................38

实训3–4 　Word 2010 综合应用....................................................................................46

实训4 Excel 2010 操作实训....................................................................................54

实训4–1 　Excel 2010 基本操作....................................................................................54

实训4–2 　图表制作......................................................................................................59

实训4–3 　数据统计与管理..........................................................................................63

实训4–4 　Excel 2010 综合应用....................................................................................71

实训5 PowerPoint 2010 操作实训..........................................................................81

实训5–1 　PowerPoint 2010 基本操作..........................................................................81

实训5–2 　演示文稿的放映..........................................................................................88

实训5–3 　演示文稿综合应用......................................................................................92

实训6 网络基础与Internet 应用操作实训................................................................95

实训6–1 　IE 浏览器的使用和信息检索......................................................................95

目 录

CONTENTS

实训6–2 　电子邮件的收发..........................................................................................99

实训6–3 　远程登录与文件传输操作........................................................................103

实训7 多媒体基础操作.........................................................................................106

实训7–1 　图片的获取与处理....................................................................................106

实训7–2 　音频素材的获取与处理............................................................................108

实训7–3 　视频素材的获取与处理............................................................................110

实训8 常用工具软件操作..................................................................................... 115

实训8–1 　360 安全卫士的使用..................................................................................115

实训8–2 　WinRAR 的使用.........................................................................................117

实训8–3 　ACDSee 的使用..........................................................................................119

实训8–4 　暴风影音的使用........................................................................................120

实训8–5 　光盘刻录软件Nero 的使用........................................................................122

实训8–6 　下载工具迅雷的使用................................................................................123

实训8–7 　Adobe Acrobat Professional 软件的使用...................................................124

第二部分计算机基础习题及参考答案习题1 计算机系统概述习题.................................................................................129

习题2 操作系统习题............................................................................................13

5习题3 Word 2010 习题.........................................................................................140

习题4 Excel 2010 习题.........................................................................................145

习题5 PowerPoint 2010 习题...............................................................................149

习题6 数据库技术基础习题.................................................................................153

习题7 网络基础与Internet 应用习题.....................................................................157

习题8 多媒体技术基础习题.................................................................................162

目 录

CONTENTS

习题9 算法与程序设计基础习题..........................................................................166

习题10 信息安全习题..........................................................................................169

习题11 常用工具软件习题...................................................................................172

计算机基础习题参考答案.......................................................................................174

习题1 计算机系统概述............................................................................................174

习题2 操作系统........................................................................................................174

习题3 Word 2010......................................................................................................175

习题4 Excel 2010......................................................................................................175

习题5　PowerPoint 2010............................................................................................176

习题6　数据库技术基础............................................................................................176

习题7　网络基础与Internet 应用...............................................................................177

习题8　多媒体技术基础............................................................................................177

习题9　算法与程序设计基础....................................................................................178

习题10 　信息安全......................................................................................................178

习题11 　常用工具软件..............................................................................................178

第三部分计算机基础上机模拟试题上机模拟试题（一）..............................................................................................183 

上机模拟试题（二）..............................................................................................185 

附录一　全国计算机等级考试一级MS Of.ce 考试大纲..........................................187

附录二　全国计算机等级考试二级MS Of.ce 高级应用考试大纲............................190

附录三　全国计算机等级考试一级MS Of.ce 模拟试题..........................................192

附录四　全国计算机等级考试二级MS Of.ce 高级应用模拟试题............................196