Question 1

You can add ___________________ to identify smaller intervals between the major tick marks.

Accepted Answer

The answer of You can add ___________________ to identify smaller...

Question 2

To create a combination chart,you select a data series in an existing chart,and then apply a new ___________________ to that series.

Accepted Answer

The answer of To create a combination chart,you select a...

Question 3

Anya has decided to make her chart a 3-D chart,but her supervisor complained that he cannot see enough of the data.Anya should try to ____.

Accepted Answer

Rotating the chart along the y-axis will change the vertical perspective, potentially making more data visible.

Question 4

If you add percentages to a pie chart,the percentages would appear directly on the pie slices ____________________ enough to fit the number,otherwise,percentages will appear next to the slices in the chart area.

Accepted Answer

The answer of If you add percentages to a pie...

Question 5

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

Accepted Answer

The answer of To plot the results of two data...

Question 6

In cases where a label placed outside a pie might appear farther from its slice than is easily readable,a(n)____________________ might be added to connect the data to its corresponding slices.

Accepted Answer

The answer of In cases where a label placed outside...

Question 7

Anya tells you that she is using a 3-D chart for the first time and asks if you have any advice for this chart type.You should tell Anya that it's especially important to ____ in 3-D charts.

Accepted Answer

In 3-D charts, it can be difficult to accurately determine the height or depth of data points, making data labels even more important than in 2-D charts. It's also important to detail the legend and title, but data labels are the most essential aspect for accuracy in 3-D charts. Using bright colors or a small font may not necessarily improve the effectiveness of the chart.

Question 8

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.

Accepted Answer

The answer of To compare values from several categories with...

Question 9

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

Accepted Answer

The answer of The range of values,or ___________________,of an axis...

Question 10

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?

Accepted Answer

A pie chart is the best option for representing data as parts of a whole. It allows for easy visualization of the percentage of the whole data by dividing the chart into slices that represent each category's proportion.

Question 11

In general,____________________ charts should be used only when the number of categories is small and the relative sizes of different data can be easily determined.

Accepted Answer

The answer of In general,____________________ charts should be used only...

Question 12

A chart that combines two or more chart types into a single graph is called a(n)____________________ chart.

Accepted Answer

The answer of A chart that combines two or more...

Question 13

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.

Accepted Answer

The answer of Since scientific data is often plotting two...

Question 14

A chart or ____________________ is a visual representation of a set of data.

Accepted Answer

The answer of A chart or ____________________ is a visual...

Question 15

Since Anya is still reviewing her data,she wants to make sure that her chart reflects any changes she makes in her data source.She should ____.

Accepted Answer

Excel charts typically remain linked to their data sources, meaning that any changes made to the data will automatically update the chart. Therefore, Anya does not need to do anything to ensure that her chart reflects changes made to the data source.

Question 16

Andy has experimented with a few different types of charts to give his boss options for reporting the test results.In his bar chart,Andy wants to change the chart's border.To do this,he should select the ____ tab in the Chart Tools.

Accepted Answer

The Format tab in the Chart Tools allows users to change visual aspects of the chart, such as colors, borders, and fonts. Changing the chart's border falls under the realm of visual formatting, so selecting the Format tab would be the best choice for this task. The Edit tab is more focused on manipulating the chart's data and layout, while the Design tab is geared towards changing the overall look and style of the chart. The Layout tab allows users to adjust specific elements within the chart, such as labels and axes.

Question 17

Excel supports ____________________ built-in charts.

Accepted Answer

The answer of Excel supports ____________________ built-in charts....

Question 18

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?

Accepted Answer

When using one data series, it can be redundant to use a chart title and legend. This is because the data is already represented clearly in the pie chart itself, and adding a redundant title and legend can clutter the visual display. Removing the legend in this case can improve the overall simplicity and clarity of the chart.

Question 19

Anya needs to call attention to one category above all others.For this purpose,she should use a(n)____.

Accepted Answer

An exploded pie chart is designed to draw attention to a particular slice of data by pulling it out and making it visually distinct from the others. This is particularly useful when one category needs to be highlighted above all others.

Question 20

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

Accepted Answer

The answer of You can add visual interest to charts...

Quiz 4: Enhancing a Workbook With Charts and Graphs