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
×
baam
Lose 15 points!
Oops!
×
seesaw
Swap points!
Okay!
×
gift
Win 20 points!
Okay!
×
baam
Lose 25 points!
Oops!
20
×
Goal Seek is located in what command on the Data tab?
What-if Analysis
Oops!
Check
Okay!
Check
20
×
This feature is used to calculate how you can get to a number by changing a specific cell
Goal Seek
Oops!
Check
Okay!
Check
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
20
×
How do you insert a trendline in a CHART?
Use the Chart Elements button (+)
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
×
To add Solid Fill Red Data Bars to a range, what tab has the Conditional Formatting button?
Home
Oops!
Check
Okay!
Check
×
boom
Lose 50 points!
Oops!
×
gift
Win 10 points!
Okay!
×
gift
Win 20 points!
Okay!
×
banana
Go to last place!
Oops!
15
×
$B$2 is an example of what kind of cell reference?
Absolute
Oops!
Check
Okay!
Check
×
baam
Lose 10 points!
Oops!
×
seesaw
Swap points!
Okay!
×
rocket
Go to first place!
Okay!
×
banana
Go to last place!
Oops!
15
×
What does the TODAY function use in the parenthesis?
nothing - Example =TODAY()
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
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
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
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
10
×
To modify a fill color on a shape, simply use this button on the Home tab
Paint Bucket
Oops!
Check
Okay!
Check
×
Restart
Review
Join for Free
;
Your experience on this site will be improved by allowing cookies.
Allow cookies
