Excel Chapter 3

10 September 2022
4.7 (114 reviews)
85 test answers

Unlock all answers in this set

Unlock answers (81)
question
What should you not select when selecting data form charts? A)Worksheet Titles B)Column Labels C)Data D)Row Labels
answer
Worksheet titles
question
What can you not do from the Select Data Source Dialog box? A)Add chart data series B)Delete a data series C)Change chart data range D)Change chart type
answer
Change chart type
question
Which of the following is not a chart element? A)Chart Area B)Data Area C)Legend D)Plot Area
answer
Data Area
question
What is not true about an effective chart? A)It always contains more than one series B)It is useful C)It is easy to understand D)It is clear
answer
It always contains more than one series
question
Which axis in a chart displays incremental numbers for the data points? A)Data B)Category C)Value D)Series
answer
Value
question
How many variations of the stock chart does Excel have? A)1 B)2 C)3 D)4
answer
4
question
Including what, distorts the effectiveness of charting data points? A)Too many data points B)Too many series C)Too much variance in the values of the data D)Aggregates
answer
Aggregates
question
What is the disadvantage of a stacked column chart? A)There is a limit as to how many segments can be displayed B)Segments do no end at the same point C)This is only useful for one data series D)Segments do not start at the same point
answer
Segments do not start at the same point
question
Which of the following is not a chart type? A)Bar B)Pie C)Circle D)Line
answer
Circle
question
Which group on the Design tab would you select if you wanted to change the source information in the chart? A) Format B) Data C) Insert D) Series
answer
Data
question
Which tab displays the tools for creating charts? A) Insert B) View C) Chart D) Data
answer
Insert
question
In the task pane, what does a diagonal black triangle next to a chart category indicate? A) Every option for this category have already been chosen. B) None of the category's options are displayed. C) There are no options for this category. D) All the category's options are displayed.
answer
All of the category's options are displayed
question
What is not found on the Chart Elements List? A) Chart Type B) Legend C) Gridlines D) Data Table
answer
Chart type
question
What does Excel not determine about the value axis when you create a chart? A) Average value B) End value C) Start value D) Incremental value
answer
Average Value
question
What is not a purpose of using an effective chart? A) Aids in making informed decisions B) Compares data C) Reveals even subtle errors in formulas D) Reveals trends and patterns
answer
Reveals even subtle errors in formulas
question
A 100% stacked column chart is similar to what other chart in that it converts values to percentages? A) Line B) Clustered column C) Radar D) Pie
answer
Pie
question
As a general rule, Pie charts should be limited to how many slices? A) 9 B) 11 C) 5 D) 7
answer
7
question
Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline? A) Sparkline B) Show C) Style D) Type
answer
Sparkline
question
Which chart type is a visual "dashboard" of your data? A) Column chart B) Line chart C) Sparkline D) Bar chart
answer
Sparkline
question
Which chart type cannot be displayed as a sparkline? A) Line chart B) Column C) Bar chart D) Win/Loss
answer
Bar Chart
question
What icon is not displayed when you select a chart? A) Chart Types B) Chart Filters C) Chart Styles D) Chart Elements
answer
Chart Types
question
In the task pane, what does a diagonal white triangle next to a chart category indicate? A) There are no options for this category. B) All the category's options are displayed. C) Every option for this category have already been chosen. D) None of the category's options are displayed.
answer
None of the category's options are displayed
question
What chart type represents data as spokes going from the center to the outer edge of the chart? A) Surface B) Histogram C) Radar D) Area
answer
Radar
question
In a pie chart which of the following is a good reason for using category data labels rather than the legend? A) They are easier to format. B) They take up less space. C) They are easier to read. D) They reveal more information.
answer
They are easier to read
question
What chart type can display two different chart types at the same time? A) Multiple B) Combination C) Combo D) Mixed
answer
Combo
question
In a bar chart, which axis displays the categories? A) X B) Vertical C) Horizontal D) Z
answer
Vertical
question
What group is not found on the Sparkline Tools Design tab? A) Format B) Type C) Style D) Show
answer
Format
question
How many sizing handle are found on embedded charts? A) 8 B) 6 C) 4 D) 10
answer
8
question
Where does the primary axis display on a Combo chart? A) Left side B) Right side C) Top D) Bottom
answer
Left Side
question
Which chart element cannot be chosen from the Chart Elements dialog box? A) Format Back Wall B) Error Bars C) Chart Title D) Axis Titles
answer
Format back wall
question
Which chart type displays the data horizontally? A) Pie B) Column C) Bar D) Radar
answer
Bar
question
Which of the following is not a chart element? A) Chart title B) Chart foreground C) Axis title D) Gridlines
answer
Chart foreground
question
Which chart type is best when you want to chart two unrelated data types? A) Line chart B) Radar chart C) Combo chart D) Pie chart
answer
Combo Chart
question
Which chart type is preferable when the category names are long? A) Bar B) Column C) Stacked column D) Pie
answer
Bar
question
Which chart type is not listed in the All Charts window? A) Waterfall B) Sparkline C) Treemap D) Histogram
answer
Sparkline
question
36) When you want to create a chart you first need to select a data ________.
answer
Source
question
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
answer
1.C 2.A 3.E 4.B 5.D
question
A(n) ________ is a type of chart which fits in one cell.
answer
Sparkline
question
The ________ axis is the vertical axis.
answer
Y
question
If your chart is intended for presentation, as opposed to printing, you should use a(n) ________ background.
answer
Black
question
To select nonadjacent ranges press and hold the ________ key while selecting the nonadjacent ranges.
answer
Ctrl
question
A bar chart uses ________ bars.
answer
Horizontal
question
In a stacked column chart the data must be ________.
answer
Additive
question
A(n) ________ is a cell that contains a value used in a chart.
answer
Data point
question
A group of data points used in a graph become a data ________.
answer
series
question
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
1.B 2.D 3.A 4.E 5.C
question
The ________ axis helps measure data from top to bottom in a chart.
answer
Y
question
A(n) ________ column chart displays the relationship of data points to the whole category.
answer
stacked
question
When you point to a chart element Excel displays a(n) ________ with the name of the element.
answer
Screen Tip
question
If you are not sure which chart type to pick, it may be helpful to click ________ Charts in the Chart group.
answer
recommended
question
In a column chart the horizontal axis displays the ________.
answer
categories
question
________ charts are often used to represent data in educational, scientific, and medical experiments.
answer
XY Scatter
question
In a(n) ________ column chart data appears as side by side columns.
answer
clustered
question
If you wanted to show trends over set periods of time, you probably want to use a(n) ________ chart.
answer
line
question
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
answer
1.D 2.B 3.E 4.A 5.C
question
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
1.c 2.d 3.a 4.e 5.b
question
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.
answer
1.e 2.a 3.c 4.b 5.d
question
A data ________ is a group of related data points.
answer
series
question
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
1.d 2.c 3.a 4.b 5.e
question
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
1.d 2.b 3.a 4.e 5.c
question
Column charts are the most effective when they have ________ or fewer categories.
answer
7
question
Picking a chart ________ will allow you to change several formatting elements at the same time.
answer
style
question
The ________ axis helps measure data from left to right in a graph.
answer
x
question
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
1.c 2.d 3.e 4.a 5.b
question
Excel uses ________ to determine what categories are visible in a chart.
answer
chart filters
question
True or False:When you want to chart two related types of data, the Combo chart is perfect.
answer
true
question
True or False:A chart sheet can hold, at most, two charts.
answer
False
question
True or False:You cannot enter data or formulas on a chart sheet.
answer
True
question
True or False:It is important to select parallel ranges.
answer
True
question
True or False:Excel normally uses all the selected data in creating a chart.
answer
True
question
True or False:As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.
answer
False
question
True or False:A parallel range is one that consists of the same starting point of another range, but can have a different end point.
answer
False
question
True or False:You can switch the rows and columns in a chart to communicate a different perspective on your data.
answer
True
question
True or False:The range used for a sparkline cannot include more than one row.
answer
False
question
True or False:Pie charts can only display one data series.
answer
True
question
True or False:You might want to avoid using 3-D charts because they can distort the appearance of the data.
answer
True
question
True or False:You can link to a cell as the title of a chart.
answer
True
question
True or False:Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.
answer
False
question
True or False:Effective charts never overwhelm an audience.
answer
True
question
True or False:To understand a chart you need to include the chart data.
answer
False
question
True or False:To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.
answer
False
question
True or False:A stacked column chart displays multiple columns for each category.
answer
False
question
True or False:When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.
answer
False
question
True or False:Even after selecting a data source for a chart you can still apply various filters on one or more series.
answer
True
question
True or False: Sparklines do not include the normal chart labels.
answer
True