Question 1

Which of the following is an advantage of overlaying chart elements? ​

Accepted Answer

Overlaying chart elements can help in maximizing the use of space within a chart, thereby making more room for the plot area. This is particularly useful in situations where the chart is dense with information, and clarity is essential. Overlaying does not fix elements to a position, automatically add text, or explode the plot area; those are functions or effects not directly related to the concept of overlaying elements for space efficiency.

Question 2

Lena, a professor, creates a bar graph displaying the performance of her students. She needs to choose a bar graph template with chart elements appropriately placed to suit her requirement. In this scenario, which of the following options should Lena use? ​

Accepted Answer

Quick Layout provides predefined chart layouts with elements like titles, labels, and legends properly arranged, making it suitable for Lena to quickly format her bar graph with the necessary chart elements.

Question 3

Identify a true statement about data source of pie charts. ​

Accepted Answer

Pie charts are designed to show parts of a whole, so including row or column totals would distort the representation of individual parts as it would artificially inflate the total value represented by the pie.

Question 4

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

Accepted Answer

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

Question 5

Which of the following is an accurate statement about overlaying chart elements?

Accepted Answer

Overlaying chart elements allows you to move them to a new location within the chart, providing flexibility in how the chart is presented.

Question 6

Eugene, a financial analyst, collects data on the gross income of people working in different industries. She presents this data in a bar graph. However, she later feels that a line graph will be more appropriate for representing the data. In this scenario, Eugene should click the _____ in the Excel sheet to change the graph type. ​

Accepted Answer

The Chart Tools Design tab in Excel includes options for changing the chart type, which allows users to switch between different forms of graphical representation, such as from a bar graph to a line graph.

Question 7

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

Accepted Answer

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

Question 8

Celina, a Human Resource (HR) manager, creates a graph on an Excel sheet representing the attrition rate in the past five years in her company. She presents the graph such that the graph area occupies the entire worksheet without any worksheet cells. In this case, Celina presents a _____. ​

Accepted Answer

Celina presents a chart sheet, which is a type of Excel sheet dedicated entirely to a chart, allowing the chart to occupy the full worksheet space without displaying the gridlines of worksheet cells.

Question 9

Which of the following is true of a plot area in the chart? ​

Accepted Answer

The plot area in a chart dynamically adjusts its size to accommodate other elements like the chart title, especially when the overall chart area is constrained. This ensures that the chart remains legible and well-organized, even in smaller spaces.

Question 10

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

Accepted Answer

Chart layouts specify which chart elements (like titles, labels, legends) are displayed on a chart and how these elements are formatted, offering a predefined arrangement that can be applied for consistency and visual appeal.

Question 11

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

Double-clicking on the line in the graph typically opens a pane or dialog box with format options specific to that element, allowing for detailed customization such as adding effects like a glowing line.

Question 12

When does the Chart Tools tab appear? ​

Accepted Answer

The Chart Tools tab appears in programs like Microsoft Excel when you create a graph. It provides options for formatting and customizing the chart.

Question 13

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

Accepted Answer

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

Question 14

Which of the following is a method to move a chart from one worksheet to another in a Microsoft Excel workbook? ​

Accepted Answer

Cutting and pasting a chart is a straightforward method to move it from one worksheet to another within the same Excel workbook.

Question 15

Sarah, a microbiologist, collects data on the types of bacteria and the amount of each type of bacteria found in the soil. She creates a 3-D pie chart to represent this data. However, she realizes that the 3-D pie chart lacks clarity and intends to change it to a 2-D pie chart. In this scenario, which of the following options should Sarah use to modify the appearance of the chart? ​

Accepted Answer

The Chart Styles gallery allows users to change the overall appearance of a chart, including switching from a 3-D to a 2-D representation, which would help Sarah improve the clarity of her data visualization.

Question 16

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

Accepted Answer

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

Question 17

Karlo, an environmentalist, collects data on the endangered species and their declining numbers. He presents this data in the form of a bar graph on an Excel sheet. Since this graph needs to be presented to a large audience, Karlo decides to enhance the graph by changing the colors of the bars. In this scenario, Karlo should click the _____ in the Excel sheet. ​

Accepted Answer

The Chart Tools Format tab in Excel allows users to customize the appearance of their charts, including changing the colors of the bars, which is what Karlo intends to do to enhance his presentation.

Question 18

Which of the following is a disadvantage of an embedded chart? ​

Accepted Answer

Embedded charts can cover worksheet cells, potentially hiding data and formulas beneath them. This can be a disadvantage when trying to view or edit the underlying data.

Question 19

You can add or remove a chart title using the _____. ​

Accepted Answer

The Chart Elements button in Excel allows users to add, remove, or modify elements of a chart, such as titles, data labels, and legends.

Question 20

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

The chart title is the descriptive label of a chart, which Bernard intends to change to better represent the growth of his company.

Quiz 16: Inserting and Formatting Charts

Which of the following is an advantage of overlaying chart elements? ​

Lena, a professor, creates a bar graph displaying the performance of her students. She needs to choose a bar graph template with chart elements appropriately placed to suit her requirement. In this scenario, which of the following options should Lena use? ​

Identify a true statement about data source of pie charts. ​

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

Which of the following is an accurate statement about overlaying chart elements?

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

Celina, a Human Resource (HR) manager, creates a graph on an Excel sheet representing the attrition rate in the past five years in her company. She presents the graph such that the graph area occupies the entire worksheet without any worksheet cells. In this case, Celina presents a _____. ​

Which of the following is true of a plot area in the chart? ​

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

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

When does the Chart Tools tab appear? ​

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

Which of the following is a method to move a chart from one worksheet to another in a Microsoft Excel workbook? ​

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

Which of the following is a disadvantage of an embedded chart? ​

You can add or remove a chart title using the _____. ​

Which of the following is an advantage of overlaying chart elements?

Lena, a professor, creates a bar graph displaying the performance of her students. She needs to choose a bar graph template with chart elements appropriately placed to suit her requirement. In this scenario, which of the following options should Lena use?

Identify a true statement about data source of pie charts.

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

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

Celina, a Human Resource (HR) manager, creates a graph on an Excel sheet representing the attrition rate in the past five years in her company. She presents the graph such that the graph area occupies the entire worksheet without any worksheet cells. In this case, Celina presents a _____.

Which of the following is true of a plot area in the chart?

Which of the following is a function of chart layouts?

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:

When does the Chart Tools tab appear?

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

Which of the following is a method to move a chart from one worksheet to another in a Microsoft Excel workbook?

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

Which of the following is a disadvantage of an embedded chart?

You can add or remove a chart title using the _____.