BUSI 520 Chapter 3

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

Infection prevention and control (ch. 28)

View Set

Topic Test Test Review Complete 100%

View Set

Computerized Tomography Scan Parameters

View Set

Abeka 6th Grade, Scienct Test 4,(Ch. 1-2)

View Set

Q1 (10%) Prematurity/Special Needs

View Set

Chapter 8: Other Fire Prevention Functions

View Set