Excel CH3
Where does the primary axis display on a combo chart?
Left side
What font color does excel use by default for many of its elements
Black, text 1, lighter 35%
In the Insert Chart dialog box, after you pick a chart type where rare the subtypes listed?
Top Right
in a bar chart, which axis displays the categories
Vertical
including what, distorts the effectiveness of charting data points?
aggregates
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
what chart type cannot be displayed as a sparkline?
bar chart
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
what can you NOT do from the select data source dialog box?
change chart type
Which of the following is NOT a chart element?
chart foreground
what is not found on the chart elements list?
chart type
what icon is not displayed when you select a chart?
chart types
which of the following is not a chart type?
circle
which chart types displays the data vertically?
column
what chart type can display two different chart types at the same time?
combo
Which chart type is best when you want to chart two unrelated data types?
combo chart
which group on the design tab would you select if you wanted to change the source information in the chart?
data
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
which tab displays the tools for creating charts?
insert
What is NOT true about an effective chart?
it always contains more than one series
in the take pane, what does a diagonal which triangle next to a chart category indicate?
none of the category's options are displayed
in the task pane, what does a diagonal black triangle next to a chart category indicate?
none of the category's options are displayed
what chart type represents data as spokes going from the center to the outer edge of the chart?
radar
what is a disadvantage of a stacked column chart?
segments do not start at the same point
which chart type is NOT listed in the All Charts window?
sparkline
which chart type is a visual "dashboard" of your data?
sparkline
which group on the sparkline tools design tab would you choose is you wanted to change the data source of the sparkline?
sparkline
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
Which axis in a chart displays incremental numbers for the data points?
value
What should you NOT select when selecting data for a chart?
worksheet titles
how many variations of the stock chart does Excel have?
4
as a general rule, Pie charts should be limited to how many slices?
7
how many sizing handle are found on embedded charts?
8
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