没有合适的资源?快使用搜索试试~ 我知道了~
Excel2003函数应用完全手册簿.doc
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 43 浏览量
2021-11-18
10:26:02
上传
评论
收藏 451KB DOC 举报
温馨提示
试读
70页
Excel2003函数应用完全手册簿.doc
资源推荐
资源详情
资源评论
word
1 / 70
Excel 2003
函数应用完全手册
二〇〇四年二月二日
目 录
一 、 函 数 应 用 根
底 ...................................................................................................
...................................... 1
( 一 ) 函 数 和 公
式 ...................................................................................................
............................................ 1
.....................................................................................................
.........................…................. 1
.....................................................................................................
.........................…................. 1
( 二 ) 函 数 的 参
数 ...................................................................................................
............................................. 1
量 ...................................................................................................
.......................................….................. 1
.....................................................................................................
.....................................….............. 1
.....................................................................................................
.......................................…................ 1
.....................................................................................................
...................................…................ 1
.....................................................................................................
..........................…................. 1
.....................................................................................................
............................…................... 2
.....................................................................................................
...................…........................ 2
( 三 ) 函 数 输 入 方
法 ...................................................................................................
.......................................... 2
1. “ 插 入 函 数 〞 对 话
框 ...................................................................................................
............................….. 2
输
入 ...................................................................................................
............................................….. 3
二 、 函 数 速 查 一
览 ...................................................................................................
word
2 / 70
......................................... 3
( 一 ) 数 据 库 函
数 ..................................................................................................
........................................... 3
AGE..................................................................................................
................................................. 3
UNT..................................................................................................
.........................................…......... 3
TA...................................................................................................
......................................…......... 3
GET..................................................................................................
........................................………......... 3
5.DMAX...............................................................................................
...........................................……........... 3
MIN..................................................................................................
..........................................………....... 3
DUCT.................................................................................................
................................................... 3
TDEV.................................................................................................
........................................……......... 3
EVP..................................................................................................
......................................…............ 4
M....................................................................................................
.........................................……........ 4
VAR..................................................................................................
...........................................………..... 4
RP...................................................................................................
........................................……......... 4
.....................................................................................................
...................................... 4
( 二 ) 日 期 与 时 间 函
数 ..................................................................................................
..................................... 4
TE...................................................................................................
............................................…….......... 4
.....................................................................................................
.............................….............. 4
.....................................................................................................
............................................……........... 4
.....................................................................................................
............................……................... 5
.....................................................................................................
................................…...................... 5
6.EOMONTH............................................................................................
................................…........................ 5
.....................................................................................................
word
3 / 70
...................................….................... 5
.....................................................................................................
..............................…..................... 5
.....................................................................................................
...................................................... 5
....................................................................................................
..................................... 5
11.NOW...............................................................................................
.........................................…................... 6
.....................................................................................................
...........................….................... 6
.....................................................................................................
..................................…................... 6
....................................................................................................
............................................ 6
.....................................................................................................
...............................…................... 6
.....................................................................................................
................................................ 6
.....................................................................................................
............................................... 6
18.WORKDAY...........................................................................................
.......................................................... 6
.....................................................................................................
.................................….................... 7
....................................................................................................
............................................... 7
( 三 ) 外 部 函
数 ..................................................................................................
................................................... 7
....................................................................................................
.......................................... 7
....................................................................................................
....................…..................... 7
( 四 ) 工 程 函
数..................................................................................................
................................................... 7
1.BESSELI............................................................................................
...........................................…….............. 7
.....................................................................................................
...................................……............. 8
.....................................................................................................
........................……....................... 8
4.BESSELY............................................................................................
..........................................……............... 8
word
4 / 70
.....................................................................................................
...............................……................. 8
6.BIN2HEX............................................................................................
......................................……................... 8
.....................................................................................................
..............................……................... 8
.....................................................................................................
...........................…....................... 8
9.CONVERT............................................................................................
.....................................…….................... 8
.....................................................................................................
...........................…….................... 8
11.DEC2HEX...........................................................................................
....................................…….................... 8
.....................................................................................................
............................…….................. 8
13.DELTA.............................................................................................
.........................................…….................. 8
14.ERF...............................................................................................
............................................…….................. 8
15.ERFC..............................................................................................
..........................................……................. 9
.....................................................................................................
...............................…….................. 9
17.HEX2BIN...........................................................................................
.......................................……................. 9
18.HEX2DEC...........................................................................................
.......................................……................. 9
.....................................................................................................
.............................……................. 9
.....................................................................................................
...................................……................ 9
21.IMAGINARY ........................................................................................
......................................…................... 9
....................................................................................................
.................…........................ 9
....................................................................................................
.................…........................ 9
.....................................................................................................
................................……................... 9
25.IMDIV.............................................................................................
.......................................…….................... 9
26.IMEXP.............................................................................................
..................................……......................... 9
27.IMLN..............................................................................................
........................................…….................... 9
.....................................................................................................
word
5 / 70
.......................……...................... 10
.....................................................................................................
.........................……...................... 10
.....................................................................................................
..........................…….................. 10
....................................................................................................
.....................…...................... 10
.....................................................................................................
.................................….............. 10
33.IMSIN.............................................................................................
.............................................……........... 10
.....................................................................................................
.................................…............... 10
.....................................................................................................
.....................................….…......... 10
36.IMSUM.............................................................................................
.................................................…........ 10
.....................................................................................................
......................................…........ 10
.....................................................................................................
...................................….......... 10
.....................................................................................................
...................................….......... 10
( 五 ) 财 务 函
数 ..................................................................................................
................................................. 10
.....................................................................................................
............................…................... 10
.....................................................................................................
..................….......................... 11
3.AMORDEGRC .........................................................................................
.........................….......................... 11
.....................................................................................................
..................….......................... 11
5.COUPDAYBS .........................................................................................
........................................................ 11
.....................................................................................................
...................…......................... 11
....................................................................................................
........................................... 11
8.COUPNUM............................................................................................
.............................….......................... 11
.....................................................................................................
....................…........................... 11
10.CUMIPMT...........................................................................................
...........................…............................ 11
剩余69页未读,继续阅读
资源评论
bhl2690
- 粉丝: 0
- 资源: 5万+
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功