Question 1

Match between columns
                        Premises: Specifies which elements are included in a chart and where they are placed.
A graphical representation of data.
A separate sheet in the workbook that stores a chart.
Formats the chart based on the colors, fonts, and effects associated with the workbook's theme.
The entire chart and all other chart elements.

Accepted Answer

The Answer of Chart style and Chart sheet and Chart is...

Question 2

A(n) ____________________ chart uses bars of varying heights to illustrate values in a worksheet.

Accepted Answer

The answer of A(n) ____________________ chart uses bars of varying...

Question 3

You can show a variety of data markers on sparklines, including the high and low points, negative point, first and last points, and all data points. These options are available in the ____________________ group.

Accepted Answer

The answer of You can show a variety of data...

Question 4

You can pull one or more slices away from the pie to distinguish them, creating what is called a(n) ____________________ pie chart.

Accepted Answer

The answer of You can pull one or more slices...

Question 5

A(n) ____________________ is a group of related information in a column or row of a worksheet that is plotted on the chart.

Accepted Answer

The answer of A(n) ____________________ is a group of related...

Question 6

What is the difference between a data marker and a data label? Please describe a situation where you would use both at the same time.

Accepted Answer

The answer of What is the difference between a data...

Quiz 14: Excel Lesson 8: Working With Charts

Identify the letter of the choice that best matches the phrase or definition.

A(n) ____________________ chart uses bars of varying heights to illustrate values in a worksheet.

You can show a variety of data markers on sparklines, including the high and low points, negative point, first and last points, and all data points. These options are available in the ____________________ group.

You can pull one or more slices away from the pie to distinguish them, creating what is called a(n) ____________________ pie chart.

A(n) ____________________ is a group of related information in a column or row of a worksheet that is plotted on the chart.

What is the difference between a data marker and a data label? Please describe a situation where you would use both at the same time.