FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Excel : Charts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Short Answer

Review LaterAdd Note

Review Later

Picking a chart ________ will allow you to change several formatting elements at the same time.

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

Including the column and row labels in a chart makes the chart harder to understand.

A) True
B) False

Correct Answer

verified

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

Which chart type is preferable when the category names are long?

If you wanted to show trends over set periods of time, you probably want to use a(n)________ chart.

A chart sheet can hold, at most, two charts.

In a pie chart which of the following is a good reason for using category data labels rather than the legend?

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

Which axis in a chart displays the descriptive labels for the data points?

What is a disadvantage of a stacked column chart?

Which of the following is not a chart element?

Match the following terms with their description: I. Combo chart II. X Y (scatter)chart III. Stock chart IV. Area chart V. Surface chart A. One variable is plotted on the horizontal axis and the other on the vertical axis B. Colors are used between the lines C. Uses two dimensions and a continuous curve D. Combines two chart types E. Subtypes include: High-Low-Close, Open-High-Low-Close, Volume-High-Low-Close, and Volume-Open-High-Low-Close

What does Excel not determine about the value axis when you create a chart?

What chart type represents data as spokes going from the center to the outer edge of the chart?

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

Match the following terms with their description: I. Data label II. Data point III. Data series IV. Data table V. Legend A. A group of data points B. Shows the precise value of a data point C. Helps to distinguish between various data series D. A precise value in a chart E. A grid used to plot data in a chart

In a stacked column chart the data must be ________.

A(n)________ column chart displays the relationship of data points to the whole category.

As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.

What font color does Excel use by default for many of its elements?

Which of the following is not a chart type?