Exam Questions 1st Edition ExcelChapter 3 Charts

Exploring Microsoft Office 2019 Introductory (Poatsy/Grauer)

Excel Chapter 3 Charts

1) What should you not select when selecting data for a chart?

A) Column labels

B) Row labels

C) Data

D) Worksheet titles

Diff: 2

Objective: E3.01 Create a Basic Chart

2) Which axis in a chart displays the descriptive labels for the data points?

A) Category

B) Value

C) Data

D) Series

Diff: 2

Objective: E3.01 Create a Basic Chart

3) Which of the following is not a chart element?

A) Chart area

B) Plot area

C) Legend

D) Data area

Diff: 2

Objective: E3.01 Create a Basic Chart

4) What is not true about an effective chart?

A) It always contains more than one series.

B) It is clear.

C) It is easy to understand.

D) It is useful.

Diff: 1

Objective: E3.01 Create a Basic Chart

5) What is not a purpose of using an effective chart?

A) Compares data

B) Reveals trends and patterns

C) Reveals even subtle errors in formulas

D) Aids in making informed decisions

Diff: 1

Objective: E3.01 Create a Basic Chart

6) Which of the following, when included, distorts the effectiveness of charting data points?

A) Too many series

B) Too many data points

C) Too much variance in the values of the data

D) Aggregates

Diff: 2

Objective: E3.01 Create a Basic Chart

7) Which axis in a chart displays incremental numbers for the data points?

A) Category

B) Value

C) Data

D) Series

Diff: 2

Objective: E3.01 Create a Basic Chart

8) Which of the following is not a chart type?

A) Circle

B) Pie

C) Bar

D) Line

Diff: 1

Objective: E3.02 Use other Methods to Create a Chart

9) A 100% stacked column chart is similar to which other chart in that it converts values to percentages?

A) Clustered column

B) Radar

C) Line

D) Pie

Diff: 2

Objective: E3.02 Use other Methods to Create a Chart

10) Which of the following is not true about trendlines?

A) They help forecast future data.

B) They can be added to all chart types.

C) The line indicates possible future values.

D) They are added to existing charts.

Diff: 3

Objective: E3.04 Add and Format Chart Elements

11) Which of the following is not true about sizing handles?

A) They appear as circles.

B) There are 8 of them for any object.

C) They allow you to make objects larger or smaller.

D) They always maintain the proper aspect ratio for the object.

Diff: 2

Objective: E3.01 Create a Basic Chart

12) What is a disadvantage of a stacked column chart?

A) Segments do not start at the same point.

B) Segments do not end at the same point.

C) There is a limit as to how many segments can be displayed.

D) This is only useful for one data series.

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

13) Which chart type is not listed in the All Charts window?

A) Treemap

B) Sparkline

C) Histogram

D) Waterfall

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

14) Which axis displays descriptive labels for the data points in a chart?

A) category axis

B) value axis

C) z-axis

D) y-axis

Diff: 2

Objective: E3.01 Create a Basic Chart

15) Which axis displays incremental numbers to identify the approximate values of data points?

A) x-axis

B) z-axis

C) category axis

D) value axis

Diff: 2

Objective: E3.01 Create a Basic Chart

16) Which chart type is best when you want to chart two unrelated data types?

A) Pie chart

B) Combo chart

C) Line chart

D) Radar chart

Diff: 1

Objective: E3.02 Use other Methods to Create a Chart

17) What chart type represents data as spokes going from the center to the outer edge of the chart?

A) Surface

B) Area

C) Radar

D) Histogram

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

18) As a general rule, Pie charts should be limited to how many slices?

A) 5

B) 7

C) 9

D) 11

Diff: 2

Objective: E3.02 Use other Methods to Create a Chart

19) Where does the primary axis display on a Combo chart?

A) Top

B) Bottom

C) Right side

D) Left side

Diff: 2

Objective: E3.02 Use other Methods to Create a Chart

20) What chart type can display two different chart types at the same time?

A) Combo

B) Combination

C) Mixed

D) Multiple

Diff: 2

Objective: E3.02 Use other Methods to Create a Chart

21) In a bar chart, which axis displays the categories?

A) Horizontal

B) Vertical

C) X

D) Z

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

22) Which chart type displays the data vertically?

A) Pie

B) Radar

