FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 14: Excel Lesson 8: Working With Charts

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

A ____ chart shows the relationship of a part to a whole.

A) pie
B) column
C) line
D) scatter

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

A chart sheet does not have worksheet cells and cannot contain data or formulas.

Correct Answer

verified

Show Answer

Question 3

Short Answer

Review LaterAdd Note

You can pull one or more slices away from the pie to distinguish them, creating what is called a(n) ____________________ pie chart.

You can rename a chart sheet like any other worksheet. Right-click its sheet tab, and then click ____ on the shortcut menu.

You switch between a chart sheet and a worksheet by clicking the appropriate ____.

You can quickly choose a layout and styles for a selected chart from the Ribbon. Click the ____ tab under Chart Tools on the Ribbon. In the Chart Layouts group, click the chart layout you want to use.

Case EX 8-1 Candace wants to create a chart sheet similar to the one shown above. Candace wants to move an embedded chart into a chart sheet. To do this, she would click the Chart Tools Design tab on the Ribbon. Then, in the ____ group, click the Move Chart button.

The chart element called ____ is a grid that displays the data plotted in the chart.

Case EX 8-2 Paco wants to change some of the elements in his chart, including the fill and border color. On a separate chart that he is working on, Paco needs to access the Format dialog box for the chart legend. First, he selects the chart he wants to edit. Then, on the ____ tab under Chart Tools on the Ribbon, in the Current Selection group, he clicks the Format Selection button.

A(n) ____________________ is a group of related information in a column or row of a worksheet that is plotted on the chart.

You can change a chart type or subtype at any time. On the Design tab, under Chart Tools on the Ribbon, in the ____ group, click the Change Chart Type button.

What is the difference between a data marker and a data label? Please describe a situation where you would use both at the same time.

You can show a variety of data markers on sparklines, including the high and low points, negative point, first and last points, and all data points. These options are available in the ____________________ group.

Axes are lines that establish a relationship between data in a chart; most charts have a horizontal x-axis and a vertical y-axis.

FIGURE EX 8-1 In Figure EX 8-1 above, the phrase Median Income is the ____.

FIGURE EX 8-1 In Figure EX 8-1 above, under Education Pays, the red and blue boxes labeled Men and Women is the ____.

A pie chart is similar to the column chart, but columns are replaced by points connected by a line.

Case EX 8-2 Paco wants to change some of the elements in his chart, including the fill and border color. What type of dialog box does Paco need to access to make these changes?

A bar chart, sometimes called an XY chart, shows the relationship between two categories of data.

The Chart Tools appear on the Ribbon with three contextual tabs that do NOT include ____.