本书是《大学计算机基础》的配套实验教材，主要内容包括：Windows 10 操作系统、文字处理软件、电子表格处理软件、演示文稿制作软件、算法与程序设计、计算机网络与 Internet 等。 本书结合大学计算机基础课程的基本教学要求，参考了全国计算机等级考试二级 MS Office 考试大纲要求，是为提高读者的实际操作应用能力而编写的实验教材。实验内容在主教材的基础上做了进一步扩展，实验步骤详细，读者可自行上机操作。

近年来，各高校都在进行顺应时代发展要求的教育教学创新改革，大学计算机基础教育在课程体系、教学内容、教学理念和教学方法上都较以往有了较大的变化，我们在编写《大学计算机基础》教材之后，又组织经验丰富的老师编写了这本配套的实验教材，为学生提供实验指导和习题集。 本书基于“学用结合”的原则编写，主要有以下特色。 （1）配合主教材使用，全面提升学习效果。 本书根据主教材的内容，分章列出每章的实验指导，以便于学生在实验时使用。同时，本书结合全国计算机等级考试一级、二级 MS Office 考试大纲的要求，把相关知识点在实验内容中体现出来，学生不仅可以提升实践能力，还可以提升综合应用能力。 （2）科学有效的实验指导，让学生事半功倍。 本书的实验指导采用“实验目的+实验内容+实验步骤”的结构进行讲解。“实验步骤”给出了实验的关键步骤和操作提示，可以引导学生自行上机操作。 （3）精选习题，巩固基础理论知识。 本书在习题部分精选单选题，主要考查学生对主教材基础理论知识的掌握程度，使学生在巩固所学基础知识的同时查漏补缺。 本书由徐群叁、刘玮等编写。张淑宁、赵永升负责本书的统稿和组织工作，徐群叁、巩艳华编写第 1、2 章，徐效美、陈天编写第 3、5 章，李勃、王洪波编写第 4 章，刘玮、吴璇编写第 6 章。 由于本书的知识面较广，要将众多的知识点贯穿起来难度不小，不足之处在所难免。为便于本书以后的修订，恳请读者多提宝贵意见。关于本书的相关问题，请联系luy@phei.com.cn。

第 1 章 Windows 操作系统············································································1 1.1 实验 1—Windows 桌面操作 ·····························································1 1.2 实验 2—Windows 窗口操作和设置 ·················································.12 1.3 实验 3—Windows 文件操作 ··························································.20 1.4 实验 4—Windows 设置 ································································.28 习题 ·································································································.35 第 2 章 文字处理软件 ···············································································.38 2.1 实验 1—文档编辑 ······································································.38 2.2 实验 2—文档排版 ······································································.46 2.3 实验 3—表格制作 ······································································.54 2.4 实验 4—图文混排 ······································································.58 2.5 实验 5—邮件合并 ······································································.64 2.6 实验 6—引用 ············································································.72 2.7 实验 7—页面布局 ······································································.76 习题 ·································································································.81 第 3 章 电子表格处理软件 ·········································································.85 3.1 实验 1—Excel 基本操作·······························································.85 3.2 实验 2—公式和函数的使用 ··························································.94 3.3 实验 3—工作表格式化设置 ··························································101 3.4 实验 4—Excel 的图表操作····························································108 3.5 实验 5—Excel 的数据管理操作······················································115 习题 ·································································································121 第 4 章 演示文稿制作软件 ·········································································128 4.1 实验 1—演示文稿的创建与幻灯片管理 ···········································128 4.2 实验 2—幻灯片的编辑与修饰 ·······················································135 4.3 实验 3—幻灯片动画设计与幻灯片切换 ···········································142 4.4 实验 4—演示文稿的放映与输出 ····················································149 习题 ·································································································153 第 5 章 算法与程序设计 ············································································155 5.1 实验 1—配置 Python 开发环境 ······················································155 5.2 实验 2—Python 程序简单应用·······················································160 5.3 实验 3—Python 程序综合应用·······················································163 习题 ·································································································167 第 6 章 计算机网络与 Internet ····································································171 6.1 实验 1—组建局域网和接入 Internet ················································171 6.2 实验 2—发送和接收邮件 ·····························································179 6.3 实验 3—Internet 信息检索 ····························································184 习题 ·································································································191 参考文献··································································································195