BUSI 520 Chapter 3
The Radar chart type compares _____.
values across categories in a circular orientation
A(n) ______ chart combines the features of a line chart with a bar or column chart by filling in the part below the line
Area
The ______ chart displays a main Pie chart with user-defined values in a second Stacked Bar chart.
Bar of Pie
The _____ chart compares sets of three values with the third value displayed as the size of a marker.
Bubble
The _____ chart type compares sets of three values indicated by filled circles.
Bubble
The Chart Option of _____ displays a grid of all the actual numeric values for each data series.
Data Table
The chart type of _____ compares the contribution each value in multiple numeric data series makes to the whole as indicated in segments.
Doughnut
3D column charts are typically much easier to interpret than plain-jane 2D column charts.
False
A chart that displays the Volume-Open-High-Low-Close is a Bar chart.
False
Adding a lot of illustration and decoration to a chart usually enhances the view of the data.
False
The ranges shown highlighted in yellow are the correct ranges to select when creating a stacked column chart to compare the software sales for Denver and Boston.
False
To display Stock prices in Excel, use a Column chart.
False
To display pairs of values with data points connected by lines, use a column chart.
False
Using legends to clarify a pie chart's data is preferable to using data labels.
False
When creating a stacked column chart, don't forget to select the totals associated with the data to be charted.
False
When selecting data to create a Pie chart, to make the chart most clear, the total column or row within the table should be selected in addition to the individual sectors.
False
In the Pie of Pie sub type chart, the _____ option allows you to include exactly the segments you want in the main pie chart and second plot.
Format Data Series
The _____ chart displays a main Pie chart with user-defined values extracted and combined into a second Pie plot.
Pie of Pie
A Line chart displays a trend over time or categories.
True
It is possible to show a Bar chart as a sub-chart of a Pie chart.
True
It is possible to use a SUM function to SUM values across individual worksheets.
True
Showing too many Chart Options can cause problems with generating excessive "ink" that obscures the information in the chart.
True
Using legends in a stacked column chart are usually necessary.
True
When choosing the chart type, be careful to not accidentally select the 100% stacked column, as this chart type is typically not the appropriate stacked column chart to use.
True
When creating a stacked column chart, you should include the column and row headings when selelcting the range of data to be charted.
True
The legend is the _____.
box that identifies the colors assigned to the data series
When creating a stacked column chart, to swap the information in the legend with the info on the x-axis, ______
click the "Switch Row/Column" button
The Radar chart _____.
displays the trend of values over time or categories relative to a center point
The 100% Stack Area chart displays the trend of the _____.
percentage each value contributes over time or categories
The first thing to do when creating an Excel chart is to _____.
select the data to be used for the chart
