Chapter 16: Inserting and Formatting Charts TRUE/FALSE 1

Question

Chapter 16: Inserting and Formatting Charts

TRUE/FALSE

1. Charts show trends or relationships that may not be readily apparent from numbers alone.

2. The first column of a data range contains the category values.

3. Pie, column, bar, and line charts assume that numbers are plotted against one another.

4. Each chart you create is inserted as a chart sheet.

5. A data marker is text for an individual data label.

6. A bar chart is a column chart turned on its side so that the length of each bar is based on its value.

7. By default, no titles appear next to the value and category axes.

8. Hash tags extend the values of the major or minor tick marks across the plot area.

9. The figure above shows a set of sparklines.

10. A data bar is conditional formatting that adds a horizontal bar to the background of a cell containing a number.

MODIFIED TRUE/FALSE

1. Each chart has a(n) series source, which is the range that contains the data to display in the chart.

2. When you create or select a chart, the Design, Layout, and Linkage tabs appear on the Ribbon.

3. A(n) legend is a rectangular area that indicates the data markers associated with the data series.

4. You change the fill color of a pie slice via the Chart Style dialog box.

5. A(n) exploded pie chart moves one slice away from the others as if someone were taking the piece away from the pie.

6. In a column chart, all of the columns have different formats.

7. Line charts are typically used when the data consists of values drawn from categories that follow a sequential order at evenly spaced intervals.

8. A(n) sparkline is a graph that is displayed within a cell.

9. The lengths of data bars are based on the values in the selected range.

10. When data bars are used with negative values, the data bars originate from the right of the cell.

MULTIPLE CHOICE

1. A ____ is a visual representation of a set of data values.

a.	chart	c.	matrix
b.	graph	d.	both a and b

2. Each chart has a(n) ____, the range that contains the data to display in the chart.

a.	data matrix	c.	inclusion zone
b.	data source	d.	containment range

3. The ____ is the first row of a data range.

a.	category value	c.	series value
b.	series name	d.	data source

4. The ____ of a data range contains the category values.

a.	first row	c.	first column
b.	series name	d.	link source

5. With a ____ chart, each value in the data series represents a slice.

a.	scone	c.	cake
b.	bar	d.	pie

6. When you select a chart, all of the following tabs appear on the Ribbon EXCEPT ____.

a.	Embed	c.	Layout
b.	Design	d.	Format

7. In the figure above, box ____ represents the chart area.

a.	A	c.	C
b.	B	d.	E

8. In the figure above, box C represents ____.

a.	the chart area	c.	a data marker
b.	the tabular matrix	d.	the legend

9. The figure above is an example of a ____ chart.

a.	radial	c.	spoked
b.	pie	d.	wheel

10. Each chart you create is inserted as a(n) ____.

a.	embedded chart	c.	bitmapped image
b.	object in a worksheet	d.	both a and b

11. A(n) ____ sheet contains only a chart, and no worksheet cells.

a.	chart	c.	“only”
b.	broad	d.	data

12. A chart ____ formats an entire chart at once.

a.	sheet	c.	style
b.	trace	d.	plot

13. Chart layouts are available on the ____ tab in the ____ group.

a.	Chart Tools Design, Chart Layouts	c.	Personalization Tools, Chart Design
b.	Chart Layouts, Format & Style	d.	Layout, Chart

14. The chart ____ provides a description of a chart or an overview of its purpose.

a.	ScreenTip	c.	legend
b.	sheet	d.	title

15. The chart ____ identifies each of the data series in a chart.

a.	title	c.	value
b.	sheet	d.	none of the above

16. A ____ is text for an individual data marker.

a.	data label	c.	legend
b.	chart sheet	d.	row header

17. ____ pie charts are useful for emphasizing one category above all the others.

a.	Disarticulated	c.	Embedded
b.	Exploded	d.	Layered

18. A ____ chart displays its values vertically; a ____ chart displays them horizontally.

a.	bar, line	c.	column, bar
b.	column, pie	d.	line, scatter

19. In the figure above, box A is a ____ chart.

a.	pie	c.	column
b.	bar	d.	line

20. In the figure above, the chart in box ____ displays one data series.

a.	A	c.	both a and b
b.	B	d.	neither a nor b

21. In the figure above, box B is a ____ chart.

a.	pie	c.	column
b.	bar	d.	line

22. When a chart has only one data series, the chart legend is ____.

a.	removed by default	c.	placed on the x-axis
b.	the same as the chart title	d.	placed on the y-axis

23. Usually, the columns in a column chart are distinguished by ____.

a.	height	c.	color
b.	girth	d.	opacity

24. The range of values on an axis is known as the ____ of the axis.

a.	delimiters	c.	scope
b.	parameters	d.	scale

25. ____ identify the main units on a chart axis.

a.	Minor tick marks	c.	Major labels
b.	Major tick marks	d.	Minor labels

26. ____ charts are typically used when the data consists of values drawn from categories that follow a sequential order at evenly spaced intervals.

a.	Scatterplot	c.	Line
b.	Bar	d.	Periodic

27. A column chart and a line chart placed in a single graph is an example of a(n) ____ chart.

a.	combination	c.	integrated
b.	confluence	d.	layered

28. Axis options are available in the ____ dialog box.

a.	Chart Tools	c.	Labels
b.	Format Axis	d.	Chart Format

29. To create a custom number format for numeric values, you click Custom under the ____ tab in the ____ dialog box.

a.	Value, Format Axis	c.	Format, Cells
b.	Number, Format Cells	d.	Values, Edit Cells

30. To add text to a numeric value when creating a custom format, surround the desired text with ____.

a.	“ ”	c.	* *
b.	‘ ’	d.	^ ^

