FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Effective Charts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

To see possible types of graph to use,you can click Recommended Charts in the ________.

A) Illustrations group on the INSERT tab.
B) Charts group on the INSERT tab.
C) Illustrations group on the VIEW tab.
D) Charts group on the VIEW tab.

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

When creating a chart from data in a worksheet,the legend data is indicated by ________.

A) shading the data with a light purple background
B) surrounding the data with a purple border
C) changing font color of the data to red
D) surrounding the data with a red dashed border

Correct Answer

verified

Show Answer

Question 3

Matching

Review LaterAdd Note

Match the following chart types to their application.

Gridlines can be customized by using the Format ________ Gridlines task pane.

A bar chart is displayed horizontally and is useful for comparing categorized data sets.

To illustrate the relationship of the parts to the whole,you would use a(n) ________ chart.

In the worksheet above,the red arrow is pointing at a(n)________

Match the following terms to their definition.

To move a chart,you double-click its border and drag the chart to a new location.

The ________ tool is a contextual tool that provides single-click access to charts and PivotTables.

Match the following terms to their definition.

To change the color of a chart ,you click Change Colors in the ________.

An enhanced pie chart is a chart in which a slice is pulled outward away from the other slices.

In a chart,the ________ is an index that identifies the data.

________ are small charts that are embedded into the cells in a worksheet to help with trend analysis.

A common use for ________ charts is for project management.

Using a(n)________ pie chart,you can emphasize a slice by moving it out away from the other slices.

The chart shown above depicts a line chart.

Match the following buttons to their action.

Premises

Responses

Chart Elements

Chart Filters

Size and Properties

Fill & Line

Chart Styles

Premises

Responses

Chart Elements

Chart Filters

Size and Properties

Fill & Line

Chart Styles

Show Answer

Correct Answer

Premises

Responses

Premises

Responses

You can display data bars as a one-color solid fill or a gradient fill from left to right as the numerical value increases.