Excel Formulas Flashcards
1
Q
How to find the total
A
=SUM()
2
Q
How to find the maximum number
A
=MAX()
3
Q
How to find the minimum number
A
=MIN()
4
Q
How to find the average
A
=AVERAGE()
5
Q
How to find a random number
A
=RANBETWEEN()
6
Q
Now to find today’s date
A
=NOW()
7
Q
How to find the range
A
=first total-second total
8
Q
How to find mode
A
=MODE.SNGL()
9
Q
How to multiply
A
=row*row
10
Q
How to find the median
A
=Median()
11
Q
What happens when the formulas is wrong
A
Put a dollar sign infront of the alphabet
And one at the back
12
Q
Count formula
A
COUNT( value 1 , value 2….. )