Exam 16: Inserting and Formatting Charts

In Microsoft Excel, a(n) _________ is a page in a workbook that contains only a graph and no worksheet cells. A)optical mark recognition sheet B)perspex sheet C)data sheet D)chart sheet

Free

(Short Answer)

4.9/5

(45)

Question 1

Correct Answer:

Verified

chart sheet

Han, a realtor, wants to create a chart representing the price variation of land in three different states across the period 2011-2015. For this, she has to present three data series in a single chart. In this scenario, which of the following types of charts would be most suitable for Han's purpose?

Free

(Multiple Choice)

4.8/5

(36)

Question 2

Correct Answer:

Verified

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

Free

(Multiple Choice)

4.8/5

(42)

Question 3

Correct Answer:

Verified

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. Natalia, a weather reporter, wants to plot a graph using the rainfall data in the past 20 years in a particular state. She intends to present the graph in a single cell to identify the maximum and minimum rainfall. In this scenario, Natalia should use a _____ to represent her data.

(Multiple Choice)

4.8/5

(37)

Question 4

Which of the following is a difference between column charts and pie charts?

(Multiple Choice)

4.9/5

(39)

Question 5

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

(Multiple Choice)

4.9/5

(42)

Question 6

Volya, a Human Resource manager, creates a pie chart in Excel representing the productivity of each team in her company in the last quarter. The team that achieved maximum productivity should standout from the rest of the teams. In this case, Volya should _____ to emphasize the team that has achieved maximum productivity.

(Multiple Choice)

4.8/5

(38)

Question 7

Priya, a financial analyst, intends to graphically represent the household income of people in five cities over the past 10 years. The data that she presents in a chart is not relative to the whole household income. In this case, which of the following types of charts is most suited for Priya to illustrate the data series in a chart?

(Multiple Choice)

4.7/5

(36)

Question 8

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

(Multiple Choice)

4.8/5

(35)

Question 9

Column and bar charts differ from pie charts in that bar charts:

(Multiple Choice)

5.0/5

(41)

Question 10

Gridlines appear by default on line charts and column charts.

(True/False)

4.9/5

(24)

Question 11

In Microsoft Excel Charts, _________ are individual parts of a chart such as the chart area, the chart title, the plot area, data markers, and a legend. A)chart sectors B)chart elements C)chart metrics D)chart plotters

(Short Answer)

4.9/5

(44)

Question 12

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

(Multiple Choice)

4.9/5

(41)

Question 13

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

(True/False)

4.7/5

(44)

Question 14

What is a sparkline? Explain how a sparkline can be inserted and its use.

(Essay)

4.8/5

(36)

Question 15

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.

(Multiple Choice)

4.8/5

(41)

Question 16

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

(True/False)

4.9/5

(35)

Question 17

The _________ button next to the selected chart displays a list of the data series and category values used in the chart . A)Chart Elements B)Chart Styles C)Chart Filters D)Chart Layouts

(Short Answer)

4.8/5

(43)

Question 18

Sparklines cannot be used for column charts.

(True/False)

4.9/5

(33)

Question 19

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

(True/False)

4.8/5

(35)

Question 20

Showing 1 - 20 of 74

In Microsoft Excel, a(n) _________ is a page in a workbook that contains only a graph and no worksheet cells. A)optical mark recognition sheet B)perspex sheet C)data sheet D)chart sheet

Han, a realtor, wants to create a chart representing the price variation of land in three different states across the period 2011-2015. For this, she has to present three data series in a single chart. In this scenario, which of the following types of charts would be most suitable for Han's purpose?

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

Which of the following is a difference between column charts and pie charts?

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

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

Column and bar charts differ from pie charts in that bar charts:

Gridlines appear by default on line charts and column charts.

In Microsoft Excel Charts, _________ are individual parts of a chart such as the chart area, the chart title, the plot area, data markers, and a legend. A)chart sectors B)chart elements C)chart metrics D)chart plotters

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

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

What is a sparkline? Explain how a sparkline can be inserted and its use.

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

The _________ button next to the selected chart displays a list of the data series and category values used in the chart . A)Chart Elements B)Chart Styles C)Chart Filters D)Chart Layouts

Sparklines cannot be used for column charts.

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

Introduction to Computers and the Internet

Computer Hardware

Computer Software

Computer Networks

The Internet and Email

Security and Privacy

Exploring Windows 10 and Managing Files

Using Edge Mail and People

Introducing Microsoft Office 2016

Creating a Document

Formatting a Long Document

Enhancing a Document

Creating a Workbook

Working With Formulas and Functions

Creating an Advanced Workbook

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Apresentation

Enhancing a Presentation

Integrating Word, Excel, Access and Powerpoint

Filters

Exam 16: Inserting and Formatting Charts

In Microsoft Excel, a(n) _________ is a page in a workbook that contains only a graph and no worksheet cells. ​ A)optical mark recognition sheet B)perspex sheet C)data sheet D)chart sheet

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

Which of the following is a difference between column charts and pie charts? ​

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

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

Column and bar charts differ from pie charts in that bar charts: ​

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

In Microsoft Excel Charts, _________ are individual parts of a chart such as the chart area, the chart title, the plot area, data markers, and a legend. ​ A)chart sectors B)chart elements C)chart metrics D)chart plotters

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

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

What is a sparkline? Explain how a sparkline can be inserted and its use. ​

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

The _________ button next to the selected chart displays a list of the data series and category values used in the chart . ​ A)Chart Elements B)Chart Styles C)Chart Filters D)Chart Layouts

Sparklines cannot be used for column charts. ​

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

Introduction to Computers and the Internet

Computer Hardware

Computer Software

Computer Networks

The Internet and Email

Security and Privacy

Exploring Windows 10 and Managing Files

Using Edge Mail and People

Introducing Microsoft Office 2016

Creating a Document

Formatting a Long Document

Enhancing a Document

Creating a Workbook

Working With Formulas and Functions

Creating an Advanced Workbook

Creating a Database

Maintaining and Querying a Database

Creating Forms and Reports

Creating Apresentation

Enhancing a Presentation

Integrating Word, Excel, Access and Powerpoint

Filters

In Microsoft Excel, a(n) _________ is a page in a workbook that contains only a graph and no worksheet cells. A)optical mark recognition sheet B)perspex sheet C)data sheet D)chart sheet

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

Which of the following is a difference between column charts and pie charts?

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

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

Column and bar charts differ from pie charts in that bar charts:

Gridlines appear by default on line charts and column charts.

In Microsoft Excel Charts, _________ are individual parts of a chart such as the chart area, the chart title, the plot area, data markers, and a legend. A)chart sectors B)chart elements C)chart metrics D)chart plotters

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

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

What is a sparkline? Explain how a sparkline can be inserted and its use.

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

The _________ button next to the selected chart displays a list of the data series and category values used in the chart . A)Chart Elements B)Chart Styles C)Chart Filters D)Chart Layouts

Sparklines cannot be used for column charts.

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