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.
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.
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 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.
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.
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!
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 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.
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.
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.
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.
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. 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.
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.
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.
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 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.
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.
{"name":"MASTERING EXCEL CHARTS- SECTION 05 REVIEW QUIZ", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Basics of Tax Course, What is your full name?, What color is an orange?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
More Quizzes
Quiz ng Isang Shahida
1586
Plural and Singular Nouns
6315
Christmas
16829
NTBs språkkviss 2/17
630
Virgin Islands History
320
World Otter Day 2020
8427
Test
210
PROCESOS NEUROLOGICOS DEL LENGUAJE
492423
Deforestation
1160
How do you feel about Workington? - Geography NEA
1580
Discover Your True Self: The Fun Quiz
10517
ItsTeamRyan Ultimate Fan
1586