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
×
When using a MAX function, what goes in the parenthesis?
The RANGE to find the highest number of with COLON - Example A5:A10
Oops!
Check
Okay!
Check
15
×
Which letter is an example of conditional formatting data bars?
F
Oops!
Check
Okay!
Check
15
×
To modify data labels to show both a percentage and labels, use this
Task Pane (options at right in task pane)
Oops!
Check
Okay!
Check
10
×
To modify a fill color on a shape, simply use this button on the Home tab
Paint Bucket
Oops!
Check
Okay!
Check
15
×
To insert a Sparkline into a group of cells, go to what tab?
Insert
Oops!
Check
Okay!
Check
10
×
If you type Quarter 1 and pull the fill handle over, what happens?
It makes Quarter 2, Quarter 3, etc.
Oops!
Check
Okay!
Check
20
×
How do you insert a trendline in a CHART?
Use the Chart Elements button (+)
Oops!
Check
Okay!
Check
×
banana
Go to last place!
Oops!
×
gold
Win 50 points!
Okay!
×
fairy
Take points!
5
10
15
20
25
×
banana
Go to last place!
Oops!
15
×
What function would you use to calculate the arithmetic mean of a range?
AVERAGE
Oops!
Check
Okay!
Check
15
×
Which letter is an example of Sparklines in trendline form?
G
Oops!
Check
Okay!
Check
25
×
To create a running total, use this tool, which pops up when you highlight a range
Quick Analysis
Oops!
Check
Okay!
Check
10
×
To add Solid Fill Red Data Bars to a range, what tab has the Conditional Formatting button?
Home
Oops!
Check
Okay!
Check
20
×
Inside the parenthesis of an IF function, what is the first item in the parenthesis?
logical test that compares (like A5>100)
Oops!
Check
Okay!
Check
×
heart
Other team wins 10 points!
Oops!
×
rocket
Go to first place!
Okay!
×
shark
Other team loses 25 points!
Okay!
×
lifesaver
Give 10 points!
Oops!
10
×
Which function is used to find the lowest number in a range?
MIN function
Oops!
Check
Okay!
Check
×
lifesaver
Give 20 points!
Oops!
×
rocket
Go to first place!
Okay!
×
shark
Other team loses 25 points!
Okay!
×
baam
Lose 10 points!
Oops!
×
Restart
Review
Join for Free
;
Your experience on this site will be improved by allowing cookies.
Allow cookies