Question 1

Even after selecting a data source for a chart you can still apply various filters on one or more series.

Accepted Answer

After selecting a data source for a chart, you can still apply filters on one or more series to manipulate the data displayed in the chart.

Question 2

The range used for a sparkline cannot include more than one row.

Accepted Answer

A sparkline can be created using data from multiple rows and columns; it is not limited to a single row.

Question 3

A chart style effects the formatting of the chart itself,but not the chart data.

Accepted Answer

The answer of A chart style effects the formatting of...

Question 4

To understand a chart you need to include the chart data.

Accepted Answer

The answer of To understand a chart you need to...

Question 5

Sparklines do not include the normal chart labels.

Accepted Answer

Sparklines are designed to be small, compact graphics that fit within a text block, so they do not include traditional chart labels such as axis labels, legends, or titles.

Question 6

The Chart Styles gallery displays style options for the selected chart only.

Accepted Answer

The Chart Styles gallery displays style options for the selected chart only.

Question 7

Once a data source is selected for a chart,the only way to change the data source is to start over creating the chart.

Accepted Answer

It is possible to change the data source for a chart by selecting the chart, going to the "Design" or "Format" tab in the ribbon, and choosing "Select Data" or "Change Data Source."

Question 8

Excel normally uses all the selected data in creating a chart.

Accepted Answer

This is true. When you create a chart in Excel, by default it will use all the selected data to generate the chart.

Question 9

You can switch the rows and columns in a chart to communicate a different perspective on your data.

Accepted Answer

By switching the rows and columns in a chart, you can change the way the data is presented and highlight different aspects of the information. This can provide a new perspective and improve the audience's understanding of the data.

Question 10

You can link to a cell as the title of a chart.

Accepted Answer

Yes, you can link to a cell and use its contents as the title of a chart in Microsoft Excel. This allows for dynamic and easy updating of chart titles without having to manually update them every time the data changes.

Question 11

Match between columns
                        Premises: Chart element
Chart sheet
Chart title
Chart style
Chart filter

Accepted Answer

The Answer of Decides what is hidden or displayed in is...

Question 12

Match between columns
                        Premises: Radar
X Y (scatter)chart
Area
Combo chart
Histogram

Accepted Answer

The Answer of Used for two different but related data is...

Question 13

Match between columns
                        Premises: Area chart
X Y (scatter)chart
Stock chart
Combo chart
Surface chart

Accepted Answer

The Answer of Combines two chart types and Subtypes include:High-Low-Close,Open-High-Low-Close,Volume-High-Low-Close,and is...

Question 14

Match between columns
                        Premises: Stacked column chart
100% stacked column chart
3-D chart
Clustered column chart
Column chart

Accepted Answer

The Answer of Adds an additional dimension to your chart is...

Question 15

Match between columns
                        Premises: Data point
Data series
Data label
Data table
Legend

Accepted Answer

The Answer of Helps to distinguish between various data series is...

Question 16

Match between columns
                        Premises: Sparkline
Pie chart
Column chart
Bar chart
Line chart

Accepted Answer

The Answer of Line connect data points and Uses vertical is...

Question 17

Match between columns
                        Premises: X-axis
Legend
Plot area
Y-axis
Chart area

Accepted Answer

The Answer of Both axes form a border for this is...

Question 18

Match between columns
                        Premises: Alt Text
Quick Layout
Data labels
Sparklines
Accessibility Compliance

Accepted Answer

The Answer of Helps you use predefined layouts and Can is...

Question 19

Match between columns
                        Premises: Diagonal black triangles
Chart font color
Triangle with white fill
Task pane
Sizing handles

Accepted Answer

The Answer of The default is Black,Text 1,Lighter 35%. and is...

Question 20

Match between columns
                        Premises: Arrange
Alt Text
Exploded pie chart
Chart filter
Parallel range

Accepted Answer

The Answer of One or more pieces are separated from is...

Quiz 3: Charts

Even after selecting a data source for a chart you can still apply various filters on one or more series.

The range used for a sparkline cannot include more than one row.

A chart style effects the formatting of the chart itself,but not the chart data.

To understand a chart you need to include the chart data.

Sparklines do not include the normal chart labels.

The Chart Styles gallery displays style options for the selected chart only.

Once a data source is selected for a chart,the only way to change the data source is to start over creating the chart.

Excel normally uses all the selected data in creating a chart.

You can switch the rows and columns in a chart to communicate a different perspective on your data.

You can link to a cell as the title of a chart.

Match the following terms with their description:

Match the following terms with their description:

Match the following terms with their description:

Match the following terms with their description (since the options are very similar,pick the most complete,descriptive answer):

Match the following terms with their description:

Match the following terms with their description:

Match the following terms with their description:

Match the following terms with their description:

Match the following terms with their description:

Match the following terms with their description: