Excel 函数应用完全手册Word格式.docx
- 文档编号:16478664
- 上传时间:2022-11-24
- 格式:DOCX
- 页数:107
- 大小:93.83KB
Excel 函数应用完全手册Word格式.docx
《Excel 函数应用完全手册Word格式.docx》由会员分享,可在线阅读,更多相关《Excel 函数应用完全手册Word格式.docx(107页珍藏版)》请在冰豆网上搜索。
(二)函数的参数..............................................................................................................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
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
(三)外部函数....................................................................................................................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.........................................................................................................................8
8.COMPLEX.........................................................................................................................8
9.CONVERT.........................................................................................................................8
10.DEC2BIN.......................................................................................................................8
11.DEC2HEX.......................................................................................................................8
12.DEC2OCT........................................................................................................................8
13.DELTA...........................................................................................................................8
14.ERF................................................................................................................................8
15.ERFC..............................................................................................................................9
16.GESTEP...........................................................................................................................9
17.HEX2BIN.........................................................................................................................9
18.HEX2DEC.........................................................................................................................9
19.HEX2OCT.........................................................................................................................9
20.IMABS.............................................................................................................................9
21.IMAGINARY....................................................................................................................9
22.IMARGUMENT................................................................................................................9
23.MCONJUGATE..................................................................................
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Excel 函数应用完全手册 函数 应用 完全 手册