相關主題
商品描述
本書是《WPS 辦公應用職業技能等級標準》（中級）與全國計算機等級考試（二級）的配套教材，包括長文檔管理、演示文稿制作和表格數據運算3大模塊9個項目，深入淺出地介紹了長文檔編輯、排版美化、演示文稿編輯、演示文稿合成、動畫制作、數據管理、公式函數、排序、篩選、分類匯總、合並、透視表等知識點與技能點，同時每個模塊均介紹了WPS AI的相關功能，跟蹤人工智能大模型技術的應用發展趨勢，使學生掌握如何應用AI輔助辦公、提高效率。 本書適用應用型本科院校、高等職業院校計算機相關專業學生和老師。
目錄大綱
第一篇 長文檔管理
項目 1 公司招聘啟事文檔的制作 ·························································.002
學習目標 ····················································································.002
項目效果 ····················································································.002
知識技能 ····················································································.003
1.1 視圖的應用 ··········································································.003
1.3 圖形的繪制 ··········································································.011
1.4 表格樣式的設置 ····································································.015
1.5 表格工具的應用 ····································································.016
主要步驟 ····················································································.017
項目拓展 ····················································································.020
項目小結 ····················································································.021
綜合練習 ····················································································.021
項目 2 網店策劃論文的排版 ·······························································.024
學習目標 ·····················································································.24
項目效果 ·····················································································.24
知識技能 ·····················································································.25
2.1 項目符號和編號的設置 ····························································.25
2.2 多級編號的應用 ·····································································.27
2.3 分隔符的設置 ········································································.30
2.4 章節工具的應用 ·····································································.31
2.5 多頁表格的設置 ·····································································.34
2.6 導航窗格的應用 ·····································································.35
主要步驟 ·····················································································.36
項目拓展 ·····················································································.38
項目小結 ·····················································································.40
綜合練習 ·····················································································.40
項目 3 網店策劃論文的美化 ·······························································.043
學習目標 ····················································································.043
項目效果 ····················································································.043
知識技能 ····················································································.044
3.1 修改與新建樣式 ····································································.044
3.2 頁眉、頁腳的美化 ·································································.046
3.3 圖表編號和目錄的設置 ···························································.048
3.4 腳註和尾註的美化 ·································································.049
3.5 超鏈接與交叉引用的使用 ························································.050
3.6 參考文獻與書簽的設置 ···························································.052
3.7 AI 文檔排版 ·········································································.054
主要步驟 ····················································································.055
項目拓展 ····················································································.057
項目小結 ····················································································.058
綜合練習 ····················································································.059
第二篇 演示文稿制作
項目 4 公司簡介演示文稿的制作 ·························································.064
學習目標 ····················································································.064
項目效果 ····················································································.064
知識技能 ····················································································.065
4.1 圖片的處理 ··········································································.065
4.2 智能圖形的應用 ····································································.069
4.3 表格的編輯 ··········································································.070
4.4 公式的編輯 ··········································································.072
4.5 幻燈片對齊工具 ····································································.073
4.6 版式與母版的設置 ·································································.074
主要步驟 ····················································································.076
項目拓展 ····················································································.083
項目小結 ····················································································.085
綜合練習 ····················································································.086
項目 5 旅遊景點演示文稿的制作 ·························································.088
學習目標 ····················································································.088
項目效果 ····················································································.088
知識技能 ····················································································.090
5.1 音頻和視頻的插入 ·································································.090
5.2 音頻和視頻的編輯 ·································································.094
5.3 音頻超鏈接和視頻超鏈接的設置 ···············································.095
5.4 動作鏈接的設置 ····································································.099
5.5 演示文稿的合並 ····································································.101
5.6 AI 生成演示文稿 ···································································.102
主要步驟 ····················································································.105
項目拓展 ····················································································.111
項目小結 ····················································································.112
綜合練習 ····················································································.112
項目 6 畢業紀念冊演示文稿制作 ·························································.115
學習目標 ····················································································.115
項目效果 ····················································································.115
知識技能 ····················································································.116
6.1 路徑動畫的設置與應用 ···························································.116
6.2 文本動畫的設置與應用 ···························································.118
6.3 “動畫窗格”的應用 ······························································.119
6.4 復雜動畫的制作 ····································································.121
6.5 交互式動畫的制作 ·································································.122
主要步驟 ····················································································.125
項目拓展 ····················································································.130
項目小結 ····················································································.131
綜合練習 ····················································································.132
第三篇 表格數據運算
項目 7 學業成績統計 ········································································.136
學習目標 ····················································································.136
項目效果 ····················································································.136
知識技能 ····················································································.138
7.1 單元格引用 ··········································································.138
7.2 公式 ···················································································.138
7.3 常用函數 ·············································································.139
7.4 公式套用 ·············································································.141
主要步驟 ····················································································.141
項目拓展 ····················································································.143
項目小結 ····················································································.144
綜合練習 ····················································································.144
項目 8 星級寢室評比 ········································································.146
學習目標 ····················································································.146
項目效果 ····················································································.146
知識技能 ····················································································.146
8.1 數據類型 ·············································································.146
8.2 數據轉換 ·············································································.147
8.3 填充 ···················································································.149
8.4 條件格式 ·············································································.150
8.5 數據有效性 ··········································································.151
8.6 下拉列表 ·············································································.152
主要步驟 ····················································································.152
項目拓展 ····················································································.155
項目小結 ····················································································.156
綜合練習 ····················································································.157
項目 9 公益捐贈物品統計 ··································································.159
學習目標 ····················································································.159
項目效果 ····················································································.159
知識技能 ····················································································.161
9.1 排序 ···················································································.161
9.2 篩選 ···················································································.162
9.3 分類匯總 ·············································································.163
9.4 數據透視表 ··········································································.164
9.5 圖表 ···················································································.165
9.6 數據合並 ·············································································.167
9.7 AI 表格················································································.169
主要步驟 ····················································································.170
項目拓展 ····················································································.173
項目小結 ····················································································.174
綜合練習 ····················································································.174
