FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Enhancing a Workbook With Charts and Graphs

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 71

Multiple Choice

Review LaterAdd Note

Review Later

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares values from different categories.Areas under the lines contain a fill color

A) Bubble
B) Column
C) XY
D) Line
E) Radar
F) Pie
G) Doughnut
H) Bar
I) Surface
J) Area
K) Stock
L) Scatter

Correct Answer

verified

Show Answer

Question 72

Multiple Choice

Review LaterAdd Note

Review Later

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Similar to the pie chart except that it can display multiple sets of data

A) Bubble
B) Column
C) XY
D) Line
E) Radar
F) Pie
G) Doughnut
H) Bar
I) Surface
J) Area
K) Stock
L) Scatter

Correct Answer

verified

Show Answer

Question 73

Multiple Choice

Review LaterAdd Note

The ____,shown in the figure above,include data markers to indicate the high and low points.

-Referring to the figure above,the entry 54.94%,shown next to the largest pie slice,is a ____.

In the Format Axis dialog box,selecting Fixed 0.10 for the Minor Unit will result in ____.

A(n)____________________ chart shows patterns or relationships between two or more sets of values,much like an XY chart,except the size of the data marker is determined by a third value.

If you do not want a chart to reflect new values in the data source,you should ____.

Because of the compactness of sparklines,you can specify only the line color and the line leader color._________________________

____ is not an available formatting category for legends.

The ____ is not a component of a data series.

From the Format Data Series dialog box,you can ____ as a Marker Option.

Extreme viewing angles in a 3-D chart may elongate the chart and misrepresent the data._________________________

If you select a chart's series and look at the formula bar,the formula being displayed uses the ____ function.

Anya has asked for your advice.A colleague told her to remove the legend from her pie chart,but she doesn't understand why.What would be a good reason to remove the title?

-Referring to the figure above,if you were to create a Fund Assets pie chart using the information in A1:B7,the data source for that chart would be ____.

On a 3-D chart,the ____ represents the object's depth.

If you want to represent the following data: 20%,25%,15%,17%,and 23%,a pie chart will best highlight the differences among the close in value data._________________________

Which of the following is not an option in the Fill options in the Format Data Series dialog box?

A 90° ____ value exaggerates the 3-D effect,making distant objects appear very small.

When selecting a chart,it's important to choose the right type of chart to represent your data.If choosing between a pie chart and a line chart,what factors would you evaluate in choosing which chart to use? How would each chart differ in representing your data?