Question 1

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 2

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 3

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 4

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 5

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 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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 10

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 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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 15

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 16

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 17

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

Accepted Answer

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

Question 18

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 19

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 20

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...

Quiz 3: Determining Effective Data Display with Charts

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.

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

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

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

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

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

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. -#1

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

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. -#6

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. -#7

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.

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

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.

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

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 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.

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.