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