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
×
seesaw
Swap points!
Oops!
×
gold
Win 50 points!
Okay!
×
gift
Win 20 points!
Okay!
×
baam
Lose 20 points!
Oops!
20
×
What is an ABSOLUTE REFERENCE to cell B15?
$B$15
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
×
baam
Lose 20 points!
Oops!
×
seesaw
Swap points!
Okay!
×
fairy
Take points!
5
10
15
20
25
×
baam
Lose 15 points!
Oops!
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
10
×
To modify a fill color on a shape, simply use this button on the Home tab
Paint Bucket
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 insert high or low point markers into a sparkline, check this in what GROUP on the Design tab?
Show
Oops!
Check
Okay!
Check
15
×
$B$2 is an example of what kind of cell reference?
Absolute
Oops!
Check
Okay!
Check
×
banana
Go to last place!
Oops!
×
seesaw
Swap points!
Okay!
×
fairy
Take points!
5
10
15
20
25
×
banana
Go to last place!
Oops!
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
25
×
To create a running total, use this tool, which pops up when you highlight a range
Quick Analysis
Oops!
Check
Okay!
Check
×
trap
No points!
Oops!
×
gold
Win 50 points!
Okay!
×
fairy
Take points!
5
10
15
20
25
×
baam
Lose 25 points!
Oops!
10
×
Which function is used to find the lowest number in a range?
MIN function
Oops!
Check
Okay!
Check
15
×
What does the TODAY function use in the parenthesis?
nothing - Example =TODAY()
Oops!
Check
Okay!
Check
×
Restart
Review
Join for Free
;
Your experience on this site will be improved by allowing cookies.
Allow cookies