Excel Chapter 7 Review True/False Indicate whether the statement is true or false. ____
1. A chart illustrates the relationship between data.
2. A pie chart only includes only one series of data.
3. A chart represents all of the data on the worksheet.
4. A header and footer can be added to a chart sheet.
5. An Excel chart that appears as an embedded object in a Word document can only be edited by editing the source file.
6. The horizontal axis title in the chart above is Enrollment.
7. The chart above contains major gridlines.
8. The chart above contains a legend.
9. Each Excel chart type has several subtypes.
____ 10. An adjacent data series is added to a selected chart by dragging a handle of the outlined original data series. ____ 11. A legend is always positioned to the right of a chart. ____ 12. A chart can be placed on a separate sheet in a workbook. ____ 13. An existing chart can be moved to a new location on the worksheet. ____ 14. Charts created in Excel can be copied to a Word document.
____ 15. A linked chart in a Word document is automatically updated if the source chart is updated in Excel. ____ 16. A bar chart can only include one series of data. ____ 17. A chart simplifies the understanding of numerical data. ____ 18. All charts contain the same objects. ____ 19. If a value or label in a chart data range is changed, the chart automatically updates. ____ 20. In a pie chart, the size of a slice varies with its percentage of the series total. ____ 21. Pie chart data labels must be displayed as percentages. ____ 22. Drag a corner handle to move a chart. ____ 23. A chart that appears as an object in a worksheet is printed when the worksheet is printed. ____ 24. An embedded chart will automatically change if the source worksheet changes. ____ 25. An embedded chart is static. ____ 26. An embedded chart can be edited in Word using Excel commands. ____ 27. A chart that is pasted as a picture can be edited in Word using Excel commands. ____ 28. Pie charts have axes. ____ 29. Column, bar, and line are the only types of charts that can be created in Excel. ____ 30. A bar is the only chart symbol that can be used in a column chart. Multiple Choice Identify the choice that best completes the statement or answers the question. ____ 31. Which chart object identifies each value in a data series? a. series name c. data labels b. plot area d. legend ____ 32. Which chart object is the part of the chart that displays data? a. series name c. data labels b. Plot Area d. legend ____ 33. Which type of chart is best for charting data that is a percentage of a whole? a. bar c. line b. column d. pie ____ 34. The first step in creating a pie chart is to a. select a location for the chart. b. select the data to be charted.
c. select the chart type. d. verify the source data.
____ 35. A chart is moved by dragging a. the middle right handle. b. a corner handle.
c. a chart border. d. the top middle handle.
____ 36. A chart is sized proportionately by dragging a. a chart border. b. a corner handle.
c. the middle left handle. d. the top middle handle.
____ 37. A selected chart is deleted by a. double-clicking a chart border. b. double-clicking a corner handle.
c. pressing the Delete key. d. pressing the Esc key.
____ 38. What is printed if a chart that appears as an object in a worksheet is selected before printing? a. all the sheets and charts in the workbook b. only the chart on a single sheet of paper in landscape orientation c. the sheet and chart on a single sheet of paper in portrait orientation d. the sheet and chart on a single sheet of paper in landscape orientation ____ 39. Which Paste Options command is selected to paste a chart as a graphic in a Word document? a. Chart (link to Excel data) c. Paste as Picture b. Excel Chart (entire workbook) d. Graphic (Excel) ____ 40. Which type of chart would best illustrate price fluctuations over a period of time for three stocks? a. bar c. pie b. line d. area
____ 41. Which type of chart is shown above? a. column b. line
c. pie d. area
____ 42. How many data series were used to create the chart above? a. 1 c. 3 b. 2 d. 4 ____ 43. In the chart above, which is the first horizontal axis label? a. 0 c. 2009 b. Architecture d. Program
____ 44. In the chart above, which is the first vertical axis label? a. 0 c. 2009 b. Architecture d. Program ____ 45. Which chart type is similar to a pie chart, but can contain more than one data series? a. bubble chart c. doughnut chart b. stock chart d. radar chart ____ 46. The chart title a. describes what is charted. b. is below the category labels.
c. is the sum of the data range. d. is also the vertical axis label.
____ 47. Which type of chart is shown above? a. bar b. column
c. line d. pie
____ 48. Which type of chart would best illustrate each department's sales as a percentage of the overall store sales? a. bar c. pie b. line d. area ____ 49. Which type of chart is best for comparing the differences between values? a. bar c. line b. value d. pie ____ 50. Which type of chart is best for displaying the differences of data over time? a. bar c. line b. value d. pie ____ 51. Which type of chart would best illustrate a comparison of the number of employees in each department of a store? a. bar c. pie b. line d. area ____ 52. Which chart type shows changes in values relative to a center point? a. XY (scatter) chart c. surface chart b. stock chart d. radar chart ____ 53. Which chart type compares sets of three values? a. bubble chart c. doughnut chart b. stock chart d. radar chart ____ 54. Which chart type shows trends of values over time? a. area chart c. doughnut chart
b. stock chart
d. radar chart
Completion Complete each statement. 55. A visual representation of worksheet data is called a ____________________. 56. The best chart type for charting data that is a percentage of a whole is ____________________. 57. The entire chart and all of its elements is referred to as the Chart ____________________. 58. In Excel, bar charts can have ____________________ or vertical bars. 59. The label for a data series is called the series ____________________. 60. In a(n) ____________________ chart, each value from the series is represented as a slice. 61. The data ____________________ is the portion of the worksheet to be charted. 62. In Excel, a vertical bar chart is called a(n) ____________________ chart.