Question 1

What font color does Excel use by default for many of its elements?

Accepted Answer

A) Black, Text 1 
B) Black, Text 1, Darker 35% 
C) Black, Text 1, Lighter 35% 
D) Black, Text 1, Lighter 50% 
A) Black, Text 1 
B) Black, Text 1, Darker 35% 
C) Black, Text 1, Lighter 35% 
D) Black, Text 1, Lighter 50%

Question 2

A bar chart uses ________ bars.

Accepted Answer

The answer of A bar chart uses ________ bars....

Question 3

Match between columns
                        Premises: Stock chart
Area chart
Combo chart
X Y (scatter)chart
Surface chart

Accepted Answer

The Answer of Colors are used between the lines and is...

Question 4

You can switch the rows and columns in a chart to communicate a different perspective on your data.

Accepted Answer

A) True 
 B)False

Question 5

In a Chart Filter Excel uses a(n)________ to indicate which chart categories are displayed in a chart.

Accepted Answer

The answer of In a Chart Filter Excel uses a(n)________...

Question 6

A 100% stacked column chart is similar to what other chart in that it converts values to percentages?

Accepted Answer

A) Clustered column 
B) Radar 
C) Line 
D) Pie 
A) Clustered column 
B) Radar 
C) Line 
D) Pie

Question 7

A group of data points used in a graph become a data ________.

Accepted Answer

The answer of A group of data points used in...

Question 8

Which chart type displays the data horizontally?

Accepted Answer

A) Pie 
B) Radar 
C) Bar 
D) Column 
A) Pie 
B) Radar 
C) Bar 
D) Column

Question 9

________ charts are often used to represent data in educational, scientific, and medical experiments.

Accepted Answer

Scatter, X

Question 10

A(n)________ is a cell that contains a value used in a chart.

Accepted Answer

The answer of A(n)________ is a cell that contains a...

Question 11

What does Excel not determine about the value axis when you create a chart?

Accepted Answer

A) Incremental value 
B) Start value 
C) End value 
D) Average value 
A) Incremental value 
B) Start value 
C) End value 
D) Average value

Question 12

Which chart type displays the data vertically?

Accepted Answer

A) Pie 
B) Radar 
C) Bar 
D) Column 
A) Pie 
B) Radar 
C) Bar 
D) Column

Question 13

A data ________ is a group of related data points.

Accepted Answer

The answer of A data ________ is a group of...

Question 14

In a pie chart which of the following is a good reason for using category data labels rather than the legend?

Accepted Answer

A) They reveal more information. 
B) They take up less space. 
C) They are easier to format. 
D) They are easier to read. 
A) They reveal more information. 
B) They take up less space. 
C) They are easier to format. 
D) They are easier to read.

Question 15

You might want to avoid using 3-D charts because they can distort the appearance of the data.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: Data series
Legend
Data table
Data label
Data point

Accepted Answer

The Answer of Helps to distinguish between various data series is...

Question 17

What can you not do from the Select Data Source dialog box?

Accepted Answer

A) Change chart data range 
B) Delete a data series 
C) Change chart type 
D) Add chart data series 
A) Change chart data range 
B) Delete a data series 
C) Change chart type 
D) Add chart data series

Question 18

To understand a chart you need to include the chart data.

Accepted Answer

A) True 
 B)False

Question 19

What is not true about an effective chart?

Accepted Answer

A) It always contains more than one series. 
B) It is clear. 
C) It is easy to understand. 
D) It is useful. 
A) It always contains more than one series. 
B) It is clear. 
C) It is easy to understand. 
D) It is useful.

Question 20

Which group on the Design tab would you select if you wanted to change the source information in the chart?

Accepted Answer

A) Series 
B) Data 
C) Format 
D) Insert 
A) Series 
B) Data 
C) Format 
D) Insert

What font color does Excel use by default for many of its elements?

A bar chart uses ________ bars.

You can switch the rows and columns in a chart to communicate a different perspective on your data.

In a Chart Filter Excel uses a(n)________ to indicate which chart categories are displayed in a chart.

A 100% stacked column chart is similar to what other chart in that it converts values to percentages?

A group of data points used in a graph become a data ________.

Which chart type displays the data horizontally?

________ charts are often used to represent data in educational, scientific, and medical experiments.

A(n)________ is a cell that contains a value used in a chart.

What does Excel not determine about the value axis when you create a chart?

Which chart type displays the data vertically?

A data ________ is a group of related data points.

In a pie chart which of the following is a good reason for using category data labels rather than the legend?

You might want to avoid using 3-D charts because they can distort the appearance of the data.

What can you not do from the Select Data Source dialog box?

To understand a chart you need to include the chart data.

What is not true about an effective chart?

Which group on the Design tab would you select if you wanted to change the source information in the chart?

Introduction to Excel

Formulas and Functions

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 3: Charts

What font color does Excel use by default for many of its elements?

A bar chart uses ________ bars.

You can switch the rows and columns in a chart to communicate a different perspective on your data.

In a Chart Filter Excel uses a(n)________ to indicate which chart categories are displayed in a chart.

A 100% stacked column chart is similar to what other chart in that it converts values to percentages?

A group of data points used in a graph become a data ________.

Which chart type displays the data horizontally?

________ charts are often used to represent data in educational, scientific, and medical experiments.

A(n)________ is a cell that contains a value used in a chart.

What does Excel not determine about the value axis when you create a chart?

Which chart type displays the data vertically?

A data ________ is a group of related data points.

In a pie chart which of the following is a good reason for using category data labels rather than the legend?

You might want to avoid using 3-D charts because they can distort the appearance of the data.

What can you not do from the Select Data Source dialog box?

To understand a chart you need to include the chart data.

What is not true about an effective chart?

Which group on the Design tab would you select if you wanted to change the source information in the chart?

Introduction to Excel

Formulas and Functions

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters