MASTERING EXCEL CHARTS- SECTION 05 REVIEW QUIZ

True or False? Treemaps and Sunburst Charts have multiple sub-chart types.

True

False

Incorrect, that statement is false. Treemap and Sunburst Charts have no sub-chart types.

Correct! That statement was false. Treemap and Sunburst Charts do not have any sub-chart types.

When viewing an uptrend on a graph, what's the best action for a company to take?

Make the trendline a bold color

Print the graph

Find out what is happening fast and correct it

Investigate. Find out what was implemented or changed, essentially what caused the uptrend, and continue to do those actions

Incorrect. You can make the trendline a bold color but that's not the best action for a company to take in this situation.

Incorrect. You can print a copy of this graph but that's not the best action for a company to take in this situation.

No, when viewing an uptrend on a graph, you do not need to correct anything.

Correct! The best action for a company to take when viewing an uptrend on a graph is to investigate. Find out what was implemented or changed, essentially what caused the uptrend, and continue to do those actions!

What sub-chart types are available for an AREA CHART?

Stacked Area Chart

100% Stacked Area Chart

3-D Area, 3-D Stacked, and 3-D 100% Stacked

All of the above

Your answer is Incorrect. A Stacked Area chart is a sub-chart type for an AREA CHART, but there are more! Restudy lesson 5: AREA CHARTS.

Your answer is Incorrect. A 100% Stacked Area Chart is a sub-chart type for an AREA CHART, but there are more! Restudy lesson 5: AREA CHARTS.

Incorrect. 3-D Area, 3-D Stacked, and 3-D 100% Stacked are sub-chart types for an AREA CHART, but there are more! Restudy lesson 5: AREA CHARTS.

Correct! The sub-type charts for an AREA CHART are Stacked Area Chart, 100% Stacked Area Chart, 3-D Area, 3-D Stacked, and 3-D 100% Stacked.

What can you do to help Excel’s charting technology better recognize what you want?

Turn the raw data into a table before creating a chart

Move the raw data to its own worksheet

Create lots of chart templates

Correct! Before creating a chart, turn your raw data into a table. This will help Excel’s charting technology better recognize what you want.

Incorrect. Moving raw data to its own worksheet will not help Excel’s charting technology better recognize what you want.

Incorrect. Creating lots of templates is a neat idea but it will not help Excel’s charting technology better recognize what you want.

Which chart shows the values relative to a center point?

XY Scatter Chart

Radar chart

Histogram Chart

Treemap

Incorrect. A XY Scatter Chart plots points showing the relationship between two types of data.

Correct! A radar chart shows the values relative to a center point.

Incorrect. A histogram chart is a graphical display where the data is grouped into ranges.

Incorrect. A treemap is a specialized chart of hierarchical data with the main branches displayed as large rectangles, and the sub-limbs branching out into smaller rectangles.

MASTERING EXCEL CHARTS- SECTION 05 REVIEW QUIZ

More Quizzes