Question 1

As a general rule,Pie charts should be limited to how many slices?
A)5
B)7
C)9
D)11

Accepted Answer

Pie charts are most effective with around 5 to 7 slices, as this allows for easy comparison and clarity. Beyond this range, the chart can become cluttered and difficult to interpret.

Question 2

In the Insert Chart dialog box,after you pick a chart type where are the subtypes listed?
A)Bottom left
B)Bottom right
C)Top left
D)Top right

Accepted Answer

D

Question 3

Which axis in a chart displays incremental numbers for the data points?
A)Category
B)Value
C)Data
D)Series

Accepted Answer

The axis that displays incremental numbers for the data points is called the value axis. This axis is used to show the quantitative values of the data being represented in the chart. The other options listed do not pertain to displaying incremental numbers. The category axis displays the categories or labels for the data points, the data axis is not a commonly used term in charting, and the series axis represents different series of data in the chart.

Question 4

Which of the following is not a chart type?
A)Circle
B)Pie
C)Bar
D)Line

Accepted Answer

Circle is not a chart type commonly used in data visualization. Pie, bar, and line charts are some of the most common types of charts used in data visualization.

Question 5

What should you not select when selecting data for a chart?
A)Column labels
B)Row labels
C)Data
D)Worksheet titles

Accepted Answer

Worksheet titles should not be selected when selecting data for a chart as they are not part of the actual data and including them in the chart can create confusion and clutter.

Question 6

What is a disadvantage of a stacked column chart?
A)Segments do not start at the same point.
B)Segments do not end at the same point.
C)There is a limit as to how many segments can be displayed.
D)This is only useful for one data series.

Accepted Answer

Segments in a stacked column chart do not start at the same point, which can make it difficult to accurately compare the sizes of the segments. This can be particularly problematic when using the chart to display data with wide variation in values.

Question 7

Where does the primary axis display on a Combo chart?
A)Top
B)Bottom
C)Right side
D)Left side

Accepted Answer

The answer of Where does the primary axis display on...

Question 8

Where does Excel display the Quick Analysis tool?
A)Bottom-right corner
B)Top-right corner
C)Bottom-left corner
D)Top-left corner

Accepted Answer

Excel displays the Quick Analysis tool in the bottom-right corner.

Question 9

Which tab displays the tools for creating charts?
A)View
B)Chart
C)Insert
D)Data

Accepted Answer

The Insert tab contains the tools for creating charts in Microsoft Excel.

Question 10

How many variations of the stock chart does Excel have?
A)1
B)2
C)3
D)4

Accepted Answer

The answer of How many variations of the stock chart...

Question 11

Which of the following is not a chart element?
A)Chart area
B)Plot area
C)Legend
D)Data area

Accepted Answer

The chart elements commonly include chart area, plot area, legend, data labels, data table, horizontal/vertical axis, and series (or data points). However, there is no such element called data area in a standard chart.

Question 12

Including what,distorts the effectiveness of charting data points?
A)Too many series
B)Too many data points
C)Too much variance in the values of the data
D)Aggregates

Accepted Answer

The answer of Including what,distorts the effectiveness of charting data...

Question 13

Which chart type is not listed in the All Charts window?
A)Treemap
B)Sparkline
C)Histogram
D)Waterfall

Accepted Answer

Sparkline chart is not listed in the All Charts window. The Treemap, Histogram, and Waterfall charts are available options in the All Charts window.

Question 14

Which chart type is best when you want to chart two unrelated data types?
A)Pie chart
B)Combo chart
C)Line chart
D)Radar chart

Accepted Answer

A combo chart allows for two unrelated data types to be displayed together in a single chart by using different chart types, such as a column chart and a line chart. This makes it easier to compare and analyze the two sets of data. Pie charts, line charts, and radar charts are not ideal for displaying unrelated data types.

Question 15

A 100% stacked column chart is similar to what other chart in that it converts values to percentages?
A)Clustered column
B)Radar
C)Line
D)Pie

Accepted Answer

A 100% stacked column chart is similar to a pie chart in that it converts values to percentages. In both charts, the total of all categories equals 100%.

Question 16

What chart type represents data as spokes going from the center to the outer edge of the chart?
A)Surface
B)Area
C)Radar
D)Histogram

Accepted Answer

A radar chart is the only chart type that represents data as spokes radiating from the center to the outer edge of the chart. The other options (surface, area, and histogram) all use different methods to visually represent data.

Question 17

What is not a purpose of using an effective chart?
A)Compares data
B)Reveals trends and patterns
C)Reveals even subtle errors in formulas
D)Aids in making informed decisions

Accepted Answer

Effective charts are primarily used for comparing data, revealing trends and patterns, and aiding in making informed decisions. They are not designed to reveal subtle errors in formulas; that task is more directly addressed through data auditing and formula checking tools within data processing software.

Question 18

Which axis in a chart displays the descriptive labels for the data points?
A)Category
B)Value
C)Data
D)Series

Accepted Answer

The category axis is where the descriptive labels for the data points are displayed, such as the names of different products or time periods. The value axis, on the other hand, displays the numerical values of the data points. The data axis and series axis are not commonly used terms in the context of charting.

Question 19

Which chart type is preferable when the category names are long?
A)Column
B)Bar
C)Pie
D)Stacked column

Accepted Answer

When the category names are long, a bar chart is usually preferable because it allows for better readability of categories without having to tilt the axis or rearrange the categories. In contrast, in a column chart, long category names may be truncated or difficult to read.

Question 20

What is not true about an effective chart?
A)It always contains more than one series.
B)It is clear.
C)It is easy to understand.
D)It is useful.

Accepted Answer

An effective chart may contain only one series, depending on the information being presented.

Quiz 3: Charts

As a general rule,Pie charts should be limited to how many slices?

In the Insert Chart dialog box,after you pick a chart type where are the subtypes listed?

Which axis in a chart displays incremental numbers for the data points?

Which of the following is not a chart type?

What should you not select when selecting data for a chart?

What is a disadvantage of a stacked column chart?

Where does the primary axis display on a Combo chart?

Where does Excel display the Quick Analysis tool?

Which tab displays the tools for creating charts?

How many variations of the stock chart does Excel have?

Which of the following is not a chart element?

Including what,distorts the effectiveness of charting data points?

Which chart type is not listed in the All Charts window?

Which chart type is best when you want to chart two unrelated data types?

A 100% stacked column chart is similar to what other chart in that it converts values to percentages?

What chart type represents data as spokes going from the center to the outer edge of the chart?

What is not a purpose of using an effective chart?

Which axis in a chart displays the descriptive labels for the data points?

Which chart type is preferable when the category names are long?

What is not true about an effective chart?