Exam 4: Enhancing a Workbook With Charts and Graphs

You already created a line chart,but now decide that you want to change this chart to a pie chart.To do this,you click ____ from the Type group in the Chart Tools Design tab.

(Multiple Choice)

4.8/5

(30)

Question 101

To format an individual sparkline,select the sparkline you want to format,and then click the Ungroup button in the Group group on the Sparkline Tools ____ tab.

(Multiple Choice)

4.8/5

(44)

Question 102

To move or resize an embedded chart,____.

(Multiple Choice)

4.7/5

(41)

Question 103

To fill a column with a blend of colors in a column chart,you would choose ____ from the Fill options.

(Multiple Choice)

4.8/5

(31)

Question 104

The series name has only one data series._________________________

(True/False)

4.9/5

(31)

Question 105

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent and each cell represents only a single bar from the bar chart.

(True/False)

4.8/5

(37)

Question 106

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

(Multiple Choice)

4.7/5

(34)

Question 107

The words Information,Services,an Manufacturing shown in Column A are the ____.

(Multiple Choice)

4.7/5

(31)

Question 108

Since each slice of a pie represents a different value in the series,you ____.

(Multiple Choice)

4.8/5

(42)

Question 109

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

(Short Answer)

4.9/5

(34)

Question 110

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares a collection of values from several different data sets

(Multiple Choice)

4.9/5

(36)

Question 111

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements-chosen because they look "nice"-confuse and distract the reader.

(Multiple Choice)

4.9/5

(36)

Question 112

To revise the title of a chart rather than replacing it,you can ____________________ the chart title to place the insertion point in the text,and then edit the text as needed.

(Short Answer)

4.9/5

(46)

Question 113

It's difficult to read the exact scale on some of Andy's data.Adding ____ would make it easier to read.

(Multiple Choice)

4.9/5

(43)

Question 114

Excel allows you to overlay a legend on a chart as a space-saving option.

(True/False)

4.8/5

(35)

Question 115

To work with a title or other individual element of a chart,select the ____ tab.

(Multiple Choice)

4.8/5

(38)

Question 116

Although 3-D charts are visually attractive,they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.

(True/False)

4.9/5

(36)

Question 117

To display a large number of categories whose values are close to one another,you should create a ____ chart.

(Multiple Choice)

4.8/5

(34)

Question 118

The Label Position option in the Format Data Labels dialog box includes ____.

(Multiple Choice)

4.8/5

(37)

Question 119

By default,Excel inserts a chart as an embedded chart._________________________

(True/False)

4.8/5

(42)

Question 120

Showing 101 - 120 of 150

You already created a line chart,but now decide that you want to change this chart to a pie chart.To do this,you click ____ from the Type group in the Chart Tools Design tab.

To format an individual sparkline,select the sparkline you want to format,and then click the Ungroup button in the Group group on the Sparkline Tools ____ tab.

To move or resize an embedded chart,____.

To fill a column with a blend of colors in a column chart,you would choose ____ from the Fill options.

The series name has only one data series._________________________

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent and each cell represents only a single bar from the bar chart.

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

The words Information,Services,an Manufacturing shown in Column A are the ____.

Since each slice of a pie represents a different value in the series,you ____.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares a collection of values from several different data sets

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements-chosen because they look "nice"-confuse and distract the reader.

To revise the title of a chart rather than replacing it,you can ____________________ the chart title to place the insertion point in the text,and then edit the text as needed.

It's difficult to read the exact scale on some of Andy's data.Adding ____ would make it easier to read.

Excel allows you to overlay a legend on a chart as a space-saving option.

To work with a title or other individual element of a chart,select the ____ tab.

Although 3-D charts are visually attractive,they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.

To display a large number of categories whose values are close to one another,you should create a ____ chart.

The Label Position option in the Format Data Labels dialog box includes ____.

By default,Excel inserts a chart as an embedded chart._________________________

Getting Started With Excel

Formatting a Workbook

Working With Formulas and Functions

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters