Question 1

Bernard, the Chief Executive Officer (CEO) of Where We Go Travels, intends to create a graph representing the growth of his company. After creating the graph, Bernard decides to change the descriptive label of a chart. In this scenario, which of the following chart elements does Bernard want to change? ​

Accepted Answer

A) Chart dialog box 
B) Chart filter 
C) Chart legend 
D) Chart title

Question 2

In a Microsoft Excel worksheet, a(n) _________ is a chart that is an object in a worksheet. ​ 
A)place value chart 
B)embedded chart 
C)album chart 
D)size chart

Accepted Answer

The answer of In a Microsoft Excel worksheet, a(n) _________...

Question 3

Case 16-2 Since extensive data in the form of numbers can be difficult to assimilate, such data are better represented as charts. There are several types of charts available in Microsoft Excel. Choosing the right chart type to represent a data source is important to effectively illustrate a data. A chart type should be chosen based on the number of data series, range of data series values, type of data series etc. ​
Benjamin, a nuclear physicist, needs to represent electron decay at five time intervals for ten different elements. Benjamin thus has five data series for ten category values. In this scenario, Benjamin can use a _____ to represent the data.

Accepted Answer

A) surface chart 
B) line chart 
C) radar chart 
D) pie chart

Question 4

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) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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.

Question 7

In Microsoft Excel charts, which of the following is a function of leader lines? ​

Accepted Answer

A) They help to display an entire chart within a single cell. 
B) They extend the values of the major or minor units across the plot area of a chart. 
C) They connect each data label to its corresponding data marker. 
D) They provide gridlines to an Excel user to convert a 2-D chart to a 3-D chart.

Question 8

Wayne, a senior software engineer, creates a chart using Microsoft Excel that represents the number of projects and types of projects undertaken by a team in the past five years. The chart presents the chart legend below the chart by default. Wayne wants to change the position of the chart legend to the left of the chart. In this scenario, Wayne should click the _____ to change the position of the legend. ​

Accepted Answer

A) Chart Styles button 
B) Chart Elements button 
C) Chart Filter button 
D) Chart Design button

Question 9

Which of the following is a true statement about chart elements in Microsoft Excel? ​

Accepted Answer

A) Excel uses the data series values as the default legend. 
B) An overlaid chart title cannot be edited or formatted. 
C) Excel allows you to edit or replace the default chart title. 
D) Chart elements cannot be placed on top of a chart.

Question 10

Zelda, a mechanical engineer, creates a line graph to illustrate the productivity and quality improvement in her company. She intends to add a glowing effect to the line in the graph. In this scenario, Zelda should: ​

Accepted Answer

A) left-click on the line to open a pane with format options specific to the line. 
B) double-click on the line to open a pane with format options specific to the line. 
C) click on the chart followed by the Chart Filters button to change the format of the line. 
D) click on the chart followed by the Chart Elements button to change the format of the line.

Question 11

Case 16-2 Since extensive data in the form of numbers can be difficult to assimilate, such data are better represented as charts. There are several types of charts available in Microsoft Excel. Choosing the right chart type to represent a data source is important to effectively illustrate data. A chart type should be chosen based on the number of data series, range of data series values, type of data series etc. ​
John, a senior scientist, is involved in a population study. He needs to create a graph based on the data he has collected for the population study. John's data source consists of a single data series whose values should be represented as relative to the whole. In this scenario, John should use a _____ to illustrate his data.

Accepted Answer

A) radar chart 
B) surface chart 
C) pie chart 
D) Venn chart

Question 12

If you select a chart's sequence, the formula displayed in the formula bar uses the _________ function. ​ 
A)SERIES 
B)QUARTILE 
C)LOOKUP 
D)AREAS

Accepted Answer

The answer of If you select a chart's sequence, the...

Question 13

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

A) True 
 B)False

Question 14

Explain how to edit a chart data and add a data series to an existing chart. ​

Accepted Answer

