没有合适的资源?快使用搜索试试~ 我知道了~
资源详情
资源评论
资源推荐
EXCEL2013 函数速查手册
E.F. LEE
E.F. LEE
目 录
一、数学和三角函数(75 条)....................................................................................11
1. ABS............................................................................................................................. 11
2. ACOS........................................................................................................................... 11
3. ACOSH........................................................................................................................ 11
4. ACOT.......................................................................................................................... 11
5. ACOTH........................................................................................................................ 11
6. ARABIC....................................................................................................................... 12
7. ASIN............................................................................................................................ 12
8. ASINH......................................................................................................................... 12
9. ATAN.......................................................................................................................... 12
10. ATAN2...................................................................................................................... 12
11. ATANH...................................................................................................................... 13
12. BASE......................................................................................................................... 13
13. CEILING..................................................................................................................... 13
14. CEILING.MATH.......................................................................................................... 13
15. COMBIN.................................................................................................................... 14
16. COMBINA................................................................................................................. 14
17. COS........................................................................................................................... 14
18. COSH........................................................................................................................ 14
19. COT........................................................................................................................... 15
20. COTH........................................................................................................................ 15
21. CSC........................................................................................................................... 15
22. CSCH......................................................................................................................... 15
23. DECIMAL................................................................................................................... 15
24. DEGREES................................................................................................................... 16
25. EVEN......................................................................................................................... 16
26. EXP........................................................................................................................... 16
27. FACT......................................................................................................................... 16
28. FACTDOUBLE............................................................................................................ 16
29. FLOOR....................................................................................................................... 17
30. FLOOR.MATH............................................................................................................ 17
31. GCD.......................................................................................................................... 17
32. INT............................................................................................................................ 17
33. LCM.......................................................................................................................... 18
34. LN............................................................................................................................. 18
35. LOG........................................................................................................................... 18
36. LOG10....................................................................................................................... 18
37. MDETERM................................................................................................................ 18
38. MINVERSE................................................................................................................. 19
39. MMULT..................................................................................................................... 19
40. MOD......................................................................................................................... 19
1
EXCEL2013
Excel2013 函数速查手册
41. MROUND 19
42. MULTINOMIAL 19
43. MUNIT 20
44. ODD20
45. PI 20
46. POWER 20
47. PRODUCT 20
48. QUOTIENT 21
49. RADIANS 21
50. RAND 21
51. RANDBETWEEN 21
52. ROMAN 22
53. ROUND 22
54. ROUNDDOWN 22
55. ROUNDUP 22
56. SEC 23
57. SECH 23
58. SERIESSUM 23
59. SIGN 23
60. SIN 23
61. SINH 24
62. SQRT 24
63. SQRTPI 24
64. SUBTOTAL 24
65. SUM 24
66. SUMIF 25
67. SUMIFS 25
68. SUMPRODUCT 25
69. SUMSQ 26
70. SUMX2MY2 26
71. SUMX2PY2 26
72. SUMXMY2 26
73. TAN 26
74. TANH 26
75. TRUNC 27
二、统计函数(89 条)...............................................................................................28
1. AVEDEV 28
2. AVERAGE 28
3. AVERAGEA 28
4. AVERAGEIF 28
5. AVERAGEIFS 29
6. BETADIST 29
7. BETAINV 29
2
E.F. LEE
8. BINOMDIST................................................................................................................. 30
9. BINOM.DIST.RANGE................................................................................................... 30
10. CHIDIST..................................................................................................................... 30
11. CHIINV...................................................................................................................... 31
12. CHITEST.................................................................................................................... 31
13. CONFIDENCE............................................................................................................. 31
14. CORREL..................................................................................................................... 31
15. COUNT...................................................................................................................... 32
16. COUNTA................................................................................................................... 32
17. COUNTBLANK........................................................................................................... 32
18. COUNTIF................................................................................................................... 32
19. COUNTIFS................................................................................................................. 32
20. COVAR...................................................................................................................... 33
21. CRITBINOM............................................................................................................... 33
22. DEVSQ...................................................................................................................... 33
23. EXPONDIST............................................................................................................... 33
24. FDIST........................................................................................................................ 34
25. FINV.......................................................................................................................... 34
26. FISHER...................................................................................................................... 34
27. FISHERINV................................................................................................................. 34
28. FORECAST................................................................................................................. 35
29. FREQUENCY.............................................................................................................. 35
30. FTEST........................................................................................................................ 35
31. GAMMA.................................................................................................................... 35
32. GAMMADIST............................................................................................................. 35
33. GAMMAINV.............................................................................................................. 36
34. GAMMALN................................................................................................................ 36
35. GAUSS...................................................................................................................... 36
36. GEOMEAN................................................................................................................ 36
37. GROWTH.................................................................................................................. 37
38. HARMEAN................................................................................................................ 37
39. HYPGEOMDIST.......................................................................................................... 37
40. INTERCEPT................................................................................................................ 37
41. KURT......................................................................................................................... 38
42. LARGE....................................................................................................................... 38
43. LINEST....................................................................................................................... 38
44. LOGEST..................................................................................................................... 38
45. LOGINV..................................................................................................................... 39
46. LOGNORMDIST......................................................................................................... 39
47. MAX.......................................................................................................................... 39
48. MAXA....................................................................................................................... 39
49. MEDIAN.................................................................................................................... 40
50. MIN.......................................................................................................................... 40
51. MINA........................................................................................................................ 40
3
EXCEL2013
Excel2013 函数速查手册
52. MODE 40
53. NEGBINOMDIST 40
54. NORMDIST 41
55. NORMSINV 41
56. NORMSDIST 41
57. NORMSINV 41
58. PEARSON 41
59. PERCENTILE 42
60. PERCENTRANK 42
61. PERMUT 42
62. PERMUTATIONA 42
63. PHI 43
64. POISSON 43
65. PROB 43
66. QUARTILE 43
67. RANK 43
68. RSQ 44
69. SKEW 44
70. SKEW.P 44
71. SLOPE 45
72. SMALL 45
73. STANDARDIZE 45
74. STDEV 45
75. STDEVA 45
76. STDEVP 46
77. STDEVPA 46
78. STEYX 46
79. TDIST 47
80. TINV 47
81. TREND 47
82. TRIMMEAN 47
83. TTEST 48
84. VAR 48
85. VARA 48
86. VARP 48
87. VARPA 48
88. WEIBULL 49
89. ZTEST 49
三、文本和数据函数(31 条)....................................................................................50
1. ASC 50
2. CHAR 50
3. CLEAN 50
4. CODE 50
4
剩余63页未读,继续阅读
一只梦特娇
- 粉丝: 0
- 资源: 14
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0