First Five Functions Flashcards
1
Q
What is it called?
A
Syntax
2
Q
What is the first function?
A
SUM
3
Q
Give an example of SUM
A
=SUM(B2:G2)
4
Q
Describe the function of SUM
A
It adds up your selected cells, gives you your total
5
Q
What is the second function?
A
Average
6
Q
Give an example of Average
A
=Average(A7:A99)
7
Q
Describe the function of Average
A
Find the arithmetic means of the selected cells, adds all up and divides by the amount of numbers there are
8
Q
What is the third function?
A
Maximum (MAX)
9
Q
Give an example of MAX
A
=MAX(B6:B13)
10
Q
Describe the function of MAX
A
Finds the largest of the selected cells
11
Q
What is the fourth function?
A
Minimum (MIN)
12
Q
What is the fourth function?
A
Minimum (MIN)
13
Q
Give an example of MIN
A
=MIN(C4:C10)
14
Q
Describe the function of MIN
A
Finds the smallest of the selected cells
15
Q
What is the fifth function?
A
COUNT
