Exam 4: Enhancing a Workbook With Charts and Graphs

-Referring to the figure above,an example of a ____ name is row 9.

To plot the results of two data categories collected every month for a year,you should use a(n)____________________ chart.

To create a set of sparklines,you first select a data range containing the data you want to graph._________________________

-Depending on the pie chart layout you choose,you can ____.

In pie charts with legends,it's best to make the slice colors as similar as possible.

Perspective values range from 0 degrees to ___________________ degrees.

___________________ extend the tick marks across the plot area.

In a pie chart,the largest piece of pie represents the data series with the smallest value._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares relative values of different categories to the whole.A value is indicated by the area of a(n)____

The ____ Chart Tools contextual tabs appear on the Ribbon when you select a chart.

Excel supports the following three types of sparklines that does NOT include ____.

-Referring to the figure above,in the column chart,the values along the left side (0.00%,5.00%,etc. )are ____.

Increasing the rotation horizontally in a 3-D chart spins the chart ___________________.

To compare values from several categories with a sequential order,such as dates and times occurring at evenly spaced intervals,you would use a(n)____________________ chart.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Similar to the Scatter chart except the size of the data marker is determined by a third value

Since scientific data is often plotting two numeric values against one another,it is oftentimes best to represent this data type with a(n)____________________ chart.

A chart style is similar to a cell style or a table style in that it formats several chart elements at one time.

The range of values,or ___________________,of an axis is based on the values in the data source.

You can add visual interest to charts by using 3-D (three ___________________)effects.

Case-Based Critical Thinking Questions Case 4-2 Anya has just surveyed 100 reviewers to get their reaction to a new marketing ad campaign she is heading.She has one data series that she wants to represent graphically,and she needs to display her data in a way that keeps the percent of the whole data in mind when viewing. -Since it's important for Anya to keep percentages of her whole reviewer base in mind,she wants to represent data as parts of a whole.What chart type would you suggest to Anya?