Conditional Formatting
Name a way conditional formatting can visually change a cells appearance
Data Bars
Color Scales (highlights)
Icon Sets
In what tab do you create new charts?
Insert tab
Why are sparklines so unique?
They are graphs that can fit in a single cell.
What do you need to do in order for the quick analysis icon to appear?
Select a range
What is the name of the area in an excel chart where the data is plotted?
Plot area
What is the command called used to remove all conditional formatting rules?
Clear Rules
What is the command which suggests charts based off selected data?
Recommended charts
What are sparklines typically used for?
Similar to a line graph, sparklines are used for showing change in data over time. Typically data in a single row.
What are 3 tabs available in the quick analysis window?
Formatting
Charts
Totals
Tables
Sparklines
Which chart element displays the names of the data series in an excel chart?
The legend
What group is the conditional formatting command in?
Styles
What chart style would be most effective at presenting changing data over time?
Line Chart
What are two different types of spark lines?
Line
Column
Win/Loss
In what tab of the quick analysis window can you access the average command?
Totals tab
What does the button to open the chart elements window look like?
A green plus sign to the right of a chart.
Besides the conditional formatting command what other ways are there to insert a conditional formatting rule?
Quick Analysis Tool
What is the effect of marking a chart as decorative?
Screen readers will notify users that it doesn’t contain relevant/important information.
What is the difference between data range and location range in the sparkline dialogue box?
The data range is used to indicate the range of data to be represented by the sparkline, the location range is the position in which the sparkline will occupy.
What types of sparklines can you insert from the quick analysis window?
Line
Column
Win/Loss
What chart element option enables labels for axes?
Axis titles option
What type of rule would be used to highlight the top 10 rows?
Top/Bottom Rule
How do you move a preexisting chart to another worksheet?
Select The Chart -> Chart Design Tab -> Location Group -> Move Chart
What are 4 options available in the "show" group in the sparkline's design tab?
High Point
Low Point
Negative Points
First Point
Last Point
Markers
In what tab and group of the excel options can you disable and enable the quick analysis window from?
General tab, User interface options
Name 3 options available in chart elements tool
Axes
Axis Titles
Chart Title
Data Labels
Data Table
Gridlines
Legend