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 $)
If you press the + Chart Elements button when on a chart, how can you remove the legend?
Uncheck Legend
Which letter is an example of conditional formatting data bars?
F
This feature is used to calculate how you can get to a number by changing a specific cell
Goal Seek
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
Goal Seek is located in what command on the Data tab?
What-if Analysis
What does the button look like on the chart to apply a chart style?
Paint Brush
To add Solid Fill Red Data Bars to a range, what tab has the Conditional Formatting button?
Home
To create a running total, use this tool, which pops up when you highlight a range
Quick Analysis
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"
What is an ABSOLUTE REFERENCE to cell B15?
$B$15
To insert high or low point markers into a sparkline, check this in what GROUP on the Design tab?
Show
How do you insert a trendline in a CHART?
Use the Chart Elements button (+)
If you want both a Clustered Column AND a Line chart in one, you create this type of chart
Combination
What function would you use to calculate the arithmetic mean of a range?
AVERAGE
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
In this, what does the ZERO represent? =ROUND(K9,0)
The number of decimal places
To modify a fill color on a shape, simply use this button on the Home tab
Paint Bucket
Which function is used to find the lowest number in a range?
MIN function
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)
When using a MAX function, what goes in the parenthesis?
The RANGE to find the highest number of with COLON - Example A5:A10
Looking at the image, is E identifying the primary or secondary axis?
secondary
Which letter is an example of Sparklines in trendline form?
G
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)
To insert a Sparkline into a group of cells, go to what tab?
Insert
Inside the parenthesis of an IF function, what is the first item in the parenthesis?
logical test that compares (like A5>100)
To copy a formula down a column, click the cell and then pull this.
Fill handle
If you type Quarter 1 and pull the fill handle over, what happens?
It makes Quarter 2, Quarter 3, etc.
To modify data labels to show both a percentage and labels, use this
Task Pane (options at right in task pane)
$B$2 is an example of what kind of cell reference?
Absolute
What does the TODAY function use in the parenthesis?
nothing - Example =TODAY()