Exam 16: Inserting and Formatting Charts

A(n) _________ is a fusion of two or more chart types in a single graph, such as a column chart and a line chart. A)treemap chart B)area chart C)combo chart D)sunburst chart

(Short Answer)

4.9/5

(43)

Question 41

Which of the following describes a pie chart?

(Multiple Choice)

4.8/5

(40)

Question 42

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

(Multiple Choice)

4.9/5

(29)

Question 43

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

(Multiple Choice)

4.8/5

(39)

Question 44

Identify a true statement about data source of pie charts.

(Multiple Choice)

4.8/5

(33)

Question 45

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?

(Multiple Choice)

4.8/5

(30)

Question 46

Judith, a management student, creates a graph showing the number of start-ups commenced in her country in the year 2015. She uses a pie chart to represent her data. Judith, while reviewing her graph, feels that she should change the colors of the pies since she had used a dark colored background. In this scenario, Judith should click the _____ to change the color of the pies.

(Multiple Choice)

4.7/5

(38)

Question 47

Which of the following describes a line chart?

(Multiple Choice)

4.8/5

(36)

Question 48

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

(True/False)

4.9/5

(36)

Question 49

In Microsoft Excel 2016, charts are used to:

(Multiple Choice)

4.9/5

(38)

Question 50

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.

(True/False)

4.9/5

(37)

Question 51

In Microsoft Excel Charts, a _________ is the range that contains the data to display in a chart. A)data type B)chart area C)chart element D)data source

(Short Answer)

4.8/5

(38)

Question 52

In Microsoft Excel Charts, a _________ is a set of values that represent data for one item in a chart. A)category B)cluster C)quotient D)legend

(Short Answer)

4.8/5

(39)

Question 53

The _________ button is used to create data bars. A)What-If Analysis B)Conditional Formatting C)Data Validation D)Forecast Sheet

(Short Answer)

4.8/5

(41)

Question 54

A _________ is a horizontal bar that is always placed in the cell containing the value it represents. A)space bar B)data bar C)taskbar D)toolbar

(Short Answer)

4.8/5

(42)

Question 55

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

(Multiple Choice)

4.8/5

(33)

Question 56

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

(Multiple Choice)

4.8/5

(46)

Question 57

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.

(True/False)

4.7/5

(36)

Question 58

The _________ tab provides a gallery of column chart layouts and a gallery of column chart styles and access to the individual chart elements you can include on a column chart. A)Chart Tools Design B)Chart Tools Format C)Chart Tools Data D)Chart Tools View

(Short Answer)

4.8/5

(39)

Question 59

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

(Multiple Choice)

4.8/5

(36)

Question 60

Showing 41 - 60 of 74

A(n) _________ is a fusion of two or more chart types in a single graph, such as a column chart and a line chart. A)treemap chart B)area chart C)combo chart D)sunburst chart

Which of the following describes a pie chart?

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

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

Identify a true statement about data source of pie charts.

Which of the following describes a line chart?

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

In Microsoft Excel 2016, charts are used to:

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.

In Microsoft Excel Charts, a _________ is the range that contains the data to display in a chart. A)data type B)chart area C)chart element D)data source

In Microsoft Excel Charts, a _________ is a set of values that represent data for one item in a chart. A)category B)cluster C)quotient D)legend

The _________ button is used to create data bars. A)What-If Analysis B)Conditional Formatting C)Data Validation D)Forecast Sheet

A _________ is a horizontal bar that is always placed in the cell containing the value it represents. A)space bar B)data bar C)taskbar D)toolbar

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

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

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.

The _________ tab provides a gallery of column chart layouts and a gallery of column chart styles and access to the individual chart elements you can include on a column chart. A)Chart Tools Design B)Chart Tools Format C)Chart Tools Data D)Chart Tools View

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

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

A(n) _________ is a fusion of two or more chart types in a single graph, such as a column chart and a line chart. ​ A)treemap chart B)area chart C)combo chart D)sunburst chart

Which of the following describes a pie chart? ​

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

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

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

Which of the following describes a line chart? ​

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

In Microsoft Excel 2016, charts are used to: ​

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

In Microsoft Excel Charts, a _________ is the range that contains the data to display in a chart. ​ A)data type B)chart area C)chart element D)data source

In Microsoft Excel Charts, a _________ is a set of values that represent data for one item in a chart. ​ A)category B)cluster C)quotient D)legend

The _________ button is used to create data bars. ​ A)What-If Analysis B)Conditional Formatting C)Data Validation D)Forecast Sheet

A _________ is a horizontal bar that is always placed in the cell containing the value it represents. ​ A)space bar B)data bar C)taskbar D)toolbar

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

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

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

The _________ tab provides a gallery of column chart layouts and a gallery of column chart styles and access to the individual chart elements you can include on a column chart. ​ A)Chart Tools Design B)Chart Tools Format C)Chart Tools Data D)Chart Tools View

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

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

A(n) _________ is a fusion of two or more chart types in a single graph, such as a column chart and a line chart. A)treemap chart B)area chart C)combo chart D)sunburst chart

Which of the following describes a pie chart?

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

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

Identify a true statement about data source of pie charts.

Which of the following describes a line chart?

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

In Microsoft Excel 2016, charts are used to:

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.

In Microsoft Excel Charts, a _________ is the range that contains the data to display in a chart. A)data type B)chart area C)chart element D)data source

In Microsoft Excel Charts, a _________ is a set of values that represent data for one item in a chart. A)category B)cluster C)quotient D)legend

The _________ button is used to create data bars. A)What-If Analysis B)Conditional Formatting C)Data Validation D)Forecast Sheet

A _________ is a horizontal bar that is always placed in the cell containing the value it represents. A)space bar B)data bar C)taskbar D)toolbar

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

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

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.

The _________ tab provides a gallery of column chart layouts and a gallery of column chart styles and access to the individual chart elements you can include on a column chart. A)Chart Tools Design B)Chart Tools Format C)Chart Tools Data D)Chart Tools View

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