Chapter 1



Test Bank - Chapter 4

Graphs and Charts:

Delivering a Message

Objectives

Distinguish between the different types of charts, stating the advantages and disadvantages of each.

Distinguish between a chart embedded in a worksheet and one in a separate chart sheet; explain how many charts can be associated with the same worksheet.

Use the ChartWizard to create and/or modify a chart.

Enhance a chart by using arrows and text.

Differentiate between data series specified in rows and data series specified in columns.

Describe how a chart can be statistically accurate yet totally misleading.

Create a compound document consisting of a word processing memo, a worksheet and a chart.

Multiple Choice

1. Which chart type is the most appropriate to show the percentage of the federal budget spent on defense?

a) A pie chart

b) A column chart

c) A stacked column chart

d) A line chart

answer: a

2. Which of the following types of pie charts can be used to create three dimensional pie charts?

a) Non-exploded only

b) Exploded only

c) Both exploded and non-exploded

d) Neither exploded nor non-exploded

answer: c

3. Once a pie chart has been created, what is the easiest method of transforming it into an exploded pie chart?

a) Use the Chart Wizard

b) Click and drag wedges out of the pie chart

c) There is no way to convert a pie to an exploded pie

d) Use the Office Assistant

answer: b

4. Which of the following statements about sizing and moving a chart is true?

a) A chart can be sized horizontally

b) A chart can be sized vertically

c) A chart can be moved to any location in the worksheet

d) All of the above

answer: d

5. Which of the following can be modified after a chart is created using the Chart Wizard?

a) The chart type

b) The legend

c) The formatting of the title

d) All of the above

answer: d

6. Which of the following is true about an embedded chart?

a) It can be moved elsewhere in the worksheet

b) It can be made larger or smaller

c) It can be deleted

d) All of the above

answer: d

7. What is the easiest way to delete a chart from a worksheet?

a) Click on the data range from which the chart was created, then click on Edit and drag to Delete Chart

b) Click on the chart, then press the Del key

c) Click on the chart, then press Ctrl+Del

d) Once a chart is created it cannot be deleted

answer: b

8. How do you activate the shortcut menu for a selected worksheet item?

a) Press Ctrl+S

b) Point to the item, then click the right mouse button

c) Double click the right border of the object

d) Click the shortcut menu icon on the Standard toolbar

answer: b

9. What happens when you point to a cell and click the right mouse button?

a) A shortcut menu is displayed

b) The cell contents are deleted

c) The cell contents are displayed

d) The AutoFill command is executed

answer: a

10. Which of the following chart types explicitly totals the data series in each category?

a) Side-by-side columns

b) Stacked columns

c) Both side-by-side and stacked columns

d) Neither side-by-side nor stacked columns

answer: b

11. Which key will create a default chart type in its own worksheet after you select the range?

a) F2

b) F4

c) F5

d) F11

answer: d

12. Assume you have used Paste Link to create a compound document using an Excel worksheet and a word processing document. Which of the following will change if the worksheet is modified?

a) The chart in the worksheet, but not the chart in the word processing document

b) The chart in the word processing document, but not the chart in the worksheet

c) The chart in the worksheet and the chart in the word processing document

d) Neither the char tin the worksheet, nor the chart in the word processing document

answer: c

13. Which of the following creates a dynamic link between an Excel worksheet and a word processing memo?

a) Cut and Paste

b) Object Linking and Embedding (OLE)

c) Both Cut and Paste, and OLE

d) Neither Cut and Paste, nor OLE

answer: b

14. Which of the following commands is included in the command sequence to embed a chart in a word processing document if a dynamic link is required?

a) Copy

b) Paste Special

c) Paste Link

d) All of the above

answer: d

15. What is the quickest way to cycle back and forth between a Word and Excel when working on an Object Linking and Embedding document?

a) Minimize the first application and go to the second

b) Close the first application and go to the second

c) Use Alt+Tab to cycle through open applications

d) All of the these way will work

answer: c

16. Which of the following is used to distinguish one data series from another?

a) The labels on the X axis

b) The legend

c) The key

d) The labels on the Y axis

answer: b

17. Which of the following is most appropriate to show the trend of revenues and sales growth over a five year period?

a) A line chart

b) A side-by-side column chart

c) A pie chart

d) A combination chart

answer: a

18. Which of the following chart types is the best to show the number of houses sold and the dollar volume of sales for six real estate agents?

a) A pie chart

b) A side-by-side column chart

c) A combination chart

d) A line chart

answer: c

19. A combination chart is best when you need to show

a) The proportions of more than one data series

b) Different scales for multiple data series plotted against the same X axis

