Excel Functions - One | Baamboozle - Baamboozle | The Most Fun Classroom Games!

Team 1
0

Team 2
0

Teams

Name

Score

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

Loading

10

What does =MEDIAN do?

Find the median (middle) number.

Oops!

Check

Okay!

Check

15

What does =SUMIF do?

Gives the sum of a range with one matching criteria

Oops!

Check

Okay!

Check

15

What does the =COUNTIF function do?

Counts cells as specified

Oops!

Check

Okay!

Check

20

What does =NPV do?

Uses a percentage reference to return a net total.

Oops!

Check

Okay!

Check

baam

Lose 25 points!

Oops!

seesaw

Swap points!

Okay!

rocket

Go to first place!

Okay!

banana

Go to last place!

Oops!

10

What does the =MAX function do?

Returns the highest value in a range

Oops!

Check

Okay!

Check

10

What does the =COUNT function do?

Counts cells with numbers in a range

Oops!

Check

Okay!

Check

5

What does the =AVERAGE function do?

Calculates the average (arithmetic mean)

Oops!

Check

Okay!

Check

banana

Go to last place!

Oops!

fairy

Take points!

5

10

15

20

25

gift

Win 15 points!

Okay!

baam

Lose 10 points!

Oops!

eraser

Reset score!

Oops!

gold

Win 50 points!

Okay!

fairy

Take points!

5

10

15

20

25

thief

Give points!

5

10

15

20

25

15

What kind of graph is this?

Pie graph

Oops!

Check

Okay!

Check

10

What does the =COUNTA function do?

Counts all cells in a range that has values, both numbers and letters

Oops!

Check

Okay!

Check

20

What kind of chart is this?

Line chart

Oops!

Check

Okay!

Check

10

What does =RAND do?

Generate a random number.

Oops!

Check

Okay!

Check

monster

Reset all scores!

Oops!

gold

Win 50 points!

Okay!

rocket

Go to first place!

Okay!

lifesaver

Give 20 points!

Oops!

25

What kind of chart is this?

Scatterplot

Oops!

Check

Okay!

Check

Restart Join for Free

;

Your experience on this site will be improved by allowing cookies.