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 function would you use to calculate the arithmetic mean of a range?
AVERAGE
Oops!
Check
Okay!
Check
10
×
Which function is used to find the lowest number in a range?
MIN function
Oops!
Check
Okay!
Check
20
×
Goal Seek is located in what command on the Data tab?
What-if Analysis
Oops!
Check
Okay!
Check
×
banana
Go to last place!
Oops!
×
star
Double points!
Okay!
×
rocket
Go to first place!
Okay!
×
thief
Give points!
5
10
15
20
25
×
seesaw
Swap points!
Oops!
×
gold
Win 50 points!
Okay!
×
shark
Other team loses 15 points!
Okay!
×
lifesaver
Give 15 points!
Oops!
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
×
To change the text direction of an axis title, where can you rotate the title?
Format Axis Title in the task pane for Text Direction
Oops!
Check
Okay!
Check
×
trap
No points!
Oops!
×
gold
Win 50 points!
Okay!
×
rocket
Go to first place!
Okay!
×
baam
Lose 25 points!
Oops!
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
20
×
How do you insert a trendline in a CHART?
Use the Chart Elements button (+)
Oops!
Check
Okay!
Check
20
×
To remove an entire data series from a chart (like take off 2017's number), use which button on Design tab?
Uncheck it in Select Data
Oops!
Check
Okay!
Check
×
boom
Lose 50 points!
Oops!
×
gift
Win 25 points!
Okay!
×
shark
Other team loses 25 points!
Okay!
×
banana
Go to last place!
Oops!
15
×
B$2 is an example of what kind of cell reference?
Mixed (the row 2 would stay put, but B would move since only one $)
Oops!
Check
Okay!
Check
15
×
Which letter is an example of conditional formatting data bars?
F
Oops!
Check
Okay!
Check
15
×
What does the TODAY function use in the parenthesis?
nothing - Example =TODAY()
Oops!
Check
Okay!
Check
20
×
To define 20.0 as the Major units and 5.0 as the Minor units for a secondary axis,
Axis Options in task pane - UNITS (not Bounds - that the high and low)
Oops!
Check
Okay!
Check
×
Restart
Review
Join for Free
;
Your experience on this site will be improved by allowing cookies.
Allow cookies