c) Both horizontal and vertical data

d) Data that contains both relative and absolute cell references

answer: b

20. Which of the following would you recommend to show time-related information?

a) Pie chart

b) Side-by-side column chart

c) Stacked column chart

d) Line chart

answer: d

21. Which of the following can be used to add emphasis to a pie chart?

a) Arrows and text

b) The chart title

c) An exploded slice

d) All of the above

answer: d

22. If you are creating a column chart to show monthly sales in each of three cities, which axis would contain the category labels (the city names)?

a) X axis

b) Y axis

c) Either X or Y axis

d) It is not possible to determine from the information given

answer: a

23. In which chart type is the data graphed horizontally?

a) Bar chart

b) Column chart

c) Both bar and column chart

d) Stacked column chart

answer: a

24. Which chart would be updated automatically?

a) A chart that is embedded in the worksheet

b) A chart that is in its own chart sheet

c) Both the embedded chart and the one in its own chart sheet

d) Neither the embedded chart nor the one in its own chart sheet

answer: c

25. Which of the following cannot be used to move an embedded chart?

a) Click anywhere in the chart then click and drag the chart elsewhere in the worksheet

b) Double click anywhere in the chart then click and drag the chart elsewhere in the worksheet

c) Point to the chart, click the right mouse button to select the chart, then click and drag the chart elsewhere in the worksheet after it has been selected

d) Select the chart, execute the cut command, click elsewhere in the worksheet, then execute the paste command

answer: b

26. Which of the following chart types is available when using the Chart Wizard to create a chart?

a) Pie

b) 3D column

c) Combination

d) All of the above

answer: d

27. Which of the following changes to a chart requires using the Drawing Toolbar?

a) Adding an arrow and text to the chart

b) Adding a chart title

c) Removing the legend

d) Changing the data series to columns

answer: a

28. Which of the following is done using the Drawing toolbar?

a) Adding a text box

b) Changing the chart type

c) Adding gridlines to the chart

d) All of the above

answer: a

29. An embedded chart can be

a) Moved

b) Copied

c) Sized

d) All of the above

answer: d

30. You have created a workbook that includes a revenue worksheet containing two embedded charts. The workbook also includes one chart in its own worksheet. How many files does it take to store this workbook?

a) 1

b) 2

c) 3

d) 4

answer: a

31. An Excel workbook contains one worksheet with an embedded chart, and three worksheets with data and formulas only. How many files does it take to store this workbook?

a) 1

b) 2

c) 3

d) 4

answer: a

32. You have finished a pie chart and decided it should have been a bar chart. What is the best course of action?

a) To delete the pie chart and start over

b) To move the pie chart and use Chart Wizard to start again

c) To go to the Chart type box and change from a pie to a bar

d) Both b and c will work

answer: d

33. Which of the following will change if you switch from a side-by-side column chart to a stacked column chart?

a) The height of the columns

b) The number of columns

c) The scale on the Y axis

d) All of the above

answer: d

34. Which of the following will change if you switch from a side-by-side column chart to a stacked column chart?

a) The labels on the X axis

b) The scale on the Y axis

c) Both the labels on the X axis and the scale on the Y axis

d) Neither the labels on the X axis nor the scale on the Y axis

answer: b

35. Which of the following chart types emphasizes the totals for each category label on the X axis?

a) Bar chart

b) Column chart

c) Stacked column chart

d) Line chart

answer: c

36. If the data series in a chart are in rows, the Excel Chart Wizard will

a) Use the first row for the X axis labels

b) Use the first row for the Y axis labels

c) Use the first row for the legend text

d) It is not possible to determine

answer: a

37. If the data series in a chart are in columns, the Excel Chart Wizard will

a) Use the first row for the X axis labels

b) Use the first column for the X axis labels

c) Use the first row for the Y axis labels

d) Use the first column for the legend text

answer: b

38. If the data series in a chart are in rows, the Excel Chart Wizard will

a) Use the first row for the X axis labels

b) Use the first column for the legend text

c) Use the first row for the X axis labels and the first column for the legend text

d) None of the above

answer: c

39. If the data series in a chart are in columns, the Excel Chart Wizard will

a) Use the first row for the X axis labels

b) Use the first column for the legend text

c) Use the first row for the X axis labels and the first column for the legend text

d) None of the above

answer: d

40. What happens if you select multiple data series in a worksheet and then press F11?

a) The cell formats are deleted

b) The Copy command is invoked

c) A default chart is created

d) The worksheet is recalculated

answer: c

41. Which of the following will display a shortcut menu when you point to the object and click the right mouse button?

