Question 1

You can explode only one pie slice in a pie chart. ​

Accepted Answer

In a pie chart, you can explode multiple slices, not just one, to emphasize them or make the chart more visually appealing.

Question 2

When data bars are used with negative values, the data bars originate from the bottom of a cell with negative bars extending to the right and positive bars extending to the left. ​

Accepted Answer

When data bars are used with negative values, the data bars for positive values extend to the right, and the bars for negative values extend to the left, both originating from the cell's midpoint.

Question 3

Which of the following describes a line chart? ​
A)It c ompares values from different categories.
B)It displays all the levels of a hierarchy.
C)It is used within a pie chart .
D)It combines two or more data types to make the data easy to visualize.

Accepted Answer

A line chart is primarily used to display trends over time or categories, making it effective for comparing different values across categories.

Question 4

Changing a value in a data source after creating a chart does not reflect on the existing chart. ​

Accepted Answer

When you change a value in a data source after creating a chart, the chart automatically updates to reflect the new data, assuming the chart is linked to the data source.

Question 5

You can change the appearance of the lines and data markers in a line chart using the Marker Options in the Format Data Series pane. ​

Accepted Answer

In the Format Data Series pane, you can use the Marker Options to customize the appearance of the lines and data markers in a line chart, including their type, size, and color.

Question 6

In Microsoft Excel 2016, charts are used to: ​
A)represent data in rows and columns.
B)illustrate numbers.
C)emphasize geographical features in maps.
D)change a page's orientation.

Accepted Answer

Charts are used to illustrate numbers and make data easier to understand.

Question 7

In the accompanying image of Microsoft Excel 2016, box "A" points to the _____. ​ ​

A)data form
B)data bar
C)data series
D)data pane

Accepted Answer

The answer of In the accompanying image of Microsoft Excel...

Question 8

The chart styles are located in the Chart Layouts group, which is available on the Chart Tools Format tab. ​

Accepted Answer

Chart styles are located in the Chart Styles group, not the Chart Layouts group, and they are found on the Chart Tools Design tab, not the Format tab.

Question 9

In the accompanying image of Microsoft Excel 2016, the selected range of cells represents a _____. ​ ​

A)data frame
B)data bar
C)data source
D)data pane

Accepted Answer

The answer of In the accompanying image of Microsoft Excel...

Question 10

Column charts are used only when there is one data series. ​

Accepted Answer

Column charts can be used for displaying multiple data series, not just one, by comparing values across categories.

Question 11

Sparklines can be inserted anywhere within the workbook and can represent data from several rows or columns. ​

Accepted Answer

Sparklines are small, simple charts that can be inserted into individual cells in Excel, allowing them to represent data from multiple rows or columns within the workbook.

Question 12

Which of the following is a true statement about charts in Excel? ​
A)You can enter legends only within the top portion of the chart area.
B)You can insert animations to a chart.
C)You can create custom chart types based on the built-in charts.
D)You can choose only from two types of charts-pie and bar chart.

Accepted Answer

Excel allows users to create custom chart types based on the built-in charts, providing flexibility in how data is visualized.

Question 13

In a pie chart, each pie slice always represents _____. ​
A)the entire data source
B)one data series value
C)one-fourth of a data series value
D)20% of the sum of the data series values

Accepted Answer

Each pie slice in a pie chart represents one data series value, showing how it compares to the whole in terms of percentage or proportion.

Question 14

Which of the following describes a pie chart? ​
A) It compares relative values of different categories to the whole. ​
B)It indicates values by the height of columns.
C)It displays the high, low, opening, and closing prices of stocks.
D)It represents a data source within a single cell.

Accepted Answer

A pie chart is used to show the proportions of a whole, where each slice represents a part of the whole in relation to its size.

Question 15

A combination chart can combine only two chart types in a single graph. ​

Accepted Answer

A combination chart can combine more than two chart types in a single graph, allowing for complex data visualization that can include various types of information simultaneously.

Question 16

