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
