Excel Chapter 3
Where does Excel display the Quick Analysis tool?
Bottom-right corner
Which axis in a chart displays the descriptive labels for the data points?
Category
Which of the following is not a chart element?
Chart Foreground
What icon is not displayed when you select a chart?
Chart Types
What is not found on the Chart Elements List?
Chart type
Which chart type displays the data vertically?
Column
Which chart type is best when you want to chart two unrelated data types
Combo chart
Which of the following is not a chart element?
Data area
What group is not found on the Sparkline Tools Design tab?
Format
Which chart element cannot be chosen from the Chart Elements dialog box?
Format Back Wall
What is not true about an effective chart?
It always contains more than one series.
In a pie chart which of the following is a good reason for using category data labels rather than the legend?
They are easier to read.
In the Insert Chart dialog box, after you pick a chart type where are the subtypes listed?
Top right
What should you not select when selecting data for a chart?
Worksheet titles
What does Excel not determine about the value axis when you create a chart?
average value
Which chart type displays the data horizontally?
bar
Which chart type is preferable when the category names are long?
bar
Which chart type cannot be displayed as a sparkline?
bar chart
What can you not do from the Select Data Source dialog box?
change chart type
Which group on the Design tab would you select if you wanted to change the source information in the chart?
data
Where does the primary axis display on a Combo chart?
left side
What chart type represents data as spokes going from the center to the outer edge of the chart?
radar
Which chart type is a visual "dashboard" of your data?
sparkline
Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline?
sparkline
Which axis in a chart displays incremental numbers for the data points?
value
In a bar chart, which axis displays the categories?
vertical
Including what, distorts the effectiveness of charting data points?
Aggregates
As a general rule, Pie charts should be limited to how many slices?
7
How many sizing handle are found on embedded charts?
8
In the task pane, what does a diagonal white triangle next to a chart category indicate?
None of the category's options are displayed.
A 100% stacked column chart is similar to what other chart in that it converts values to percentages?
Pie
What is not a purpose of using an effective chart?
Reveals even subtle errors in formulas
What is a disadvantage of a stacked column chart?
Segments do not start at the same point.