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
×
banana
Go to last place!
Oops!
×
gold
Win 50 points!
Okay!
×
gift
Win 15 points!
Okay!
×
banana
Go to last place!
Oops!
15
×
What does the button look like on the chart to apply a chart style?
Paint Brush
Oops!
Check
Okay!
Check
15
×
To fill with "formatting only" what must you do AFTER you pull the fill handle down?
Use the autofill options button that pops up and say "fill formatting only"
Oops!
Check
Okay!
Check
10
×
Which function is used to find the lowest number in a range?
MIN function
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
10
×
If you press the + Chart Elements button when on a chart, how can you remove the legend?
Uncheck Legend
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
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
×
eraser
Reset score!
Oops!
×
rocket
Go to first place!
Okay!
×
gift
Win 10 points!
Okay!
×
banana
Go to last place!
Oops!
20
×
In this, what does the ZERO represent? =ROUND(K9,0)
The number of decimal places
Oops!
Check
Okay!
Check
10
×
To copy a formula down a column, click the cell and then pull this.
Fill handle
Oops!
Check
Okay!
Check
×
boom
Lose 50 points!
Oops!
×
fairy
Take points!
5
10
15
20
25
×
fairy
Take points!
5
10
15
20
25
×
thief
Give points!
5
10
15
20
25
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
×
If you see a cells with blue fills of varying lengths representing the values, the cells most likely have this applied:
Conditional Formatting (with Data Bars)
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
×
Restart
Review
Join for Free
;
Your experience on this site will be improved by allowing cookies.
Allow cookies
