Question 1

The Chart Tools appear on the Ribbon with three contextual tabs that do NOT include ____.

Accepted Answer

The three contextual tabs that appear on the Ribbon under Chart Tools are Design, Layout, and Format. Style is not one of the tabs that appear.

Question 2

A chart template formats the chart based on the colors, fonts, and effects associated with the workbook's theme.

Accepted Answer

A chart template saves the chart type, layout, and formatting, allowing you to apply the same settings to another chart, but it does not depend on the workbook's theme for its formatting.

Question 3

Embedded charts are useful when you want to print a chart next to the data the chart illustrates.

Accepted Answer

Embedded charts are inserted onto the worksheet where the data is located, allowing them to be printed together for better understanding and analysis.

Question 4

You use special chart text formatting tools to make changes to the fonts used in the chart.

Accepted Answer

The answer of You use special chart text formatting tools...

Question 5

To make changes to an element's fill, border color, border style, shadow, 3-D format, alignment, and so forth, you need to open the Chart Elements dialog box.

Accepted Answer

To make changes to an element's fill, border color, border style, shadow, 3-D format, alignment, and so forth, you typically use the Format Pane, not the Chart Elements dialog box.

Question 6

A bar chart, sometimes called an XY chart, shows the relationship between two categories of data.

Accepted Answer

A bar chart, also called a column chart, represents data through rectangular bars of equal width where the length or height of the bar corresponds to the value of the data. An XY chart, on the other hand, is a type of chart that represents numerical values in two dimensions, with the horizontal x-axis representing one variable and the vertical y-axis representing another variable.

Question 7

You can rename a chart sheet like any other worksheet. Right-click its sheet tab, and then click ____ on the shortcut menu.

Accepted Answer

To rename a chart sheet in Excel, you need to right-click on the sheet tab and select "Rename" from the shortcut menu. This will allow you to edit the name of the chart sheet. A "Text box" option is not available in the shortcut menu for a chart sheet. "File name" and "Chart name" are not correct options for renaming a chart sheet.

Question 8

You can keep a chart's height and width in the same proportion by pressing the Shift key as you drag a corner sizing handle.

Accepted Answer

When you press the Shift key while resizing a chart in Excel, it maintains its proportional height and width.

Question 9

In Excel, the chart data, called the record source , is stored in a range of cells in the worksheet.

Accepted Answer

In Excel, the data used to create a chart is referred to as the data source, not the record source. The data source consists of the range of cells that contain the data to be represented in the chart.

Question 10

When you select the data source for a chart, you should also include the text you want to use as labels in the chart.

Accepted Answer

This is because the labels in the chart are typically derived from the data source, and if they are not included in the selection, they will not appear in the chart.

Question 11

Pie charts can be harder to design because you must designate which data should be used on each axis.

Accepted Answer

Pie charts do not have axes. They display data as slices of a circle where each slice represents a portion of the whole data set.

Question 12

All chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart.

Accepted Answer

Different types of charts are designed to display different types of data and not all data can be accurately represented by all chart types. For example, categorical data is better suited for pie charts while numerical data is better suited for scatter charts.

Question 13

Axes are lines that establish a relationship between data in a chart; most charts have a horizontal x-axis and a vertical y-axis.

Accepted Answer

This statement is true. Axes are lines that help to organize and display the data in a chart or graph. The x-axis is the horizontal line and typically represents the independent variable, while the y-axis is the vertical line and usually represents the dependent variable.

Question 14

You open the Insert Chart dialog box by clicking the Dialog Box Launcher in the ____ group on the Insert tab.

Accepted Answer

The Insert Chart dialog box can be opened by clicking the Dialog Box Launcher, which is represented by a small arrow icon, in the Charts group on the Insert tab in Microsoft Excel.

Question 15

The chart element called ____ is the graphical representation of all of the data series.

Accepted Answer

The plot area is the graphical representation of all the data series in a chart. The chart area refers to the entire chart including axis labels, legend, and title. The data area refers to the range of cells in the worksheet that contain the data being charted. Data markers are the individual data points plotted in the chart.

Question 16

A pie chart is similar to the column chart, but columns are replaced by points connected by a line.

Accepted Answer

A pie chart is not similar to a column chart. In a pie chart, data is displayed as slices of a circular pie, while in a column chart, data is displayed as vertical columns.

Question 17

A chart sheet does not have worksheet cells and cannot contain data or formulas.

Accepted Answer

A chart sheet is a separate sheet in a workbook that only contains a chart. It does not have any worksheet cells or the ability to contain data or formulas like a regular worksheet.

Question 18

You can delete a selected chart by pressing the F2 key.

Accepted Answer

Pressing the F2 key edits the selected chart, but does not delete it. To delete a chart, you can select it and then press the Delete key or right-click and select "Delete" from the context menu.

Question 19

When you select the chart style, click a 3-D chart subtype to create a 3-D chart.

Accepted Answer

To create a 3-D chart, you need to select a 3-D chart subtype after selecting the chart style.

Question 20

The chart types are available on the ____ tab in the Charts group.

Accepted Answer

The Insert tab includes various options for inserting charts, including the Chart Types button in the Charts group.

Quiz 14: Excel Lesson 8: Working With Charts