Excel Ch 3 Flashcards
1
Q
Formula AutoComplete
A
Displays a list of potential matches (functions and other valid reference names) after an = had been typed in a cell in Excel.
2
Q
AVERAGE
A
A statistical function that is used to calculate the average value of a group of values. A formula using the AVERAGE function looks like this: =AVERAGE (A3:A6)
3
Q
Mean
A
The sum of a group of values divided by the number of values in the group
4
Q
Median
A
The middle value of a set of values
5
Q
Mode
A
The value that appears most often in a group of values.
6
Q
MAX
A
7
Q
MIN
A
8
Q
NOW
A
9
Q
TODAY
A
10
Q
Volatile
A
11
Q
COUNT
A
12
Q
COUNTA
A
13
Q
COUNTBLANK
A
14
Q
String
A
15
Q
Text String
A
16
Q
PROPER
A
17
Q
UPPER
A
18
Q
LOWER
A
19
Q
LEN
A
20
Q
Concentrate
A
21
Q
CONCAT
A
22
Q
TEXTJOIN
A
23
Q
Delimiter (TEXTJOIN)
A
24
Q
3-D Reference
A
25
Name
26
Range Name
27
Named Range
28
Name Manager
29
Defined name
30
IF
31
PMT
32
VLOOKUP
33
XLOOKUP
34
HLOOKUP
35
Smart Tag
36
Precedent
37
Dependent
