Excel Chapter 4: Testbank Quiz
Individual data value
Data point
Group of related data values
Data series
Graphical presentation of data
Data visualization
If you only want to print the chart on a worksheet, select the chart first, then choose the __________________ option.
Print Selected Chart
The __________________ tool is a contextual tool that provides single-click access to charts and PivotTables.
Quick Analysis
The __________________ feature analyzes your data and suggests which chart would best represent your data.
Recommended Charts
a ________ chart is very common as a statistical tool depicting the correlation between the two variables. (1 point) a. scatter b. column c. combination d. bar
a. scatter
A(n) ________ chart is useful when the sum of the data values is as important as the individual items. (1 point) a. stacked bar b. sunburst c. area d. bar
a. stacked bar
A ________ chart displays hierarchical data. (1 point) a. sunburst b. stacked bar c. Scatter d. combination
a. sunburst
The combination of the graphical presentation of data with a focus on qualitative understanding is called data ________. (1 point) a. visualization b. persuasion c. development d. hypothesis
a. visualization
A(n) __________________ chart stacks a series of colored layers and can be used to see trends over a period of time.
area
Chart layouts are available in the ________ tab. (1 point) a. Chart Styles group on the Chart Tools b. Chart Layouts group on the Design c. Chart Layouts group on the Chart Tools d. Chart Styles group on the Design
b. Chart Layouts group on the Design
In Excel, there are ________ types of trendlines. (1 point) a. 5 b. 6 c. 2 d. 4
d. 4
Which of the following is NOT a common readability issue that should be avoided when creating a chart? (1 point) a. Check the color scheme to ensure that the text is readable. b. Information or labeling is misleading. c. Move data labels, and remove excess information. d. Add a chart title that conveys context of time and scope.
d. Add a chart title that conveys context of time and scope.
A chart element can be easily removed by selecting the element and pressing ________. (1 point) a. Esc b. Alt + Delete c. Ctrl + Delete d. Delete
d. Delete
________ are small charts that are embedded into the cells in a worksheet. (1 point) a. Data bars b. Data points c. Trendlines d. Sparklines
d. Sparklines
A ________ is a graphic component that is overlaid onto data in worksheet cells. (1 point) a. data point b. sparkline c. trendline d. data bar
d. data bar
The graphic components that are overlaid onto data in worksheet cells are called __________________
data bars
The Quick Analysis tool quickly analyzes a selection in a worksheet and recommends chart types that best fit your data. (1 point) True False
false
The Recommended Charts feature offers single-click access to formatting, charts, formulas, PivotTables, and sparklines. (1 point) True False
false
Trendlines help gauge the size of the bars, columns, or data lines. (1 point) True False
false
When a chart is created, it is automatically placed on a chart sheet. (1 point) True False
false
When a chart is selected, the Chart Formatting Control will appear below the chart. (1 point) True False
false
When you click an existing chart, you initially activate the legend. (1 point) True False
false
The best chart to display how stocks you own have performed over the past year is the __________________ chart.
line
A(n) __________________ chart represents a percent to a whole.
pie
A data __________________ is an individual value in a data series
point
When a chart is selected, a(n) __________________ border surrounds the data that represents the legend labels.
purple
If you wanted to see if there is relationship between the miles per hour over the speed limit recorded on a ticket and the amount of the resulting fine, you would use a(n) __________________ chart
scatter
A group of related data values to be charted is a data __________________
series
o resize a chart, click and drag a(n) __________________
sizing handle
Small charts that are inserted into a cell are called __________________
sparklines
A(n) __________________ bar chart can be used when the sum of the data values is as important as the individual items.
stacked
A(n) __________________ chart displays hierarchical data through the use of rings.
sunburst
A common method used to emphasize a(n) scatter chart is to add a(n) __________________
trendline
A chart is like a picture, where a picture is worth 1,000 words. (1 point) True False
true
A chart sheet is a special worksheet that is dedicated to displaying chart objects. (1 point) True False
true
A legend is considered to be a chart index. (1 point) True False
true
A scatter chart shows the relationship between two numeric variables. (1 point) True False
true
Any action that can be completed in the Chart Formatting Control can also be completed through the Chart Tools contextual tab. (1 point) True False
true
As the data moves up or down, the moving average trendline will curve and adjust. (1 point) True False
true
Bar charts are similar to column charts. (1 point) True False
true
Chart sizes can be locked so they do not resize when columns or rows are resized. (1 point) True False
true
Charts are a critical component of data visualization. (1 point) True False
true
Click outside a chart object or press Esc to deselect an object. (1 point) True False
true
In business, it is important to present a well-designed chart because the chart can become a reflection on you and your company. (1 point) True False
true
Stacked bar charts can be useful when you want to see how the individual parts add up to create the entire length of each bar. (1 point) True False
true
The default display of gridlines in Excel is to display the major gridlines and hide the minor gridlines. (1 point) True False
true
The first task that needs to take place when creating a chart is o organize the data. (1 point) True False
true
You can resize a chart by clicking and dragging a sizing handle. (1 point) True False
true
Data __________________ is the graphical presentation of data focusing on qualitative understanding.
visualization
There are __________________ types of sparklines
3
You should use the __________________ effect and rotation of a chart conservatively.
3-D
There are __________________ types of trendlines.
4
When a chart is selected, the __________________ contextual tab appears on the ribbon.
Chart Tools
Chart styles are located in the ________ tab. (1 point) a. Chart Styles group on the Chart Tools Design b. Chart Formats group on the Chart Tools Design c. Chart Formats group on the Chart Design d. Chart Styles group on the Chart Design
a. Chart Styles group on the Chart Tools Design
To open the Format Chart Area task pane, right-click the chart border, and then select ________. (1 point) a. Format Chart Area b. Chart Formatting dialog box c. Chart Properties d. Format Properties
a. Format Chart Area
The ________ analyzes data with visual summaries, patterns, and trends. (1 point) a. Ideas feature b. Live Preview c. Quick Analysis tool d. Recommended Charts feature
a. Ideas feature
A(n) ________ chart is a variation of a stacked line chart that emphasizes the magnitude of change over time and visually depicts a trend. (1 point) a. area b. bar c. combination d. column
a. area
From a chart sheet, a chart will print ________. (1 point) a. as a full page b. Charts cannot be printed from a chart sheet. c. with two on a page d. with four on a page
a. as a full page
A(n) ________ chart is similar to a column chart except the data is horizontal instead of vertical. (1 point) a. bar b. combination c. pie d. area
a. bar
If a chart is selected, a(n) ________ border represents the data series. (1 point) a. blue b. purple c. orange d. green
a. blue
A(n) ________ chart displays two different types of data by using multiple chart types in a single chart object. (1 point) a. combination b. Scatter c. column d. area
a. combination
The lines that go across charts to help gauge the size of the bars, columns, or data lines are called ________. (1 point) a. gridlines b. trendlines c. data points d. area grids
a. gridlines
In Excel, the default is to display the ________. (1 point) a. major gridlines b. trendlines c. minor gridlines d. major and minor gridlines
a. major gridlines
A ________ chart is used to show the relationship of the parts to the whole. (1 point) a. pie b. line c. stacked column d. Scatter
a. pie
Which of the following is NOT true about modifying axes? (1 point) a. The Format Axis task pane can be used to manually set the axis options. b. Excel knows best in regard to formatting the axes; thus, if it seems to crowded, it probably is not. c. The x-axis and y-axis scales are automatically created through a mathematical algorithm within Excel. d. The default Excel scale minimum and maximum values are set automatically on the basis of the data.
b. Excel knows best in regard to formatting the axes; thus, if it seems to crowded, it probably is not.
The ________ tool is a contextual tool that appears when you select data in a worksheet (1 point) a. Insert Charts b. Quick Analysis c. Sparklines d. Quick Chart
b. Quick Analysis
A(n) ________ chart is useful for comparing data sets that are categorized. (1 point) a. area b. column c. Scatter d. combination
b. column
A group of related data values to be charted is a(n) ________. (1 point) a. analysis c. data point d. data bar
b. data series
If a chart is inserted on the same worksheet as the data, it is ________ on the worksheet. (1 point) a. a chart sheet b. embedded c. integrated d. wrapped
b. embedded
A ________ chart is used to communicate trends over time. (1 point) a. column b. line c. pie d. stacked column
b. line
An individual data value in a data series is a data ________. (1 point) a. mark b. point c. bar d. series
b. point
If a chart is selected, a(n) ________ border surrounds the data that represents the legend labels. (1 point) a. orange b. purple c. green d. blue
b. purple
The underlying data for a chart and labels is the ________ data. (1 point) a. source b. worksheet c. link d. workbook
b. worksheet
A(n) __________________ chart displays a horizontal representation of categorical data.
bar
Once data in a worksheet is selected, the ________ offers single-click access to formatting, charts, formulas, PivotTables, and sparklines. (1 point) a. Ideas feature b. Live Preview c. Quick Analysis tool d. Recommended Charts feature
c. Quick Analysis tool
Which of the following is NOT a common issue that should be avoided when creating a chart? (1 point) a. Too much information is on the chart. b. Users dislike the color scheme. c. The incorrect chart type is used. d. Chart has issues with readability.
c. The incorrect chart type is used.
The ________ is an index within a chart that provides information about the data. (1 point) a. x-axis labels b. y-axis labels c. legend d. title
c. legend
If a chart is placed on a special worksheet that is dedicated to displaying chart objects, it is ________. (1 point) a. embedded b. an external object c. on a chart sheet d. integrated
c. on a chart sheet
When creating a chart, best practices indicate that you first consider ________. (1 point) a. the data b. how quickly it needs to be created c. the basic design of the chart d. who will be viewing the chart
c. the basic design of the chart
A________ is a line that shows the general direction of the data. (1 point) a. data bar b. sparkline c. trendline d. legend
c. trendline
A(n) __________________ is a special worksheet that only contains chart objects.
chart sheet
A(n) __________________ chart is displayed vertically and is useful for comparing categorized data sets.
column
A(n) __________________ chart displays two different types of data using multiple chart types in a single chart.
combination
Data bars are an option of the __________________ feature.
conditional formatting
When first creating a chart, best practice dictates that you first consider and develop the basic __________________ of the chart.
design
A(n) __________________ chart is a chart that is located on the same worksheet with the data.
embedded
A common method used to emphasize a pie chart is to __________________ a slice.
explode
A chart sheet contains gridlines. (1 point) True False
false
A column chart is a quantitative chart that shows growth or change in totals. (1 point) True False
false
A group of related data values to be charted are called data points. (1 point) True False
false
A line chart is used to display a percent to a whole. (1 point) True False
false
A pie chart shows trends over time. (1 point) True False
false
A sparkline is a type of conditional formatting. (1 point) True False
false
An individual data value is a data series. (1 point) True False
false
It is simple to create a perfect chart the first time you create it. (1 point) True False
false
In a chart, the __________________ is an index that identifies the data.
legend
__________________ are lines that help determine the size of the bars, columns, or data lines.
gridlines
Businesses have three primary objectives in charting: data analysis, __________________ .testing, and persuasion.
hypothesis