第一篇 初識(shí)WPS Office
第1 章 體驗(yàn)全新的WPS Office ······································································.2
1.1 WPS Office 一站式辦公——WPS 首頁(yè) ····················································.2
1.2 在WPS 中新建、訪問(wèn)和管理文檔 ·························································.7
1.2.1 新建文檔 ················································································.7
1.2.2 訪問(wèn)文檔 ················································································.8
1.2.3 管理文檔 ··············································································.14
1.3 WPS 的文檔標(biāo)簽和工作窗口 ······························································.16
1.3.1 文檔標(biāo)簽 ··············································································.16
1.3.2 標(biāo)簽和獨(dú)立窗口的切換 ····························································.19
1.3.3 利用窗口管理標(biāo)簽 ··································································.19
1.4 WPS 云辦公云服務(wù) ··········································································.21
1.4.1 WPS 云空間 ··········································································.22
1.4.2 云同步 ·················································································.23
1.4.3 WPS 網(wǎng)盤(pán) ·············································································.26
1.4.4 歷史版本管理與恢復(fù) ·······························································.27
1.4.5 云回收站 ··············································································.28
1.5 云共享與協(xié)作 ·················································································.29
1.5.1 與他人分享文檔 ·····································································.29
1.5.2 利用團(tuán)隊(duì)管理與組織文檔 ·························································.30
1.5.3 多人同時(shí)編輯 ········································································.32
第二篇 利用WPS 創(chuàng)建電子文檔
第2 章 創(chuàng)建與編輯文檔 ···············································································.38
2.1 創(chuàng)建文檔 ·······················································································.38
2.1.1 創(chuàng)建空白文檔 ········································································.38
2.1.2 利用模板創(chuàng)建文檔 ··································································.39
2.2 輸入與編輯文本 ··············································································.41
2.2.1 輸入文本 ··············································································.41
2.2.2 輸入特殊符號(hào) ········································································.42
2.2.3 輸入公式 ··············································································.44
2.2.4 輸入日期和時(shí)間 ·····································································.45
2.2.5 文本的簡(jiǎn)單編輯 ·····································································.46
2.3 查找和替換文本 ··············································································.48
2.3.1 查找文本 ··············································································.48
2.3.2 替換文本 ··············································································.49
2.3.3 定位文本 ··············································································.52
2.4 保存與打印文檔 ··············································································.52
2.4.1 保存文檔 ··············································································.52
2.4.2 打印文檔 ··············································································.54
2.5 實(shí)用操作技巧 ·················································································.56
2.5.1 更改換行符刪除空行 ·······························································.56
2.5.2 刪除空白頁(yè) ···········································································.57
2.5.3 刪除空格 ··············································································.57
2.5.4 小寫(xiě)數(shù)字轉(zhuǎn)換為大寫(xiě)數(shù)字 ·························································.58
2.5.5 高頻詞的輸入 ········································································.58
第3 章 WPS 文檔排版 ················································································.60
3.1 設(shè)置WPS 文檔的格式 ······································································.60
3.1.1 設(shè)置字符格式 ········································································.60
3.1.2 設(shè)置段落格式 ········································································.63
3.1.3 設(shè)置邊框和底紋 ·····································································.65
3.1.4 設(shè)置項(xiàng)目符號(hào)和編號(hào) ·······························································.67
3.1.5 設(shè)置文檔分頁(yè)、分節(jié)與分欄 ······················································.70
3.1.6 設(shè)置頁(yè)眉、頁(yè)腳與頁(yè)碼 ····························································.72
3.1.7 調(diào)整頁(yè)面布局 ········································································.76
3.1.8 設(shè)置頁(yè)面背景與頁(yè)面水印 ·························································.77
3.1.9 實(shí)例練習(xí) ··············································································.80
3.2 WPS 文檔的圖文混排 ·······································································.87
3.2.1 插入圖片 ··············································································.88
3.2.2 插入形狀 ··············································································.95
3.2.3 插入智能圖形 ········································································.98
3.2.4 插入藝術(shù)字 ···········································································.99
3.2.5 插入文本框 ··········································································.100
3.2.6 實(shí)例練習(xí) ·············································································.101
3.3 在文檔中編輯表格 ··········································································.107
3.3.1 創(chuàng)建表格 ·············································································.107
3.3.2 編輯表格 ·············································································.110
3.3.3 表格格式化 ··········································································.114
3.3.4 表格與文本的相互轉(zhuǎn)換 ···························································.115
3.3.5 表格數(shù)據(jù)轉(zhuǎn)化成圖表 ······························································.117
3.3.6 實(shí)例練習(xí) ·············································································.119
第4 章 長(zhǎng)文檔的編輯 ················································································.123
4.1 樣式的創(chuàng)建和使用 ··········································································.123
4.1.1 在文檔中應(yīng)用樣式 ·································································.123
4.1.2 創(chuàng)建新樣式 ··········································································.124
4.1.3 修改樣式 ·············································································.125
4.2 在文檔中添加引用的內(nèi)容 ·································································.125
4.2.1 插入腳注和尾注 ····································································.125
4.2.2 插入題注 ·············································································.126
4.2.3 插入交叉引用 ·······································································.127
4.3 創(chuàng)建文檔目錄 ················································································.128
4.3.1 利用內(nèi)置目錄樣式創(chuàng)建目錄 ·····················································.128
4.3.2 更新目錄 ·············································································.129
4.3.3 自定義目錄樣式創(chuàng)建目錄 ························································.129
4.4 文檔的審閱和管理 ··········································································.132
4.4.1 拼寫(xiě)檢查 ·············································································.133
4.4.2 使用批注 ·············································································.134
4.4.3 修訂內(nèi)容 ·············································································.135
4.4.4 文檔安全 ·············································································.138
4.5 實(shí)例練習(xí) ······················································································.139
第5 章 通過(guò)郵件合并批量處理文檔 ······························································.153
5.1 郵件合并的基礎(chǔ) ·············································································.153
5.2 郵件合并應(yīng)用實(shí)例 ··········································································.153
第三篇 通過(guò)WPS 創(chuàng)建并處理電子表格
第6 章 WPS 創(chuàng)建表格基礎(chǔ) ········································································.160
6.1 工作簿和工作表 ·············································································.160
6.1.1 WPS 表格的術(shù)語(yǔ) ···································································.160
6.1.2 工作簿的基本操作 ·································································.161
6.1.3 工作表的基本操作 ·································································.164
6.1.4 實(shí)用操作技巧 ·······································································.167
6.2 輸入和編輯數(shù)據(jù) ·············································································.169
6.2.1 直接輸入數(shù)據(jù) ·······································································.169
6.2.2 填充有規(guī)律的數(shù)據(jù) ·································································.170
6.2.3 設(shè)置輸入數(shù)據(jù)的有效性 ···························································.172
6.2.4 實(shí)用操作技巧 ·······································································.173
6.3 表格的編輯和格式化 ·······································································.174
6.3.1 行列操作 ·············································································.174
6.3.2 設(shè)置單元格格式 ····································································.176
6.3.3 套用單元格樣式 ····································································.179
6.3.4 套用表格樣式 ·······································································.180
6.3.5 應(yīng)用條件格式 ·······································································.182
6.4 工作表的打印輸出 ··········································································.186
6.4.1 頁(yè)面設(shè)置 ·············································································.186
6.4.2 設(shè)置打印區(qū)域 ·······································································.188
6.4.3 打印預(yù)覽與打印 ····································································.189
6.5 實(shí)例練習(xí) ······················································································.190
第7 章 使用公式與函數(shù)計(jì)算數(shù)據(jù) ·································································.193
7.1 公式的使用 ···················································································.193
7.1.1 公式的組成 ··········································································.193
7.1.2 公式中的運(yùn)算符 ····································································.193
7.1.3 公式的輸入與編輯 ·································································.194
7.1.4 實(shí)例練習(xí) ·············································································.195
7.1.5 實(shí)用操作技巧 ·······································································.196
7.2 單元格引用 ···················································································.198
7.2.1 相對(duì)引用 ·············································································.198
7.2.2 絕對(duì)引用 ·············································································.198
7.2.3 混合引用 ·············································································.199
7.2.4 引用其他工作表數(shù)據(jù) ······························································.199
7.3 在公式中使用定義名稱(chēng) ····································································.200
7.3.1 定義名稱(chēng) ·············································································.200
7.3.2 將定義的名稱(chēng)用于公式 ···························································.202
7.4 公式審核 ······················································································.203
7.4.1 顯示公式 ·············································································.203
7.4.2 更正公式中的錯(cuò)誤 ·································································.204
7.5 函數(shù)的使用 ···················································································.204
7.5.1 函數(shù)的結(jié)構(gòu) ··········································································.204
7.5.2 插入函數(shù) ·············································································.204
7.5.3 常用函數(shù)的應(yīng)用 ····································································.206
7.6 實(shí)例練習(xí) ······················································································.214
第8 章 圖表在數(shù)據(jù)分析中的應(yīng)用 ·································································.216
8.1 創(chuàng)建標(biāo)準(zhǔn)圖表 ················································································.216
8.1.1 圖表類(lèi)型 ·············································································.216
8.1.2 創(chuàng)建圖表 ·············································································.217
8.1.3 編輯圖表 ·············································································.218
8.1.4 格式化圖表 ··········································································.225
8.2 創(chuàng)建組合圖表 ················································································.228
8.3 實(shí)例練習(xí) ······················································································.228
第9 章 數(shù)據(jù)處理與分析 ·············································································.234
9.1 導(dǎo)入外部數(shù)據(jù) ················································································.234
9.1.1 導(dǎo)入文本文件 ·······································································.234
9.1.2 分列顯示 ·············································································.236
9.1.3 合并計(jì)算 ·············································································.238
9.2 數(shù)據(jù)排序 ······················································································.239
9.2.1 單個(gè)字段排序 ·······································································.239
9.2.2 多個(gè)字段排序 ·······································································.239
9.2.3 格式排序 ·············································································.241
9.2.4 自定義排序 ··········································································.243
9.3 數(shù)據(jù)篩選 ······················································································.245
9.3.1 自動(dòng)篩選 ·············································································.245
9.3.2 自定義篩選 ··········································································.249
9.3.3 高級(jí)篩選 ·············································································.250
9.4 數(shù)據(jù)分類(lèi)匯總 ················································································.253
9.4.1 插入分類(lèi)匯總 ·······································································.253
9.4.2 創(chuàng)建分級(jí)顯示 ·······································································.256
9.4.3 插入嵌套分類(lèi)匯總 ·································································.260
9.5 數(shù)據(jù)透視表和數(shù)據(jù)透視圖 ·································································.263
9.5.1 創(chuàng)建數(shù)據(jù)透視表 ····································································.263
9.5.2 篩選數(shù)據(jù)透視表 ····································································.268
9.5.3 使用切片器篩選數(shù)據(jù) ······························································.270
9.5.4 顯示報(bào)表篩選項(xiàng) ····································································.271
9.5.5 顯示明細(xì)數(shù)據(jù) ·······································································.273
9.5.6 設(shè)置字段名稱(chēng)及值 ·································································.274
9.5.7 設(shè)置透視表樣式 ····································································.276
9.5.8 創(chuàng)建數(shù)據(jù)透視圖 ····································································.277
9.5.9 刪除數(shù)據(jù)透視表或數(shù)據(jù)透視圖 ··················································.278
第四篇 使用WPS 制作演示文稿
第10 章 創(chuàng)建演示文稿 ··············································································.280
10.1 創(chuàng)建演示文稿的途徑 ······································································.280
10.1.1 創(chuàng)建空白演示文稿 ·······························································.280
10.1.2 WPS 演示工作窗口 ······························································.281
10.1.3 利用模板創(chuàng)建演示文稿 ·························································.282
10.2 幻燈片的基本操作 ·········································································.283
10.2.1 設(shè)置幻燈片的大小和方向 ······················································.283
10.2.2 插入和刪除幻燈片 ·······························································.284
10.2.3 復(fù)制或移動(dòng)幻燈片 ·······························································.285
10.2.4 添加幻燈片編號(hào) ··································································.285
10.2.5 添加幻燈片日期和時(shí)間 ·························································.286
10.2.6 幻燈片的分節(jié) ·····································································.286
10.2.7 幻燈片的隱藏和顯示 ····························································.288
10.3 演示文稿的視圖 ············································································.289
第11 章 演示文稿的設(shè)計(jì)和制作 ··································································.291
11.1 幻燈片母版和版式的應(yīng)用 ································································.291
11.1.1 創(chuàng)建幻燈片母版 ··································································.291
11.1.2 幻燈片版式的應(yīng)用 ·······························································.293
11.1.3 套用幻燈片母版/版式 ···························································.294
11.2 應(yīng)用幻燈片配色方案與背景 ·····························································.296
11.2.1 應(yīng)用幻燈片配色方案 ····························································.296
11.2.2 應(yīng)用幻燈片背景 ··································································.297
11.3 演示文稿內(nèi)容的編輯 ······································································.300
11.3.1 添加文本 ···········································································.300
11.3.2 插入圖片和形狀 ··································································.305
11.3.3 插入智能圖形 ·····································································.311
11.3.4 插入表格 ···········································································.315
11.3.5 插入音頻 ···········································································.315
11.3.6 插入視頻 ···········································································.317
11.4 演示文稿的動(dòng)畫(huà)效果設(shè)置 ································································.320
11.4.1 設(shè)置幻燈片內(nèi)容的動(dòng)畫(huà)效果 ···················································.320
11.4.2 設(shè)置幻燈片切換的動(dòng)畫(huà)效果 ···················································.327
11.4.3 超鏈接 ··············································································.328
第12 章 演示文稿的放映與共享 ··································································.331
12.1 演示文稿的放映 ············································································.331
12.1.1 幻燈片放映控制 ··································································.332
12.1.2 應(yīng)用排練計(jì)時(shí) ·····································································.333
12.1.3 自定義放映 ········································································.334
12.1.4 手機(jī)遙控放映 ·····································································.335
12.1.5 放映時(shí)使用墨跡標(biāo)記幻燈片 ···················································.336
12.2 演示文稿的共享 ············································································.337
12.2.1 輸出為PDF ········································································.337
12.2.2 輸出為視頻 ········································································.338
12.2.3 文件打包 ···········································································.339
12.3 打印演示文稿及講義 ······································································.340
第13 章 實(shí)例—制作答辯演示文稿 ·······························································.341
13.1 利用母版統(tǒng)一答辯演示文稿外觀 ······················································.341
13.1.1 統(tǒng)一答辯演示文稿的外觀 ······················································.341
13.1.2 統(tǒng)一答辯演示文稿的字體 ······················································.342
13.1.3 添加幻燈片編號(hào) ··································································.343
13.2 輸入答辯演示文稿的內(nèi)容 ································································.344
13.2.1 輸入標(biāo)題和目錄 ··································································.344
13.2.2 插入圖片 ···········································································.348
13.2.3 插入形狀 ···········································································.348
13.2.4 插入智能圖形 ·····································································.351
13.3 為答辯演示文稿添加動(dòng)畫(huà)效果··························································.352
13.3.1 為形狀和文本框添加進(jìn)入效果 ················································.352
13.3.2 為文本添加退出效果 ····························································.354
13.4 為答辯演示文稿添加切換效果··························································.355
13.5 為答辯演示文稿添加交互設(shè)置··························································.356
13.5.1 為目錄設(shè)置超鏈接 ·······························································.356
13.5.2 添加返回目錄動(dòng)作按鈕 ·························································.356
附錄A 全國(guó)計(jì)算機(jī)等級(jí)考試二級(jí)WPS Office 試題及答案 ·································.358