a) A worksheet or chart sheet

b) An embedded chart

c) A worksheet (chart sheet) and an embedded chart

d) Neither a worksheet (chart sheet) nor an embedded chart

answer: c

42. You are creating a chart which will use multiple ranges of cells within the worksheet in various locations. You want to use the Chart Wizard, how do you choose noncontiguous ranges?

a) Alt+Tab

b) Ctrl

c) Shift+Tab

d) Alt+Ctrl+Tab

answer: b

43. You can copy a chart sheet by

a) Pointing to its worksheet (chart sheet) tab, clicking the right mouse button, then selecting Move or Copy from the shortcut menu

b) Pressing the Ctrl key, then clicking and dragging the worksheet (chart sheet) tab to its new position

c) Using a shortcut menu associated with the worksheet (chart sheet) tab or by clicking and dragging

d) Only by using the Copy command on the Edit menu

answer: c

44. The group or range of numeric values used to in a chart would be called

a) The category labels

b) The data series

c) The X-axis range

d) The Y-axis range

answer: b

45. Assume that you finished a chart and you now have decide to change some information on the previous screen. The best method to accomplish this is by

a) Retrace your steps by using the back command

b) Delete the chart and start over

c) Fix the information on the worksheet

d) None of the above

answer: a

46. Assume that cells A1 through D5 have been selected, after which the Chart Wizard is used to create a side-by-side column chart. How many data series will there be given that the data are to be plotted in rows?

a) Three

b) Four

c) Five

d) Impossible to determine

answer: b

47. Assume that cells A1 through D5 have been selected, after which the Chart Wizard is used to create a side-by-side column chart. How many data series will there be given that the data are to be plotted in columns?

a) Three

b) Four

c) Five

d) Impossible to determine

answer: a

48. Which of the following is true?

a) A linked object must be stored in its own file prior to including it in a compound document

b) An embedded object must be stored in its own file prior to including it in a compound document

c) An object must be stored in its own file regardless of whether it is linked or embedded

d) An object cannot be stored in its own file if it is to be linked or embedded in a compound document

answer: a

49. Which technique would you use to include the same Excel chart in both a Word document and a PowerPoint presentation?

a) Linking

b) Embedding

c) Compounding

d) Multitasking

answer: a

50. Which of the following was suggested to facilitate moving and sizing an Excel chart that has been linked or embedded in a Word document?

a) Removing the frame and/or border around the chart

b) Placing the chart in a frame

c) Placing a border around the chart

d) All of the above

answer: b

True/False

51. A column chart is the chart type best suited to display proportional data.

answer: F

52. You should limit the number of categories in a pie chart to seven or fewer.

answer: T

53. If a chart is kept in a separate chart sheet it will not be updated when the data points in the worksheet are updated.

answer: F

54. An embedded chart is not updated if the worksheet is modified unless the Edit Update command is used.

answer: F

55. The size and/or location of an embedded chart cannot be changed once the chart has been created.

answer: F

56. Pressing the Del key after selecting an embedded chart erases the chart from the worksheet.

answer: T

57. A chart created using the Chart Wizard cannot be modified.

answer: F

58. The location of a toolbar cannot be changed.

answer: F

59. The title of a chart must be entered as a text box using the Charting toolbar; it cannot be entered using the Chart Wizard.

answer: F

60. A column chart with multiple data series can always display the series side by side or in stacked format with equally meaningful results.

answer: F

61. A side-by-side column chart and a stacked column chart of the same data will use the same scale on the Y axis.

answer: F

62. Multiple data series may be contained in either rows or columns.

answer: T

63. If you specify that data is to be charted is in rows, Excel will use the first row for the legend text.

answer: F

64. The chart type may be changed using the Format menu, the Chart Wizard, or a shortcut menu.

answer: T

65. A chart may be copied to another area of a workbook.

answer: T

66. When creating a linked object, both source and destination documents will be open.

answer: T

67. It is not possible to edit an Excel worksheet that is embedded in a Word document.

answer: F

68. Pressing Alt+Tab allows the user to move between open applications.

answer: T

69. The clipboard is not used to copy data between a worksheet and a word processing document during object linking and embedding.

answer: F

70. A Word document cannot contain both an Excel chart and the associated worksheet.

answer: F

71. A line chart is best suited to display time related data.

answer: T

72. A line chart can be used to plot more than one data series.

answer: T

73. A combination chart may use different scales for different data series.

answer: T

74. Unit sales and dollar sales will produce the same size slices in a pie chart.

answer: F

75. The Paste Special command will link or embed an object, depending on whether the Paste Link command or Paste option button is checked.

answer: T

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download