The answer of Explain how to edit a chart data...

Question 15

Case 16-1 George, an environmental scientist, collects information on the types and amount of gases emitted by a cheese processing factory.  ​
George enters the types of gases and the amount of gases emitted in two columns of an Excel sheet. Based on this data he creates a pie chart. In this case, the information typed out by George in the two columns of an Excel sheet is known as a _____.

Accepted Answer

A) data bar 
B) data source 
C) chart element 
D) chart area

Question 16

When does the Chart Tools tab appear? ​

Accepted Answer

A) When you click the Insert tab 
B) When you create a graph 
C) When you select a data source 
D) When you enter a data series

Question 17

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

Accepted Answer

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

Question 18

Michael, the Chief Executive Officer (CEO) of a company, needs to create a graph representing the company's quarterly revenue between the years 2005 and 2015. The data Michael has follows a sequential order which he intends to represent in evenly spaced intervals. In this scenario, which of the following types of graph will be most appropriate for Michael to use? ​

Accepted Answer

A) Pie chart 
B) Line chart 
C) Radar chart 
D) Venn chart

Question 19

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

Accepted Answer

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

Question 20

Which of the following is a function of chart layouts? ​

Accepted Answer

A) They provide blank chart sheets that enable a user to create a chart layout. 
B) They provide options to change the color and effects of each chart element. 
C) They specify which chart elements are displayed and how they are formatted. 
D) They identify the data source that needs to be converted to a chart.

Exam 16: Inserting and Formatting Charts

In a Microsoft Excel worksheet, a(n) _________ is a chart that is an object in a worksheet. A)place value chart B)embedded chart C)album chart D)size chart

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

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

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

In Microsoft Excel charts, which of the following is a function of leader lines?

Which of the following is a true statement about chart elements in Microsoft Excel?

Zelda, a mechanical engineer, creates a line graph to illustrate the productivity and quality improvement in her company. She intends to add a glowing effect to the line in the graph. In this scenario, Zelda should:

If you select a chart's sequence, the formula displayed in the formula bar uses the _________ function. A)SERIES B)QUARTILE C)LOOKUP D)AREAS

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.

Explain how to edit a chart data and add a data series to an existing chart.

When does the Chart Tools tab appear?

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

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

Which of the following is a function of chart layouts?

Exam 16: Inserting and Formatting Charts

In a Microsoft Excel worksheet, a(n) _________ is a chart that is an object in a worksheet. ​ A)place value chart B)embedded chart C)album chart D)size chart

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

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

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

In Microsoft Excel charts, which of the following is a function of leader lines? ​

Which of the following is a true statement about chart elements in Microsoft Excel? ​

Zelda, a mechanical engineer, creates a line graph to illustrate the productivity and quality improvement in her company. She intends to add a glowing effect to the line in the graph. In this scenario, Zelda should: ​

If you select a chart's sequence, the formula displayed in the formula bar uses the _________ function. ​ A)SERIES B)QUARTILE C)LOOKUP D)AREAS

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. ​

Explain how to edit a chart data and add a data series to an existing chart. ​

When does the Chart Tools tab appear? ​

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

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

Which of the following is a function of chart layouts? ​

In a Microsoft Excel worksheet, a(n) _________ is a chart that is an object in a worksheet. A)place value chart B)embedded chart C)album chart D)size chart

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

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

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

In Microsoft Excel charts, which of the following is a function of leader lines?

Which of the following is a true statement about chart elements in Microsoft Excel?

Zelda, a mechanical engineer, creates a line graph to illustrate the productivity and quality improvement in her company. She intends to add a glowing effect to the line in the graph. In this scenario, Zelda should:

If you select a chart's sequence, the formula displayed in the formula bar uses the _________ function. A)SERIES B)QUARTILE C)LOOKUP D)AREAS

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.

Explain how to edit a chart data and add a data series to an existing chart.

When does the Chart Tools tab appear?

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

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

Which of the following is a function of chart layouts?