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

15

What does the =AND function do?

Returns TRUE or FALSE based on two or more conditions

Oops!

Check

Okay!

Check

baam

Lose 25 points!

Oops!

magnet

Take 25 points!

Okay!

shark

Other team loses 25 points!

Okay!

lifesaver

Give 5 points!

Oops!

baam

Lose 20 points!

Oops!

gold

Win 50 points!

Okay!

shark

Other team loses 10 points!

Okay!

baam

Lose 5 points!

Oops!

10

What does the =MAX function do?

Returns the highest value in a range

Oops!

Check

Okay!

Check

20

What does the =IF function do?

Returns values based on a TRUE or FALSE condition

Oops!

Check

Okay!

Check

20

What does the =COUNTIFS function do?

Counts cells in a range based on one or more TRUE or FALSE condition

Oops!

Check

Okay!

Check

15

What kind of graph is this?

Pie graph

Oops!

Check

Okay!

Check

10

What does =MEDIAN do?

Find the median (middle) number.

Oops!

Check

Okay!

Check

10

What does =RAND do?

Generate a random number.

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

5

What does =MIN do?

Find the lowest number in a range.

Oops!

Check

Okay!

Check

15

What does =TODAY() do?

Provides today's date

Oops!

Check

Okay!

Check

5

What does the =AVERAGE function do?

Calculates the average (arithmetic mean)

Oops!

Check

Okay!

Check

seesaw

Swap points!

Oops!

gift

Win 25 points!

Okay!

fairy

Take points!

5

10

15

20

25

thief

Give points!

5

10

15

20

25

5

What does =SUM do?

Gives the sum of a range.

Oops!

Check

Okay!

Check

10

What does =MODE do?

Find the mode of a range (the number that appears the most.)

Oops!

Check

Okay!

Check

Restart Join for Free

;

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