Question 1

Each part of a pie chart is shown as a ____ of the pie.
A) bowl
B) slice
C) serving
D) dish

Accepted Answer

A pie chart is divided into slices that represent each category or data point being measured. The size of each slice is proportional to the value it represents in the whole chart.

Question 2

The chart element called ____ is a grid that displays the data plotted in the chart.
A) data label
B) data series
C) data table
D) data marker

Accepted Answer

A data table is a chart element that displays the data plotted in the chart in a grid format. Data labels refer to individual labels for data points, data series refer to a group of related data points, and data markers refer to the symbols used to plot data points on the chart.

Question 3

You can quickly choose a layout and styles for a selected chart from the Ribbon. Click the ____ tab under Chart Tools on the Ribbon. In the Chart Layouts group, click the chart layout you want to use.
A) Format
B) Edit
C) Styles
D) Design

Accepted Answer

The correct tab to select for choosing a layout and styles for a chart in most spreadsheet and presentation software, like Microsoft Excel or PowerPoint, is the "Design" tab under Chart Tools on the Ribbon. This tab provides options for chart layouts and styles.

Question 4

Businesses often use all of the following EXCEPT ____ charts to illustrate growth over several periods.
A) column
B) bar
C) line
D) pie

Accepted Answer

A pie chart is not an appropriate visualization method to show growth over time as it only displays the proportion of each category in a single period. Column, bar, and line charts are more suitable options for showcasing growth over several periods.

Question 5

A ____ chart shows the relationship of a part to a whole.
A) pie
B) column
C) line
D) scatter

Accepted Answer

A pie chart is specifically designed to show the relationship of parts to a whole. The other chart types listed do not have this same emphasis.

Question 6

Case EX 8-1 Candace wants to create a chart sheet similar to the one shown above. Candace now has the Move Chart dialog box open and wants to name her new chart sheet. Where does she fill in the new name?
A) In the Move sheet box
B) In the New object box
C) In the New sheet box
D) In the Move object box

Accepted Answer

Candace should fill in the new name in the New sheet box.

Question 7

You can change a chart type or subtype at any time. On the Design tab, under Chart Tools on the Ribbon, in the ____ group, click the Change Chart Type button.
A) Type
B) Format
C) Text
D) Style

Accepted Answer

The "Change Chart Type" button is specifically for changing the type or subtype of a chart, which is an aspect of its visual representation. The other options listed (Format, Text, Style) are not directly related to the type/subtype of a chart.

Question 8

You can use the Ribbon to select chart elements. Click the Format tab or the ____ tab on the Ribbon. In the Current Selection group, click the arrow next to the Chart Elements box.
A) Chart
B) Home
C) Layout
D) Design

Accepted Answer

The Layout tab on the Ribbon provides options for formatting chart elements, and specifically has a group called Current Selection where you can use the Chart Elements box to select specific elements of the chart. The Home tab relates to general text editing and formatting, and the Design tab is focused on selecting chart layouts and styles. The Chart tab does not exist in Excel, so A is not a valid option.

Question 9

To create a sparkline, in the Sparklines group on the ___________________ tab, click the button corresponding to the type of sparkline you want to create.

Accepted Answer

The answer of To create a sparkline, in the Sparklines...

Question 10

A selected chart element is surrounded by a ____.
A) fill box
B) selection box
C) text box
D) border

Accepted Answer

A selected chart element is surrounded by a selection box, which allows the user to manipulate and edit the element. A fill box and text box may be present within the selected element, but are not specifically associated with the selection process. A border may already be present, but is not necessarily indicative of a selected element.

Question 11

Case EX 8-2 Paco wants to change some of the elements in his chart, including the fill and border color. What type of dialog box does Paco need to access to make these changes?
A) Format dialog box
B) Chart dialog box
C) Style dialog box
D) Layout dialog box

Accepted Answer

The Format dialog box will allow Paco to make changes to elements such as fill and border color in his chart. The Chart dialog box is focused on modifying the data and layout of the chart itself, while the Style dialog box is used to apply pre-designed visual styles to the chart. The Layout dialog box is used to adjust the placement and size of chart elements.

Question 12

FIGURE EX 8-1  In Figure EX 8-1 above, the phrase Median Income is the ____.
A) legend
B) vertical axis title
C) horizontal axis title
D) chart title

Accepted Answer

The answer of FIGURE EX 8-1  In Figure EX...

Question 13

Case EX 8-2 Paco wants to change some of the elements in his chart, including the fill and border color. On a separate chart that he is working on, Paco needs to access the Format dialog box for the chart legend. First, he selects the chart he wants to edit. Then, on the ____ tab under Chart Tools on the Ribbon, in the Current Selection group, he clicks the Format Selection button.
A) Layout
B) Page Layout
C) Data
D) Format

Accepted Answer

The Format tab under Chart Tools contains options for formatting chart elements, including fill and border color. Additionally, the Format Selection button in the Current Selection group allows Paco to access the Format dialog box for the selected chart element, including the legend on a separate chart.

