wps文字2016操作技巧

1、目錄1.辦公數據錄入規(guī)范和技巧...........................................................................................................11.1.快捷鍵..........................................................................................

2、.....................................11.2.數據填充...........................................................................................................................11.3.自定義序列.........................................

3、..............................................................................21.4.數據格式設置...................................................................................................................31.5.中文大寫.......

4、....................................................................................................................42.智能顯示非法、錯誤數據..........................................................................................

5、.................52.1.重復值限制錄入...............................................................................................................52.2.高亮顯示重復項....................................................................

6、...........................................52.3.刪除重復項.......................................................................................................................63.精美報表格式和閱讀工具..................................

7、.........................................................................73.1.報表格式工具...................................................................................................................73.2.閱讀模式............

8、...............................................................................................................73.3.護眼模式....................................................................................................

9、.......................83.4.夜間模式...........................................................................................................................93.5.大數據閱讀.......................................................

10、..............................................................103.6.編輯欄折疊.....................................................................................................................104.公式和函數.....................

11、............................................................................................................114.1.公式........................................................................................................

12、.........................114.2.函數.................................................................................................................................134.3.常用統(tǒng)計函數..............................................

13、...................................................................13WPS表格操作指引書9.2.工作表的保護.................................................................................................................319.3.單元格的保護......