CSC Chapter 3 & 4
25) Which of the following is not a chart element? A) Chart foreground B) Chart title C) Axis title D) Gridlines
Answer: A
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.
Answer: B
13) Which chart type is not listed in the All Charts window? A) Treemap B) Sparkline C) Histogram D) Waterfall
Answer: B
26) The plot area is surrounded by how many axes? A) 1 B) 2 C) 3 D) It depends on the chart type selected.
Answer: B
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
Answer: B, D, A, E, C
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%.
Answer: B, E, A, C, D
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
Answer: C, D, A, E, B
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
Answer: C,D,E,A,B
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.
Answer: D
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
Answer: D, A, E, B, C
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
Answer: D, B, A, E, C
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.
Answer: D, C, A, B, E
29) What does Excel not determine about the value axis when you create a chart?
Average value
23) Which chart type displays the data horizontally?
Bar
36) Which chart type cannot be displayed as a sparkline?
Bar chart
2) Which axis in a chart displays the descriptive labels for the data points?
Category
22) Which chart type displays the data vertically?
Column
76) ________ charts are the most effective when they have seven or fewer categories.
Column
20) What chart type can display two different chart types at the same time?
Combo
3) Which of the following is not a chart element?
Data area
37) A parallel range is one that consists of the same starting point of another range, but can have a different end point.
FALSE
38) As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.
FALSE
39) In rare cases you can chart text entries.
FALSE
28) Which chart element cannot be chosen from the Chart Elements dialog box?
Format Back Wall
6) What is not true about tables in Excel?
Row headings stay on the screen automatically.
80) When you point to a chart element Excel displays a(n) ________ with the name of the element.
Screen Tip
55) The Chart Styles gallery displays style options for the selected chart only.
TRUE
65) The ________ axis is the vertical axis.
Y, Vertical, Value
85) Excel uses ________ to determine what categories are visible in a chart.
chart filters
71) In a(n) ________ column chart data appears as side by side columns.
clustered
63) A(n) ________ is a cell that contains a value used in a chart.
data point
66) The ________ is the visual key to a chart.
legend
84) When you want to create a chart you first need to select a data ________.
source
86) A(n) ________ is a type of chart which fits in one cell.
sparkline
78) In a ________ column chart the data must be additive.
stacked
79) A(n) ________ column chart displays the relationship of data points to the whole category.
stacked
2) Data ________ is the organization method used to manage multiple data points within a dataset.
structure
81) Picking a chart ________ will allow you to change several formatting elements at the same time.
style
18) As a general rule, Pie charts should be limited to how many slices?
7
24) How many sizing handles are found on embedded charts?
8
6) Which of the following, when included, distorts the effectiveness of charting data points?
Aggregates
27) In the task pane, what does a diagonal black triangle next to a chart category indicate?
All the category's options are displayed.
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.
Answer: A
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
Answer: A
87) Match the following terms with their description: Parallel range Alt Text Exploded pie chart Arrange 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
Answer: C, A, E, B, D
34) What can you not do from the Select Data Source dialog box?
Change chart type
83) In a(n) ________ Excel uses a check mark to indicate which chart categories are displayed in a chart.
Chart Filter
30) What is not found on the Chart Elements List?
Chart Type
33) What icon is not displayed when you select a chart?
Chart Types
8) Which of the following is not a chart type?
Circle
16) Which chart type is best when you want to chart two unrelated data types?
Combo chart
40) Including the column and row labels in a chart makes the chart harder to understand.
FALSE
46) To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.
FALSE
48) A stacked column chart displays multiple columns for each category.
FALSE
49) When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.
FALSE
50) You can enter data or formulas on a chart sheet.
FALSE
51) A chart sheet can hold, at most, two charts.
FALSE
53) To understand a chart, you need to include the chart data.
FALSE
54) A chart style effects the formatting of the chart itself, but not the chart data.
FALSE
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.
FALSE
1) Which of the following is not a freeze option?
Freeze Section
4) What is not true about an effective chart?
It always contains more than one series.
19) Where does the primary axis display on a Combo chart?
Left side
32) In the task pane, what does a diagonal white triangle next to a chart category indicate?
None of the category's options are displayed.
9) A 100% stacked column chart is similar to which other chart in that it converts values to percentages?
Pie
17) What chart type represents data as spokes going from the center to the outer edge of the chart?
Radar
75) If you are not sure which chart type to pick, it may be helpful to click ________ Charts in the Chart group.
Recommended
5) What is not a purpose of using an effective chart?
Reveals even subtle errors in formulas
35) Which chart type is a visual "dashboard" of your data?
Sparkline
41) It is good practice to delete any blank rows or columns before creating a chart.
TRUE
42) When you are creating a chart, it is important to select parallel ranges.
TRUE
43) Effective charts never overwhelm an audience.
TRUE
44) Pie charts can only display one data series.
TRUE
45) When you want to chart two related types of data, the Combo chart is perfect.
TRUE
47) You might want to avoid using 3-D charts because they can distort the appearance of the data.
TRUE
52) You can link to a cell as the title of a chart.
TRUE
56) Even after selecting a data source for a chart you can still apply various filters on one or more series.
TRUE
58) Excel normally uses all the selected data in creating a chart.
TRUE
59) You can switch the rows and columns in a chart to communicate a different perspective on your data.
TRUE
60) The range used for a sparkline can include more than one row.
TRUE
61) Sparklines do not include the normal chart labels.
TRUE
5) What data does Excel print by default?
The entire dataset on the active sheet
3) When you have frozen rows and columns, what happens when you press the Ctrl+Home combination?
The first unfrozen cell becomes the active cell.
31) In a pie chart which of the following is a good reason for using category data labels rather than the legend?
They are easier to read.
4) By default, Excel prints page in what order?
Top-left section, bottom-left section, top-right section, and bottom-right section
7) Which axis in a chart displays incremental numbers for the data points?
Value
21) In a bar chart, which axis displays the categories?
Vertical
1) What should you not select when selecting data for a chart?
Worksheet titles
72) ________ charts are often used to represent data in educational, scientific, and medical experiments.
X Y Scatter
62) The ________ axis helps measure data from left to right in a graph.
X, Horizontal, Category
69) The ________ axis helps measure data from top to bottom in a chart.
Y, Vertical, Value
70) Do not include data ________ (such as totals or averages) and individual values in the same chart.
aggregates
82) If your chart is intended for presentation, as opposed to printing, you should use a(n) ________ background.
black, dark
73) In a column chart the horizontal axis displays the ________.
categories
64) To select nonadjacent ranges press and hold the ________ key while selecting the nonadjacent ranges.
control, CTRL
74) A bar chart uses ________ bars.
horizontal
77) If you wanted to show trends over set periods of time, you probably want to use a(n) ________ chart.
line
67) A data ________ is a group of related data points.
series
68) A group of data points used in a graph become a data ________.
series
15) Which axis displays incremental numbers to identify the approximate values of data points?
value axis