C) Bar

D) Column

Diff: 1

Objective: E3.02 Use other Methods to Create a Chart

23) Which chart type displays the data horizontally?

A) Pie

B) Radar

C) Bar

D) Column

Diff: 1

Objective: E3.02 Use other Methods to Create a Chart

24) How many sizing handles are found on embedded charts?

A) 4

B) 6

C) 8

D) 10

Diff: 3

Objective: E3.01 Create a Basic Chart

25) Which of the following is not a chart element?

A) Chart foreground

B) Chart title

C) Axis title

D) Gridlines

Diff: 2

Objective: E3.04 Add and Format Chart Elements

26) The plot area is surrounded by how many axes?

A) 1

B) 2

C) 3

D) It depends on the chart type selected.

Diff: 3

Objective: E3.04 Add and Format Chart Elements

27) In the task pane, what does a diagonal black triangle next to a chart category indicate?

A) All the category's options are displayed.

B) None of the category's options are displayed.

C) There are no options for this category.

D) Every option for this category has already been chosen.

Diff: 3

Objective: E3.04 Add and Format Chart Elements

28) Which chart element cannot be chosen from the Chart Elements dialog box?

A) Axis Titles

B) Chart Title

C) Format Back Wall

D) Error Bars

Diff: 3

Objective: E3.04 Add and Format Chart Elements

29) What does Excel not determine about the value axis when you create a chart?

A) Incremental value

B) Start value

C) End value

D) Average value

Diff: 2

Objective: E3.04 Add and Format Chart Elements

30) What is not found on the Chart Elements List?

A) Chart Type

B) Data Table

C) Gridlines

D) Legend

Diff: 2

Objective: E3.04 Add and Format Chart Elements

31) In a pie chart which of the following is a good reason for using category data labels rather than the legend?

A) They reveal more information.

B) They take up less space.

C) They are easier to format.

D) They are easier to read.

Diff: 3

Objective: E3.04 Add and Format Chart Elements

32) In the task pane, what does a diagonal white triangle next to a chart category indicate?

A) All the category's options are displayed.

B) None of the category's options are displayed.

C) There are no options for this category.

D) Every option for this category has already been chosen.

Diff: 3

Objective: E3.04 Add and Format Chart Elements

33) What icon is not displayed when you select a chart?

A) Chart Elements

B) Chart Types

C) Chart Styles

D) Chart Filters

Diff: 3

Objective: E3.04 Add and Format Chart Elements

34) What can you not do from the Select Data Source dialog box?

A) Change chart data range

B) Delete a data series

C) Change chart type

D) Add chart data series

Diff: 2

Objective: E3.06 Modify the Data Source

35) Which chart type is a visual "dashboard" of your data?

A) Bar chart

B) Sparkline

C) Line chart

D) Column chart

Diff: 2

Objective: E3.07 Create and Customize Sparklines

36) Which chart type cannot be displayed as a sparkline?

A) Bar chart

B) Line chart

C) Column

D) Win/Loss

Diff: 3

Objective: E3.07 Create and Customize Sparklines

37) A parallel range is one that consists of the same starting point of another range, but can have a different end point.

Diff: 2

Objective: E3.01 Create a Basic Chart

38) As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.

Diff: 2

Objective: E3.01 Create a Basic Chart

39) In rare cases you can chart text entries.

Diff: 2

Objective: E3.01 Create a Basic Chart

40) Including the column and row labels in a chart makes the chart harder to understand.

Diff: 2

Objective: E3.01 Create a Basic Chart

41) It is good practice to delete any blank rows or columns before creating a chart.

Diff: 1

Objective: E3.01 Create a Basic Chart

42) When you are creating a chart, it is important to select parallel ranges.

Diff: 2

Objective: E3.01 Create a Basic Chart

43) Effective charts never overwhelm an audience.

Diff: 1

Objective: E3.01 Create a Basic Chart

44) Pie charts can only display one data series.

Diff: 1

Objective: E3.02 Use other Methods to Create a Chart

45) When you want to chart two related types of data, the Combo chart is perfect.

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

46) To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.

Diff: 2

Objective: E3.02 Use other Methods to Create a Chart

47) You might want to avoid using 3-D charts because they can distort the appearance of the data.

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

48) A stacked column chart displays multiple columns for each category.

