Excel ch 6
What does Excel not determine about the value axis when you create a chart?
Average value
Which chart type displays the data horizontally?
Bar
What can you not do from the Select Data Source dialog box?
Change chart type
What is not found on the Add Chart Elements List?
Chart Type
Which of the following is not a chart element?
Chart area X, plot area X
Which of the following is not a chart element?
Chart foreground
Which chart type is best when you want to chart two unrelated data types?
Combo chart
What is not true about an effective chart?
It always contains more than one series.
The plot area is surrounded by how many axes?
It depends on the chart type selected. X, 2
What is a disadvantage of a stacked column chart?
There is a limit as to how many segments can be displayed. X, Segments do not start at the same point.
Which of the following is not true about sizing handles?
They always maintain the proper aspect ratio for the object.
In a pie chart which of the following is a good reason for using category data labels, like Data Callout, rather than the legend?
They are easier to read.
Which of the following is not true about trendlines?
They can be added to all chart types.
What should you not select when selecting data for a chart?
Worksheet titles
Which of the following, when included, distorts the effectiveness of charting data points?
aggregates
Which chart type displays the data vertically?
bar X
Which of the following is not a chart type in Excel?
circle
To select nonadjacent ranges press and hold the ________ key while selecting the nonadjacent ranges.
command (for Mac), control, CTRL(for PC)
A stacked column chart displays multiple columns for each category.
false
Including the column and row labels in a chart makes the chart harder to understand.
false
Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart again.
false
To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.
false
To understand a chart, you need to display all the chart data.
false
When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.
false
You can enter data or formulas on a chart sheet.
false
Which chart converts values to percentages?
pie
Which chart type is a visual "dashboard" of your data?
sparkline
Which chart type is not listed in the All Charts window?
sparkline
Effective charts never overwhelm an audience.
true
Excel normally uses all the selected data in creating a chart.
true
It is good practice to delete any blank rows or columns before creating a chart.
true
Pie charts can only display one data series.
true
You can switch the rows and columns in a chart to communicate a different perspective on your data.
true
How many sizing handles are found on embedded charts?
8
What chart type represents data as spokes going from the center to the outer edge of the chart?
Radar
What is not a purpose of using an effective chart?
Reveals even subtle errors in formulas
