Excel 函数应用完全手册.docx
- 文档编号:9914497
- 上传时间:2023-02-07
- 格式:DOCX
- 页数:139
- 大小:100.85KB
Excel 函数应用完全手册.docx
《Excel 函数应用完全手册.docx》由会员分享,可在线阅读,更多相关《Excel 函数应用完全手册.docx(139页珍藏版)》请在冰豆网上搜索。
Excel函数应用完全手册
Excel函数应用完全手册
目 录
一、函数应用基础......................................................................................................................................... 1
(一)函数和公式............................................................................................................................................... 1
1.什么是函数..............................................................................................................................…................. 1
2.什么是公式..............................................................................................................................…................. 1
(二)函数的参数................................................................................................................................................ 1
1.常量..........................................................................................................................................….................. 1
2.逻辑值..........................................................................................................................................….............. 1
3.数组............................................................................................................................................…................ 1
4.错误值........................................................................................................................................…................ 1
5.单元格引用...............................................................................................................................…................. 1
6.嵌套函数.................................................................................................................................…................... 2
7.名称和标志........................................................................................................................…........................ 2
(三)函数输入方法............................................................................................................................................. 2
1.“插入函数”对话框...............................................................................................................................….. 2
2.编辑栏输入...............................................................................................................................................….. 3
二、函数速查一览............................................................................................................................................ 3
(一)数据库函数............................................................................................................................................. 3
1.DAVERAGE................................................................................................................................................... 3
2.DCOUNT...........................................................................................................................................…......... 3
3.DCOUNTA.........................................................................................................................................…......... 3
4.DGET..........................................................................................................................................………......... 3
5.DMAX..........................................................................................................................................……........... 3
6.DMIN............................................................................................................................................………....... 3
7.DPRODUCT.................................................................................................................................................... 3
8.DSTDEV.........................................................................................................................................……......... 3
9.DSTDEVP........................................................................................................................................…............ 4
10.DSUM.............................................................................................................................................……........ 4
11.DVAR.............................................................................................................................................………..... 4
12.DVARP...........................................................................................................................................……......... 4
13.GETPIVOTDATA........................................................................................................................................... 4
(二)日期与时间函数....................................................................................................................................... 4
1.DATE...............................................................................................................................................…….......... 4
2.DATEVALUE..................................................................................................................................….............. 4
3.DAY.................................................................................................................................................……........... 4
4.DAYS360.................................................................................................................................……................... 5
5.EDATE.....................................................................................................................................…...................... 5
6.EOMONTH............................................................................................................................…........................ 5
7.HOUR........................................................................................................................................….................... 5
8.MINUTE...................................................................................................................................…..................... 5
9.MONTH........................................................................................................................................................... 5
10.NETWORKDAYS ......................................................................................................................................... 5
11.NOW........................................................................................................................................…................... 6
12.SECOND................................................................................................................................….................... 6
13.TIME.......................................................................................................................................…................... 6
14.TIMEVALUE ................................................................................................................................................ 6
15.TODAY....................................................................................................................................…................... 6
16.WEEKDAY..................................................................................................................................................... 6
17.WEEKNUM.................................................................................................................................................... 6
18.WORKDAY..................................................................................................................................................... 6
19.YEAR......................................................................................................................................….................... 7
20.YEARFRAC ................................................................................................................................................... 7
(三)外部函数..................................................................................................................................................... 7
1.EUROCONVERT .............................................................................................................................................. 7
2.SQL.REQUEST ........................................................................................................................…..................... 7
(四)工程函数..................................................................................................................................................... 7
1.BESSELI.......................................................................................................................................…….............. 7
2.BESSELJ........................................................................................................................................……............. 8
3.BESSELK.............................................................................................................................……....................... 8
4.BESSELY......................................................................................................................................……............... 8
5.BIN2DEC....................................................................................................................................……................. 8
6.BIN2HEX..................................................................................................................................……................... 8
7.BIN2OCT.......................................................................
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Excel 函数应用完全手册 函数 应用 完全 手册