Diff: 2

Objective: E3.02 Use other Methods to Create a Chart

49) When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.

Diff: 2

Objective: E3.03 Move, Size, and Print a Chart

50) You can enter data or formulas on a chart sheet.

Diff: 2

Objective: E3.01 Create a Basic Chart

51) A chart sheet can hold, at most, two charts.

Diff: 2

Objective: E3.01 Create a Basic Chart

52) You can link to a cell as the title of a chart.

Diff: 3

Objective: E3.04 Add and Format Chart Elements

53) To understand a chart, you need to include the chart data.

Diff: 3

Objective: E3.04 Add and Format Chart Elements

54) A chart style effects the formatting of the chart itself, but not the chart data.

Diff: 2

Objective: E3.05 Apply a Chart Style and Colors

55) The Chart Styles gallery displays style options for the selected chart only.

Diff: 2

Objective: E3.05 Apply a Chart Style and Colors

56) Even after selecting a data source for a chart you can still apply various filters on one or more series.

Diff: 2

Objective: E3.06 Modify the Data Source

57) Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.

Diff: 2

Objective: E3.06 Modify the Data Source

58) Excel normally uses all the selected data in creating a chart.

Diff: 2

Objective: E3.06 Modify the Data Source

59) You can switch the rows and columns in a chart to communicate a different perspective on your data.

Diff: 1

Objective: E3.06 Modify the Data Source

60) The range used for a sparkline can include more than one row.

Diff: 2

Objective: E3.07 Create and Customize Sparklines

61) Sparklines do not include the normal chart labels.

Diff: 2

Objective: E3.07 Create and Customize Sparklines

62) The ________ axis helps measure data from left to right in a graph.

Diff: 2

Objective: E3.01 Create a Basic Chart

63) A(n) ________ is a cell that contains a value used in a chart.

Diff: 2

Objective: E3.01 Create a Basic Chart

64) To select nonadjacent ranges press and hold the ________ key while selecting the nonadjacent ranges.

Diff: 2

Objective: E3.01 Create a Basic Chart

65) The ________ axis is the vertical axis.

Diff: 1

Objective: E3.01 Create a Basic Chart

66) The ________ is the visual key to a chart.

Diff: 2

Objective: E3.01 Create a Basic Chart

67) A data ________ is a group of related data points.

Diff: 2

Objective: E3.01 Create a Basic Chart

68) A group of data points used in a graph become a data ________.

Diff: 2

Objective: E3.01 Create a Basic Chart

69) The ________ axis helps measure data from top to bottom in a chart.

Diff: 2

Objective: E3.01 Create a Basic Chart

70) Do not include data ________ (such as totals or averages) and individual values in the same chart.

Diff: 3

Objective: E3.01 Create a Basic Chart

71) In a(n) ________ column chart data appears as side by side columns.

Diff: 2

Objective: E3.02 Use other Methods to Create a Chart

72) ________ charts are often used to represent data in educational, scientific, and medical experiments.

Diff: 2

Objective: E3.02 Use other Methods to Create a Chart

73) In a column chart the horizontal axis displays the ________.

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

74) A bar chart uses ________ bars.

Diff: 1

Objective: E3.02 Use other Methods to Create a Chart

75) If you are not sure which chart type to pick, it may be helpful to click ________ Charts in the Chart group.

Diff: 2

Objective: E3.02 Use other Methods to Create a Chart

76) ________ charts are the most effective when they have seven or fewer categories.

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

77) If you wanted to show trends over set periods of time, you probably want to use a(n) ________ chart.

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

78) In a ________ column chart the data must be additive.

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

79) A(n) ________ column chart displays the relationship of data points to the whole category.

Diff: 2

Objective: E3.02 Use other Methods to Create a Chart

80) When you point to a chart element Excel displays a(n) ________ with the name of the element.

Diff: 3

Objective: E3.04 Add and Format Chart Elements

81) Picking a chart ________ will allow you to change several formatting elements at the same time.

Diff: 2

Objective: E3.05 Apply a Chart Style and Colors

82) If your chart is intended for presentation, as opposed to printing, you should use a(n) ________ background.

Diff: 3

Objective: E3.05 Apply a Chart Style and Colors

83) In a(n) ________ Excel uses a check mark to indicate which chart categories are displayed in a chart.

