ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
函數功能值選項值數值
2
#NAME?4413
3
16
4
對應函數數字結果8
5
AVERAGE1#NAME?11
6
COUNT2#NAME?5
7
COUNTA3#NAME?2
8
MAX4#NAME?8
9
MIN5#NAME?12
10
PRODUCT6#NAME?4
11
STDEV.S7#NAME?
12
STDEV.P8#NAME?
13
SUM9#NAME?
14
VAR.S10#NAME?
15
VAR.P11#NAME?
16
MEDIAN12#NAME?
17
MODE.SNGL13#NAME?
18
LARGE14#NAME?
19
SMALL15#NAME?
20
PERCENTILE.INC16#NAME?
21
QUARTILE.INC17#NAME?
22
PERCENTILE.EXC18#NAME?
23
QUARTILE.EXC19#NAME?
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100