Question 1

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

Accepted Answer

A) Chart Layout button 
B) Chart Format button 
C) Chart Elements button 
D) Chart Styles button 
A) Chart Layout button 
B) Chart Format button 
C) Chart Elements button 
D) Chart Styles button

Question 2

A _________ is the type of chart on Microsoft Excel that does not include chart elements such as legends, titles, gridlines, or axes. ​ 
A)sparkline 
B)gridline 
C)timeline 
D)streamline

Accepted Answer

The answer of A _________ is the type of chart...

Question 3

Case 16-1 George, an environmental scientist, collects information on the types and amount of gases emitted by a cheese processing factory.
George decides to present the data on an Excel sheet in the form of bars against X and Y axes. In this scenario, George presents the data in the form of a _____.

Accepted Answer

A)  grid ​ 
B) pivot table 
C) database 
D) chart 
A)  grid ​ 
B) pivot table 
C) database 
D) chart

Question 4

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

A) Chart Styles 
B) Quick Layout 
C) Sparklines 
D) Chart Elements 
A) Chart Styles 
B) Quick Layout 
C) Sparklines 
D) Chart Elements

Question 5

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

Accepted Answer

A) An overlaid chart element cannot be formatted. 
B) It allows you to drag a chart element to a new location. 
C) It does not alter the space for a chart's plot area. 
D) An overlaid pie never overlaps the contents of a chart. 
A) An overlaid chart element cannot be formatted. 
B) It allows you to drag a chart element to a new location. 
C) It does not alter the space for a chart's plot area. 
D) An overlaid pie never overlaps the contents of a chart.

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

In Microsoft Excel, which of the following is true of a chart legend? ​

Accepted Answer

A) It is not applicable for column chart and line chart. 
B) It cannot be edited or formatted once overlaid. 
C) It uses a default black color to identify each data category. 
D) It identifies each data series in a chart. 
A) It is not applicable for column chart and line chart. 
B) It cannot be edited or formatted once overlaid. 
C) It uses a default black color to identify each data category. 
D) It identifies each data series in a chart.

Question 9

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

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

What is a data bar? Describe its features. ​

Accepted Answer

Answers will vary. A data bar is conditi

Question 12

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

A) Chart Tools Design tab 
B) Chart Tools Format tab 
C) Chart Tools Review tab 
D) Chart Tools Data tab 
A) Chart Tools Design tab 
B) Chart Tools Format tab 
C) Chart Tools Review tab 
D) Chart Tools Data tab

Question 13

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

Accepted Answer

A) It makes more space for the plot area. 
B) It fixes the chart elements to a particular position. 
C) It automatically adds text to the chart elements. 
D) It explodes the plot area or a pie. 
A) It makes more space for the plot area. 
B) It fixes the chart elements to a particular position. 
C) It automatically adds text to the chart elements. 
D) It explodes the plot area or a pie.

Question 14

The _________ shows the patterns or relationship between two or more sets of values. ​ 
A)Box & Whisker Chart 
B)Sunburst Chart 
C)X Y (Scatter) Chart 
D)Surface Chart

Accepted Answer

The answer of The _________ shows the patterns or relationship...

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

A _________ is the type of chart on Microsoft Excel that does not include chart elements such as legends, titles, gridlines, or axes. A)sparkline B)gridline C)timeline D)streamline

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?

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

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

In Microsoft Excel, which of the following is true of a chart legend?

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

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

What is a data bar? Describe its features.

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

The _________ shows the patterns or relationship between two or more sets of values. A)Box & Whisker Chart B)Sunburst Chart C)X Y (Scatter) Chart D)Surface Chart

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 the accompanying image of Microsoft Excel 2016, box "A" points to the _____. ​ ​

A _________ is the type of chart on Microsoft Excel that does not include chart elements such as legends, titles, gridlines, or axes. ​ A)sparkline B)gridline C)timeline D)streamline

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

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

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

In Microsoft Excel, which of the following is true of a chart legend? ​

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

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

What is a data bar? Describe its features. ​

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

The _________ shows the patterns or relationship between two or more sets of values. ​ A)Box & Whisker Chart B)Sunburst Chart C)X Y (Scatter) Chart D)Surface Chart

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 the accompanying image of Microsoft Excel 2016, box "A" points to the _____.

A _________ is the type of chart on Microsoft Excel that does not include chart elements such as legends, titles, gridlines, or axes. A)sparkline B)gridline C)timeline D)streamline

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?

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

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

In Microsoft Excel, which of the following is true of a chart legend?

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

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

What is a data bar? Describe its features.

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

The _________ shows the patterns or relationship between two or more sets of values. A)Box & Whisker Chart B)Sunburst Chart C)X Y (Scatter) Chart D)Surface Chart