Diff: 2

Objective: E3.06 Modify the Data Source

84) When you want to create a chart you first need to select a data ________.

Diff: 1

Objective: E3.06 Modify the Data Source

85) Excel uses ________ to determine what categories are visible in a chart.

Diff: 2

Objective: E3.06 Modify the Data Source

86) A(n) ________ is a type of chart which fits in one cell.

Diff: 2

Objective: E3.07 Create and Customize Sparklines

87) Match the following terms with their description:

I. Parallel range

II. Alt Text

III. Exploded pie chart

IV. Arrange

V. Chart filter

A. Text based interpretation

B. Moves an object backward or forward

C. Has the same starting and ending point

D. Helps you to focus on particular data

E. One or more pieces are separated from the others

Diff: 2

Objective: Multiple Objectives

88) Match the following terms with their description:

I. Sizing handles

II. Chart font color

III. Task pane

IV. Diagonal black triangles

V. Triangle with white fill

A. A window of options

B. Seen as 8 circles

C. Used to show that all chart category options are visible

D. Used to show that all chart category options are not visible

E. The default is Black, Text 1, Lighter 35%.

Diff: 3

Objective: Multiple Objectives

89) Match the following terms with their description:

I. Data labels

II. Quick Layout

III. Accessibility Compliance

IV. Alt Text

V. Sparklines

A. Applying features to make it easier on disabled users

B. Can be read by various devices

C. Helps you use predefined layouts

D. Easier to read than a legend

E. Examples include: line, column, win/loss.

Diff: 2

Objective: Multiple Objectives

90) Match the following terms with their description:

I. X-axis

II. Y-axis

III. Chart area

IV. Plot area

V. Legend

A. Holds the entire chart

B. Vertical border

C. Uses color or patterns to identify each data series

D. Horizontal border

E. Both axes form a border for this

Diff: 2

Objective: E3.01 Create a Basic Chart

91) Match the following terms with their description:

I. Line chart

II. Pie chart

III. Bar chart

IV. Column chart

V. Sparkline

A. Uses horizontal bars

B. Chart resides in one cell

C. Line connect data points

D. Uses slices to display data points

E. Uses vertical bars

Diff: 1

Objective: E3.02 Use other Methods to Create a Chart

92) Match the following terms with their description:

I. Data label

II. Data point

III. Data series

IV. Data table

V. Legend

A. A group of data points

B. Shows the precise value of a data point

C. Helps to distinguish between various data series

D. A precise value in a chart

E. A grid used to plot data in a chart

Diff: 2

Objective: E3.02 Use other Methods to Create a Chart

93) Match the following terms with their description (since the options are very similar, pick the most complete, descriptive answer):

I. Clustered column chart

II. Stacked column chart

III. Column chart

IV. 100% stacked column chart

V. 3-D chart

A. Changes individual data points to percentages

B. Adds an additional dimension to your chart

C. Columns are set side by side

D. Compares individual points to the whole category

E. Compares values across categories

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

94) Match the following terms with their description:

I. Combo chart

II. X Y (scatter) chart

III. Stock chart

IV. Area chart

V. Surface chart

A. One variable is plotted on the horizontal axis and the other on the vertical axis

B. Colors are used between the lines

C. Uses two dimensions and a continuous curve

D. Combines two chart types

E. Subtypes include: High-Low-Close, Open-High-Low-Close, Volume-High-Low-Close, and Volume-Open-High-Low-Close

Diff: 1

Objective: E3.02 Use other Methods to Create a Chart

95) Match the following terms with their description:

I. Radar

II. Histogram

III. Area

IV. X Y (scatter) chart

V. Combo chart

A. Often used in educational, scientific, and medical experiments

B. Similar to a column chart

C. Used for two different but related data types

D. Spokes radiate from the center to the outer edges

E. Similar to a line chart

Diff: 3

Objective: E3.02 Use other Methods to Create a Chart

96) Match the following terms with their description:

I. Chart element

II. Chart filter

III. Chart sheet

IV. Chart style

V. Chart title

A. Decides what is hidden or displayed in a chart

B. Sets the formatting of the chart

C. Contains no spreadsheet data

D. Describes the entire chart

E. This helps make a chart clearer.

Diff: 2

Objective: E3.04 Add and Format Chart Elements