Excel Formulas Flashcards

1
Q

How to find the total

A

=SUM()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

How to find the maximum number

A

=MAX()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

How to find the minimum number

A

=MIN()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How to find the average

A

=AVERAGE()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How to find a random number

A

=RANBETWEEN()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Now to find today’s date

A

=NOW()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How to find the range

A

=first total-second total

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How to find mode

A

=MODE.SNGL()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How to multiply

A

=row*row

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How to find the median

A

=Median()

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What happens when the formulas is wrong

A

Put a dollar sign infront of the alphabet

And one at the back

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Count formula

A

COUNT( value 1 , value 2….. )

How well did you know this?
1
Not at all
2
3
4
5
Perfectly