A bar chart is a column chart turned on its side so that the length of each bar is based on its value. ​

Accepted Answer

A bar chart is essentially a column chart rotated 90 degrees, where the bars are horizontal instead of vertical, and the length of each bar represents its value.

Question 17

The horizontal axis is the axis along the side of the chart that shows the range of values from all of the data series plotted on the chart. ​

Accepted Answer

The horizontal axis, also known as the x-axis, typically represents categories or time intervals, while the vertical axis (y-axis) shows the range of values.

Question 18

Pie charts are typically used when the data consists of values drawn from categories that follow a sequential order at evenly spaced intervals. ​

Accepted Answer

Pie charts are best used for showing the parts of a whole, where the categories do not have a natural order or sequence.

Question 19

Sparklines cannot be used for column charts. ​

Accepted Answer

Sparklines can be used for column charts, among other types, to represent data trends in a compact form within a cell in Excel or similar applications.

Question 20

Gridlines appear by default on line charts and column charts. ​

Accepted Answer

Gridlines are typically displayed by default in line charts and column charts to improve readability and help users better understand the scale and context of the data being presented.

Quiz 16: Inserting and Formatting Charts

You can explode only one pie slice in a pie chart. ​

When data bars are used with negative values, the data bars originate from the bottom of a cell with negative bars extending to the right and positive bars extending to the left. ​

Which of the following describes a line chart? ​

Changing a value in a data source after creating a chart does not reflect on the existing chart. ​

You can change the appearance of the lines and data markers in a line chart using the Marker Options in the Format Data Series pane. ​

In Microsoft Excel 2016, charts are used to: ​

In the accompanying image of Microsoft Excel 2016, box "A" points to the _____. ​ ​

The chart styles are located in the Chart Layouts group, which is available on the Chart Tools Format tab. ​

In the accompanying image of Microsoft Excel 2016, the selected range of cells represents a _____. ​ ​

Column charts are used only when there is one data series. ​

Sparklines can be inserted anywhere within the workbook and can represent data from several rows or columns. ​

Which of the following is a true statement about charts in Excel? ​

In a pie chart, each pie slice always represents _____. ​

Which of the following describes a pie chart? ​

A combination chart can combine only two chart types in a single graph. ​

A bar chart is a column chart turned on its side so that the length of each bar is based on its value. ​

The horizontal axis is the axis along the side of the chart that shows the range of values from all of the data series plotted on the chart. ​

Pie charts are typically used when the data consists of values drawn from categories that follow a sequential order at evenly spaced intervals. ​

Sparklines cannot be used for column charts. ​

Gridlines appear by default on line charts and column charts. ​

You can explode only one pie slice in a pie chart.

When data bars are used with negative values, the data bars originate from the bottom of a cell with negative bars extending to the right and positive bars extending to the left.

Which of the following describes a line chart?

Changing a value in a data source after creating a chart does not reflect on the existing chart.

You can change the appearance of the lines and data markers in a line chart using the Marker Options in the Format Data Series pane.

In Microsoft Excel 2016, charts are used to:

In the accompanying image of Microsoft Excel 2016, box "A" points to the _____.

The chart styles are located in the Chart Layouts group, which is available on the Chart Tools Format tab.

In the accompanying image of Microsoft Excel 2016, the selected range of cells represents a _____.

Column charts are used only when there is one data series.

Sparklines can be inserted anywhere within the workbook and can represent data from several rows or columns.

Which of the following is a true statement about charts in Excel?

In a pie chart, each pie slice always represents _____.

Which of the following describes a pie chart?

A combination chart can combine only two chart types in a single graph.

A bar chart is a column chart turned on its side so that the length of each bar is based on its value.

The horizontal axis is the axis along the side of the chart that shows the range of values from all of the data series plotted on the chart.

Pie charts are typically used when the data consists of values drawn from categories that follow a sequential order at evenly spaced intervals.

Sparklines cannot be used for column charts.

Gridlines appear by default on line charts and column charts.