31. ____ chart titles and legends in the chart area means placing them on top of the chart.

a.	Mashing up	c.	Flattening
b.	Layering	d.	Overlaying

32. ____ are lines that extend the values of major or minor tick marks across the plot area of a chart.

a.	Rules	c.	Gridlines
b.	Borders	d.	Axes

33. If you select a chart’s data series, the formula displayed in the formula bar uses the ____ function.

a.	CHART	c.	SERIES
b.	FRM_CHT	d.	DATASPACE

34. You modify a chart by clicking the ____ tab on the Ribbon, then clicking ____ in the Data group.

a.	Tools, Modify	c.	Chart Design, Modify Data Markers
b.	Chart Tools Design, Select Data	d.	Modify, Chart Data

35. A sparkline contains ____.

a.	gridlines	c.	both a and b
b.	a legend	d.	neither a nor b

36. A sparkline is displayed within ____.

a.	a chart sheet	c.	a cell
b.	a chart’s data series	d.	none of the above

37. The only feature you can add to a sparkline is a(n) ____.

a.	gridline	c.	axis
b.	legend	d.	exploded slice

38. Sparklines ____.

a.	can be inserted anywhere in a workbook	c.	convey a large amount of graphical information within a very small space
b.	are added as part of the cell background	d.	all of the above

39. A data bar is an example of ____ formatting.

a.	conditional	c.	logical
b.	layered	d.	clustered

40. All of the following are true of data bars EXCEPT ____.

a.	The lengths of data bars are based on the values in the selected range.	c.	When data bars are used with negative values, the data bars extend to the left.
b.	Data bars are dynamic.	d.	A cell can represent from one to four distinct data bars.

Case-Based Critical Thinking Questions

Case 16-1

For the following questions, state what would be, in general, the most appropriate chart type to use.

41. You have one data series with five categories. You want to show the data values as a percentage of the whole. You don’t need a category or value axis.

a.	pie chart	c.	bar chart
b.	column chart	d.	line chart

42. You have one data series, which contains eight categories, many of which are similar in value. You want your chart to display categories on the left, and the value across the bottom.

a.	pie chart	c.	bar chart
b.	column chart	d.	line chart

43. You want to demonstrate how car sales have changed over five years at three different area dealerships. You want the categories to be viewed from left to right and the values from bottom to top.

a.	pie chart	c.	bar chart
b.	column chart	d.	line chart

44. You want to show the changing value of three stocks that you own, at monthly intervals over the past four years.

a.	pie chart	c.	bar chart
b.	column chart	d.	line chart

Case-Based Critical Thinking Questions

Case 16-2

This chapter introduced the concepts of data label, data marker, data series, and data source. For each of the following questions, consider a hypothetical pie chart and its associated worksheet. Choose the concept shown by each question.

45. A pie slice

a.	data marker	c.	data source
b.	data label	d.	data series

46. A worksheet range from B4 to F8

a.	data marker	c.	data source
b.	data label	d.	data series

47. The entire pie

a.	data marker	c.	data source
b.	data label	d.	data series

48. The text “27%” placed over one of the pie slices

a.	data marker	c.	data source
b.	data label	d.	data series

Case-Based Critical Thinking Questions

Case 16-3

Given the integer in each question below, and the custom number format #,##0 “k”, determine what would be output.

49. The number 7741

a.	7,741	c.	7740k
b.	7741k	d.	7,741k

50. The number 0

a.	0	c.	0.000k
b.	0k	d.	Zero

COMPLETION

1. If the data source is organized in rows, the first row contains the ____.

2. ____ chart types compare three sets of values in a three-dimensional chart.

3. The data source for a pie chart should include only the category labels and data values, and not ____.

4. The simplest way to select a chart element is to ____.

5. When you select a chart, a(n) ____ surrounds the chart.

6. ____ provide different options for displaying and arranging chart elements.

7. If labels placed outside a pie appear far from their slices, you can use ____ to connect each data label to its corresponding data marker.

8. The ____ is the range of values plotted on a chart.

9. ____ charts usually show only one data series.

10. When a chart involves multiple data series that have vastly different values, you can plot one data series against a(n) ____ axis, which usually appears along the left side of the chart, and the other against a(n) ____ axis, which is usually placed on the right side of the chart.

11. Axis options are available in the ____ dialog box.

12. By default, gridlines appear on ____ charts and ____ charts.

13. The arrow in the figure above points to a set of values displayed as ____.

14. The ____ tab provides options for formatting the appearance of sparklines.

15. ____ bars are always placed in the cells containing the value they represent.

MATCHING

a.	data bar	g.	embedded chart
b.	series values	h.	chart
c.	scale	i.	value axis
d.	sparkline	j.	data marker
e.	gridlines	k.	data source
f.	series name	l.	data label

1. the first row of a data range

2. the range that contains the data to display in a chart

3. an object in a worksheet

4. conditional formatting that adds a horizontal bar to a cell background

5. a visual representation of a set of data values

6. text for an individual data marker

7. represents each value in a data series

8. the range of values of an axis

9. a graph displayed within a cell

10. shows the range of series values from all of the data series plotted on a chart

11. the data displayed in a chart

12. extend the values of tick marks across the plot area

ESSAY

1. Knowing how to pick the best chart is a key Excel skill. Briefly discuss the circumstances when you would use a pie chart, column chart, line chart, and XY scatter chart.

2. Name the six main ideas given in the chapter for communicating effectively with charts.

3. Given the following information about a chart’s series, write the entire SERIES function that you would see in the formula bar:

All the information appears in the Sheet2 worksheet.

The name of the series is in cell C1.

The labels of the series are in the range A2:A6.

The data values are in the range C2:C6.

The series is the second data series in the chart.