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 =MODE do?
Find the mode of a range (the number that appears the most.)
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
20
×
What kind of chart is this?
Line chart
Oops!
Check
Okay!
Check
×
trap
No points!
Oops!
×
seesaw
Swap points!
Okay!
×
fairy
Take points!
5
10
15
20
25
×
lifesaver
Give 20 points!
Oops!
×
banana
Go to last place!
Oops!
×
shark
Other team loses 20 points!
Okay!
×
gift
Win 5 points!
Okay!
×
baam
Lose 20 points!
Oops!
×
seesaw
Swap points!
Oops!
×
fairy
Take points!
5
10
15
20
25
×
fairy
Take points!
5
10
15
20
25
×
banana
Go to last place!
Oops!
10
×
What does =MEDIAN do?
Find the median (middle) number.
Oops!
Check
Okay!
Check
×
lifesaver
Give 10 points!
Oops!
×
shark
Other team loses 25 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
25
×
What does the =CONCAT function do?
Links together the content of multiple cells
Oops!
Check
Okay!
Check
5
×
What does =SUM do?
Gives the sum of a range.
Oops!
Check
Okay!
Check
15
×
What does =OR do?
Checks a range to see if EITHER condition is true or false
Oops!
Check
Okay!
Check
20
×
What does =NPV do?
Uses a percentage reference to return a net total.
Oops!
Check
Okay!
Check
20
×
What does the =IF function do?
Returns values based on a TRUE or FALSE condition
Oops!
Check
Okay!
Check
15
×
What does the =AND function do?
Returns TRUE or FALSE based on two or more conditions
Oops!
Check
Okay!
Check
15
×
What kind of graph is this?
Pie graph
Oops!
Check
Okay!
Check
×
Restart
Review
Join for Free
;
Your experience on this site will be improved by allowing cookies.
Allow cookies