Question 1

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Compares three sets of values in a three-dimensional chart

Accepted Answer

A surface chart is the only chart type that can display three sets of values in a three-dimensional chart.

Question 2

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Displays stock market data

Accepted Answer

The chart type that best displays stock market data is the stock chart, which shows changes in a stock's price over time.

Question 3

The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.

Accepted Answer

The DESIGN and FORMAT tabs are the contextual tabs that appear on the Ribbon when a chart is selected. The INSERT tab is a default tab that appears on the Ribbon for inserting various objects into your document, not specifically for chart editing. Similarly, the PRINT tab is for printing options and not for chart editing. Therefore, Option B is the correct answer.

Question 4

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Compares values from different categories.A value is indicated by the height of each ____.

Accepted Answer

A Column chart compares values from different categories, with the value indicated by the height of each column.

Question 5

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Compares values from different categories.Areas under the lines contain a fill color

Accepted Answer

The chart type that best matches the phrase "compares values from different categories" and "areas under the lines contain a fill color" is the area chart or J.

Question 6

-Referring to the figure above,if you were to create a Wine Production Chart pie chart using the information in B28:C34,the data source for that chart would be ____.

Accepted Answer

The data source for a pie chart should include both the category labels (in column B) and the corresponding values (in column C). Therefore, the correct data source is B29:C34.

Question 7

A ________ contains the actual values that are plotted on the chart

Accepted Answer

Data series are the actual values that are plotted on the chart. Each data series is a set of data points that are grouped together to be plotted on the chart. The other options are not directly related to the actual values on the chart. The data source is where the data is coming from, category values are used to categorize the data, and the legend is used to explain what each data series represents.

Question 8

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Compares relative values of different categories to the whole.A value is indicated by the area of a(n)____

Accepted Answer

A pie chart compares relative values of different categories to the whole, with each slice representing a proportion of the total.

Question 9

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Compares a collection of values from several different data sets.

Accepted Answer

Radar charts are used to compare a collection of values from several different data sets.

Question 10

Category values are usually located in the ____ of the data source.

Accepted Answer

Category values are typically found in either the first row or the first column of a data source, as they often represent headers or labels for the data.

Question 11

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

Accepted Answer

The Move Chart dialog box allows users to move charts between different worksheets and chart sheets. It provides options for selecting the target worksheet or chart sheet and choosing whether to create a new sheet or use an existing sheet. The Insert New and Change Chart options are not related to moving charts between sheets, while the Tab option is not a dialog box but a graphical interface element used to switch between sheets.

Question 12

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

Accepted Answer

A pie chart is specifically designed to show the relative proportions of different categories to the whole, making it ideal for comparing parts to a whole.

Question 13

To add and remove chart elements,you can use the Add Chart Element button in the Charts Layout group on the ____ tab.

Accepted Answer

The answer of To add and remove chart elements,you can...

Question 14

-In the figure above,the biggest slice is the cases of _______.

Accepted Answer

Chardonnay is the biggest slice in the figure, indicating it has the largest number of cases.

Question 15

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Shows patterns or relationship between two or more sets of values.Often used in scientific studies and statistical analyses.

Accepted Answer

Scatter plots are used to show patterns or relationships between two or more sets of values, often used in scientific studies and statistical analyses.

Question 16

In the lower right corner,below C34,the _____ tool displays.

Accepted Answer

The Quick Analysis tool allows users to quickly access and analyze their data through various formatting and calculation options. It appears in the lower right corner below cell C34.

Question 17

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Compares values from different categories.A value is indicated by the length of the ____

Accepted Answer

The definition describes the bar chart type which compares values from different categories and indicates the value by the length of the bars.

Question 18

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Similar to a Scatter chart

Accepted Answer

The XY chart is similar to a Scatter chart as both use two axes to represent data points.

Question 19

MATCHING
Identify the letter of the chart type that best matches the phrase or definition.
-Often used to show trends and changes over time

Accepted Answer

A line chart is commonly used to show trends and changes over time.

Possible other answers:
Answer: A
 A scatter chart can also show trends and changes over time if the data points are plotted in a chronological order.

Answer: H
 A bar chart can also be used to show changes over time if the bars represent a time period (e.g. months or years) and the height of the bars represents the value.

Question 20

Placing a chart in a ____ displays only the chart and no worksheet cells.

Accepted Answer

A chart sheet is a separate sheet in a workbook that only displays the chart, without any accompanying worksheet cells. This makes it easier to focus on the chart and present it as a standalone visualization.

Quiz 4: Analyzing and Charting Financial Data

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares three sets of values in a three-dimensional chart

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Displays stock market data

The ____ CHART TOOLS contextual tabs appear on the Ribbon when you select a chart.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares values from different categories.A value is indicated by the height of each ____.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares values from different categories.Areas under the lines contain a fill color

-Referring to the figure above,if you were to create a Wine Production Chart pie chart using the information in B28:C34,the data source for that chart would be ____.

A ________ contains the actual values that are plotted on the chart

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares relative values of different categories to the whole.A value is indicated by the area of a(n) ____

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares a collection of values from several different data sets.

Category values are usually located in the ____ of the data source.

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

To add and remove chart elements,you can use the Add Chart Element button in the Charts Layout group on the ____ tab.

-In the figure above,the biggest slice is the cases of _______.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Shows patterns or relationship between two or more sets of values.Often used in scientific studies and statistical analyses.

In the lower right corner,below C34,the _____ tool displays.

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Compares values from different categories.A value is indicated by the length of the ____

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Similar to a Scatter chart

MATCHING Identify the letter of the chart type that best matches the phrase or definition. -Often used to show trends and changes over time

Placing a chart in a ____ displays only the chart and no worksheet cells.