Question 14

A chart, whether embedded in a worksheet or on a chart sheet, is considered part of a ____.
A) workbook
B) database
C) data file
D) report

Accepted Answer

A chart in Excel is considered part of a workbook, which may contain multiple worksheets and other types of data. It is not part of a database or a data file, although it may visualize or summarize data from those sources. A chart may be included in a report, but is not considered a report itself.

Question 15

The quickest way to select a chart element is to ____.
A) navigate using the Ribbon
B) use the shortcut menus
C) click it with the pointer
D) none of the above

Accepted Answer

Clicking the chart element with the pointer is the easiest and quickest way to select it. The Ribbon and shortcut menus can also be used, but they are not as quick as simply clicking on the element.

Question 16

Case EX 8-1 Candace wants to create a chart sheet similar to the one shown above. Candace wants to move an embedded chart into a chart sheet. To do this, she would click the Chart Tools Design tab on the Ribbon. Then, in the ____ group, click the Move Chart button.
A) Location
B) Move
C) Chart Sheet
D) Chart

Accepted Answer

The correct group to find the "Move Chart" button in the Chart Tools Design tab is the "Location" group. This option allows users to move an embedded chart to a chart sheet.

Question 17

____ charts are also used to illustrate a company's market share in comparison to its competitors.
A) Column
B) Bar
C) Line
D) Pie

Accepted Answer

Pie charts are commonly used to show the percentage breakdown of a whole, such as a company's market share compared to its competitors.

Question 18

FIGURE EX 8-1  In Figure EX 8-1 above, under Education Pays, the red and blue boxes labeled Men and Women is the ____.
A) legend
B) vertical axis title
C) horizontal axis title
D) chart title

Accepted Answer

The red and blue boxes labeled Men and Women in the figure are representing different categories, and a legend is used to explain the categories in a graph or chart. Therefore, A) legend is the best choice for this question.

Question 19

To access the Format dialog box, select the chart you want to edit. Then, on the Format tab under Chart Tools on the Ribbon, in the Current Selection group, click the ____ button.
A) Format
B) Selection
C) Format Selection
D) Chart Selection

Accepted Answer

To access the Format dialog box for chart editing, the Format Selection button, which is located in the Current Selection group on the Format tab under Chart Tools on the Ribbon, must be clicked.

Question 20

You switch between a chart sheet and a worksheet by clicking the appropriate ____.
A) sheet tabs
B) file name
C) icon
D) data marker

Accepted Answer

Sheet tabs are used to switch between chart sheets and worksheets in Excel. By clicking on the sheet tabs located at the bottom of the Excel window, you can quickly navigate between different sheets in the same workbook.

Quiz 14: Excel Lesson 8: Working With Charts

Each part of a pie chart is shown as a ____ of the pie.

The chart element called ____ is a grid that displays the data plotted in the chart.

You can quickly choose a layout and styles for a selected chart from the Ribbon. Click the ____ tab under Chart Tools on the Ribbon. In the Chart Layouts group, click the chart layout you want to use.

Businesses often use all of the following EXCEPT ____ charts to illustrate growth over several periods.

A ____ chart shows the relationship of a part to a whole.

Case EX 8-1 Candace wants to create a chart sheet similar to the one shown above. Candace now has the Move Chart dialog box open and wants to name her new chart sheet. Where does she fill in the new name?

You can change a chart type or subtype at any time. On the Design tab, under Chart Tools on the Ribbon, in the ____ group, click the Change Chart Type button.

You can use the Ribbon to select chart elements. Click the Format tab or the ____ tab on the Ribbon. In the Current Selection group, click the arrow next to the Chart Elements box.

To create a sparkline, in the Sparklines group on the ___________________ tab, click the button corresponding to the type of sparkline you want to create.

A selected chart element is surrounded by a ____.

Case EX 8-2 Paco wants to change some of the elements in his chart, including the fill and border color. What type of dialog box does Paco need to access to make these changes?

FIGURE EX 8-1 In Figure EX 8-1 above, the phrase Median Income is the ____.

A chart, whether embedded in a worksheet or on a chart sheet, is considered part of a ____.

The quickest way to select a chart element is to ____.

Case EX 8-1 Candace wants to create a chart sheet similar to the one shown above. Candace wants to move an embedded chart into a chart sheet. To do this, she would click the Chart Tools Design tab on the Ribbon. Then, in the ____ group, click the Move Chart button.

____ charts are also used to illustrate a company's market share in comparison to its competitors.

FIGURE EX 8-1 In Figure EX 8-1 above, under Education Pays, the red and blue boxes labeled Men and Women is the ____.

To access the Format dialog box, select the chart you want to edit. Then, on the Format tab under Chart Tools on the Ribbon, in the Current Selection group, click the ____ button.

You switch between a chart sheet and a worksheet by clicking the appropriate ____.