Question 1

MATCHING
  
Using the above figure, identify the letter of the choice that best matches the figure.
-#1
A)Data series
B)Chart title
C)Data table
D)X-axis labels
E)X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label

Accepted Answer

The answer of MATCHING
  
Using the above figure, identify...

Question 2

The ____________________ dialog box, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.

Accepted Answer

The answer of The ____________________ dialog box, which is available...

Question 3

MATCHING
  
Using the above figure, identify the letter of the choice that best matches the figure.
-#5
A)Data series
B)Chart title
C)Data table
D)X-axis labels
E)X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label

Accepted Answer

The answer of MATCHING
  
Using the above figure, identify...

Question 4

MATCHING
  
Using the above figure, identify the letter of the choice that best matches the figure.
-#3
A)Data series
B)Chart title
C)Data table
D)X-axis labels
E)X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label

Accepted Answer

The answer of MATCHING
  
Using the above figure, identify...

Question 5

A(n) ____________________ combines the features of a line chart with a bar or column chart by filling in the area below the line, and displaying the trend of values over time or categories.

Accepted Answer

The answer of A(n) ____________________ combines the features of a...

Question 6

One available chart option is to create a 100% ____________________ chart, in which the plotted values are converted into percentages of the total amount within each category.

Accepted Answer

The answer of One available chart option is to create...

Question 7

To emphasize categories of data and each category's contribution to the total, create a(n) ____________________ pie chart by dragging a pie slice away from the other slices in the pie.

Accepted Answer

The answer of To emphasize categories of data and each...

Question 8

To control the display of individual labels in a chart, use the ____________________ options in Chart Elements.

Accepted Answer

The answer of To control the display of individual labels...

Question 9

To change the chart sub-type, click the chart to display the CHART TOOLS contextual tabs on the ribbon, click the CHART TOOLS ___________ tab, and then click the Change Chart Type button in the Type group.

Accepted Answer

The answer of To change the chart sub-type, click the...

Question 10

MATCHING
  
Using the above figure, identify the letter of the choice that best matches the figure.
-#7
A)Data series
B)Chart title
C)Data table
D)X-axis labels
E)X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label

Accepted Answer

The figure represents the X-axis.

Question 11

To change the thickness of a pie slice, change the value of the degree in the ____________________ box in the Format Chart Area task pane.

Accepted Answer

The answer of To change the thickness of a pie...

Question 12

To modify how gridlines display in a chart's plot area, use the ____________________ options in Chart Elements.

Accepted Answer

The answer of To modify how gridlines display in a...

Question 13

In the Format Data Labels task pane, use the ____________________ option to change the appearance of a data label's 3-D format.

Accepted Answer

The answer of In the Format Data Labels task pane,...

Question 14

MATCHING
  
Using the above figure, identify the letter of the choice that best matches the figure.
-#4
A)Data series
B)Chart title
C)Data table
D)X-axis labels
E)X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label

Accepted Answer

The answer of MATCHING
  
Using the above figure, identify...

Question 15

The ____________________ chart type compares sets of three values. Values are indicated by the size of the filled circles.

Accepted Answer

The answer of The ____________________ chart type compares sets of...

Question 16

To display a moving average along with your chart data, use the ____________________ option in Chart Elements.

Accepted Answer

The answer of To display a moving average along with...

Question 17

An X Y (____________________) chart plots numeric values on both the x- and y-axes based on the value of the data.

Accepted Answer

The answer of An X Y (____________________) chart plots numeric...

Question 18

Many element-related Excel chart options are found on the Chart ____________________ menu.

Accepted Answer

The answer of Many element-related Excel chart options are found...

Question 19

MATCHING
  
Using the above figure, identify the letter of the choice that best matches the figure.
-#2
A)Data series
B)Chart title
C)Data table
D)X-axis labels
E)X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label

Accepted Answer

The answer of MATCHING
  
Using the above figure, identify...

Question 20

MATCHING
  
Using the above figure, identify the letter of the choice that best matches the figure.
-#6
A)Data series
B)Chart title
C)Data table
D)X-axis labels
E)X-axis
F)Legend
G)Y-axis
H)Y-axis labels
I)Gridlines
J)Data point with data label

Accepted Answer

The answer of MATCHING
  
Using the above figure, identify...

Quiz 3: Determining Effective Data Display with Charts

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#1

The ____________________ dialog box, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#5

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#3

A(n) ____________________ combines the features of a line chart with a bar or column chart by filling in the area below the line, and displaying the trend of values over time or categories.

One available chart option is to create a 100% ____________________ chart, in which the plotted values are converted into percentages of the total amount within each category.

To emphasize categories of data and each category's contribution to the total, create a(n) ____________________ pie chart by dragging a pie slice away from the other slices in the pie.

To control the display of individual labels in a chart, use the ____________________ options in Chart Elements.

To change the chart sub-type, click the chart to display the CHART TOOLS contextual tabs on the ribbon, click the CHART TOOLS ___________ tab, and then click the Change Chart Type button in the Type group.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#7

To change the thickness of a pie slice, change the value of the degree in the ____________________ box in the Format Chart Area task pane.

To modify how gridlines display in a chart's plot area, use the ____________________ options in Chart Elements.

In the Format Data Labels task pane, use the ____________________ option to change the appearance of a data label's 3-D format.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#4

The ____________________ chart type compares sets of three values. Values are indicated by the size of the filled circles.

To display a moving average along with your chart data, use the ____________________ option in Chart Elements.

An X Y (____________________) chart plots numeric values on both the x- and y-axes based on the value of the data.

Many element-related Excel chart options are found on the Chart ____________________ menu.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#2

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#6