第1 篇 計算機應用基礎
第1 章 計算機基礎知識 ·················································································.2
1.1 計算機的發(fā)展 ···················································································.2
1.1.1 計算機的誕生 ··········································································.2
1.1.2 計算機的發(fā)展歷程及未來發(fā)展趨勢 ···············································.3
1.1.3 計算機發(fā)展的新熱點 ·································································.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 章 創(chuàng)建和編輯文檔 ···············································································.54
2.1 創(chuàng)建文檔 ·······················································································.54
2.1.1 Word 2010 的窗口組成 ·····························································.54
2.1.2 創(chuàng)建空白文檔 ········································································.56
2.1.3 利用模板創(chuàng)建文檔 ··································································.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 創(chuàng)建表格 ·············································································.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 創(chuàng)建和使用樣式 ·············································································.121
4.1.1 在文檔中應用樣式 ·································································.121
4.1.2 創(chuàng)建新樣式 ··········································································.122
4.1.3 修改樣式 ·············································································.123
4.2 插入項目符號和編號 ·······································································.124
4.2.1 插入項目符號 ·······································································.124
4.2.2 插入編號 ·············································································.124
4.3 設置頁眉和頁腳 ·············································································.125
4.3.1 插入分頁和分節(jié) ····································································.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 創(chuàng)建文檔目錄 ················································································.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 創(chuàng)建與處理電子表格
第5 章 Excel 2010 創(chuàng)建電子表格 ·································································.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 設置打印區(qū)域 ·······································································.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 創(chuàng)建圖表 ·············································································.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 創(chuàng)建分類匯總 ·······································································.211
8.3.2 分級顯示 ·············································································.213
8.3.3 刪除分類匯總 ·······································································.216
8.4 數據透視表和數據透視圖 ·································································.216
8.4.1 創(chuàng)建數據透視表 ····································································.216
8.4.2 編輯數據透視表 ····································································.219
8.4.3 格式化數據透視表 ·································································.221
8.4.4 創(chuàng)建數據透視圖 ····································································.222
8.4.5 刪除數據透視表或數據透視圖 ··················································.223
8.4.6 實例練習 ·············································································.223
習題三 ································································································.226
第4 篇 利用PowerPoint 2010 制作演示文稿
第9 章 創(chuàng)建和編輯演示文稿 ········································································.230
9.1 創(chuàng)建演示文稿的方法 ·······································································.230
9.1.1 新建空白演示文稿 ·································································.230
9.1.2 利用模板創(chuàng)建演示文稿 ···························································.231
9.1.3 利用主題創(chuàng)建演示文稿 ···························································.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 幻燈片節(jié)的設置 ····································································.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 章 演示文稿的打印和發(fā)布 ···································································.259
10.1 演示文稿的打印 ············································································.259
10.1.1 打印幻燈片 ········································································.259
10.1.2 將演示文稿發(fā)送至Word 進行打印 ···········································.260
10.2 演示文稿的發(fā)布 ············································································.261
10.2.1 發(fā)布為視頻文件 ··································································.261
10.2.2 發(fā)布為PDF 文件 ·································································.262
10.2.3 打包為CD 數據包 ·······························································.263
習題四 ································································································.264
附錄A 全國計算機等級考試二級MS Office 試題 ··············································.265
附錄B 全國計算機等級考試二級MS Office 試題答案 ·······································.268
參考文獻 ···································································································.274