56.SUMX2PY2 (27)
57.SUMXMY2 (28)
58.TAN (28)
59.TANH (28)
60.TRUNC (28)
(十)统计函数 (28)
1.AVEDEV (28)
2.AVERAGE (28)
3.AVERAGEA (28)
4.BETADIST (28)
5.BETAINV (28)
6.BINOMDIST (29)
7.CHIDIST (29)
8.CHIINV (29)
9.CHITEST (29)
10.CONFIDENCE (29)
11.CORREL (29)
12.COUNT (29)
13.COUNTA (30)
14.COUNTBLANK (30)
15.COUNTIF (30)
16.COVAR (30)
页脚
17.CRITBINOM (30)
18.DEVSQ (30)
19.EXPONDIST (30)
20.FDIST (30)
21.FINV (30)
22.FISHER (31)
23.FISHERINV (31)
24.FORECAST (31)
25.FREQUENCY (31)
26.FTEST (31)
27.GAMMADIST (31)
28.GAMMAINV (31)
29.GAMMALN (31)
30.GEOMEAN (31)
31.GROWTH (32)
32.HARMEAN (32)
33.HYPGEOMDIST (32)
34.INTERCEPT (32)
35.KURT (32)
RGE (32)
37.LINEST (32)
38.LOGEST (33)
39.LOGINV (33)
页脚
40.LOGNORMDIST (33)
41.MAX (33)
42.MAXA (33)
43.MEDIAN (33)
44.MIN (33)
45.MINA (33)
46.MODE (33)
47.NEGBINOMDIST (34)
48.NORMDIST (34)
49.NORMSINV (34)
50.NORMSDIST (34)
51.NORMSINV (34)
52.PEARSON (34)
53.PERCENTILE (34)
54.PERCENTRANK (34)
55.PERMUT (35)
56.POISSON (35)
57.PROB (35)
58.QUARTILE (35)
59.RANK (35)
60.RSQ (35)
61.SKEW (35)
62.SLOPE (35)
页脚
63.SMALL (36)
64.STANDARDIZE (36)
65.STDEV (36)
66.STDEVA (36)
67.STDEVP (36)
68.STDEVPA (36)
69.STEYX (36)
70.TDIST (37)
71.TINV (37)
72.TREND (37)
73.TRIMMEAN (37)
74.TTEST (37)
75.VAR (37)
76.VARA (37)
77.VARP (37)
78.VARPA (38)
79.WEIBULL (38)
80.ZTEST (38)
(十一)文本和数据函数 (38)
1.ASC (38)
2.CHAR (38)
3.CLEAN (38)
页脚
4.CODE (38)
5.CONCATENATE (38)
6.DOLLAR 或RMB (38)
7.EXACT (39)
8.FIND (39)
9.FINDB (39)
10.FIXED (39)
11.JIS (39)
12.LEFT 或LEFTB (39)
13.LEN 或LENB (39)
14.LOWER (40)
15.MID 或MIDB (40)
16.PHONETIC (40)
17.PROPER (40)
18.REPLACE 或REPLACEB (40)
19.REPT (40)
20.RIGHT 或RIGHTB (40)
21.SEARCH 或SEARCHB (41)
22.SUBSTITUTE (41)
23.T (41)
24.TEXT (41)
25.TRIM (41)
26.UPPER (41)
页脚
27.VALUE (41)
28.WIDECHAR (41)
三、函数应用案例──算账理财 (42)
1.零存整取储蓄 (42)
2.还贷金额 (42)
3.保险收益 (42)
4.个税缴纳金额 (43)
四、函数应用案例──信息统计 (43)
1.性别输入 (43)
2.出生日期输入 (44)
3.职工信息查询 (44)
4.职工性别统计 (45)
5.年龄统计 (45)
6.名次值统计 (45)
7.位次阈值统计 (46)
五、函数应用案例──管理计算 (46)
1.授课日数 (46)
2.折旧值计算 (46)
3.客流均衡度计算 (47)
4.销售额预测 (47)
页脚
5.客流与营业额的相关分析 (47)
页脚
一、函数应用基础
( 一) 函数和公式
1 .什么是函数
Excel 函数即是预先定义，执行计算、分析等处理数据任务的特殊公式。以常用的求和函数SUM 为例，它的语法是
页脚