Microsoft Module 7
Which of the following can you add using Quick Analysis?
A chart A color scale A trendline
Which of the following terms refers to a row or column of data in a worksheet that is plotted in a chart?
A data series
Which data arrangement is ideal for a pie chart?
A single row or column of data.
Where are Totals calculations placed when added using the Quick Analysis feature?
Adjacent to the data range
What happens if multiple conditional formatting rules are applied to the same cell?
All rules are applied in order, formatting the cell with every rule.
Conditional formatting uses a condition to determine a cell's
Appearance
Where can you access Chart Styles?
As a button to the right of a selected chart. In the Chart Tools Design tab in the ribbon.
Which of the following best describes the role of Alt Text?
Assists users with a screen reader who are accessing the workbook.
A Microsoft Excel chart can contain the following titles:
Axis title(s) Chart title(s)
How can you find the name of a predefined chart layout?
By hovering over a selection in the gallery
Which of the following cannot be added using Quick Analysis?
Cell Styles
What does the Switch Row/Column button do?
Change the orientation of axes in a chart.
A Microsoft Excel chart is made up of multiple ________________________ which can be added, removed, and modified to customize the chart.
Chart Elements
A ___________________________ rearranges chart elements but does not alter their appearance.
Chart Layout
Which of the following statements is true of Quick Analysis charts?
Chart type choices vary depending on the selection.
Conditional formatting with the _________________________ option will shade every selected cell based on how its value compares to the average.
Color Scales
Which of the following conditional formatting rules is the best option for emphasizing the variance between values in a data range?
Color scales
Which of the following options are types of conditional formatting?
Color scales Data bars Highlight cells rules
Excel offers predefined _____________________________ for charts rather than forcing you to pick individual colors.
Color schemes
What are the different chart types for sparklines?
Column Line Win/Loss
Which chart element displays details about a data series and/or individual data points?
Data Labels
A _______________________________ is a row or column of numbers in a worksheet that are plotted in a chart.
Data Series
Which chart element displays a grid of the chart's underlying data?
Data Table
Which of the following terms describes a grid at the bottom of a chart that displays the values represented in the chart?
Data Table
Visual elements that do not contain any information should be marked as
Decorative
Which of the following values can be indicated using conditional formatting?
Duplicate Values High or Low Values
You can disable the Quick Analysis feature from the ________________________ window.
Excel Option
____________________________ make a chart easier to read by providing regularly spaced reference lines for comparison.
Gridlines
By default, related sparklines are managed together in a
Group
Which of the following options is used to emphasize the largest value in a data series?
High point
You can indicate positive, negative, or neutral values with icons by using
Icon Sets
3 Signs is an option for the _______________________________ conditional formatting rule.
Icon sets
How does Excel determine what data to use when creating a chart?
It uses only the selected cells.
A ______________________________ is an arrangement of chart elements within a chart.
Layout
Which features can be used to remove conditional formatting?
Manage Rules
Which of the following options can you use to emphasize data points on a sparkline?
Markers
To remove a chart from the current worksheet and place it on a newly created worksheet, use the _______________________________ dialog box.
Move Chart
Which of the following can be done with the Move Chart dialog box?
Move a chart to an existing worksheet Move a chart to a new worksheet.
Which of the following are NOT changed when you select a style?
The position of elements
Which of the following statements is true about predefined chart layouts?
They arrange the position of chart elements.
Which of the following explanations are reasons to switch the rows and columns on a chart?
To check if you prefer to orient the chart differently. To correct a pie chart that is only displaying a category name.
A _____________________________ indicates the general pattern of a data series.
Trendline
To modify an individual sparkline, you must first ______________________ it.
Ungroup
You added data to the worksheet after the chart was created. Why might you need to add more data to a chart?
You added data to the worksheet after the chart was created.
Use a predefined _________________________ to quickly modify settings related to the appearance of sparklines.
Style or Quick Style
Which of the following options allow you to modify chart elements?
The Chart Tools Ribbon The Data tab on the Ribbon The Format task pane
The ___________________________ chart type emphasizes the difference between positive and negative values in the data series.
The ___________________________ chart type emphasizes the difference between positive and negative values in the data series.
What is the preferred length of Alt Text?
One or two sentences
Which of the following options best describes the role of the Quick Analysis feature?
Quickly generate totals and visualizations
If you want Microsoft Excel to suggest a chart for your data, use the __________________________ feature.
Recommended Chart
What is the effect of marking a graphic element as "decorative"?
Screen readers will notify users that it doesn't contain information.
The ____________________________ button allows you exclude some data from a chart.
Select Data
How can you access the Quick Analysis tool?
Select a range of cells.
The Select Data Source dialog box allows you to do which of the following?
Select an entirely new range of data.
