Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline?

Accepted Answer

A) Sparkline 
B) Type 
C) Show 
D) Style 
A) Sparkline 
B) Type 
C) Show 
D) Style A

Question 3

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

Accepted Answer

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

Question 4

Match between columns
                        Premises: Stacked column chart
100% stacked column chart
3-D chart
Clustered column chart
Column chart

Accepted Answer

The Answer of Adds an additional dimension to your chart is...

Question 5

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 6

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 7

Once a data source is selected for a chart,the only way to change the data source is to start over creating the chart.

Accepted Answer

A) True 
 B)False

Question 8

What icon is not displayed when you select a chart?

Accepted Answer

A) Chart Elements 
B) Chart Types 
C) Chart Styles 
D) Chart Filters 
A) Chart Elements 
B) Chart Types 
C) Chart Styles 
D) Chart Filters

Question 9

Do not use data ________ and individual values in a chart.

Accepted Answer

The answer of Do not use data ________ and individual...

Question 10

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

Accepted Answer

The Answer of Combines two chart types and Subtypes include:High-Low-Close,Open-High-Low-Close,Volume-High-Low-Close,and is...

Question 11

When you want to chart two related types of data,the Combo chart is perfect.

Accepted Answer

A) True 
 B)False

Question 12

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 13

A chart sheet can hold,at most,two charts.

Accepted Answer

A) True 
 B)False

Question 14

The ________ axis helps measure data from left to right in a graph.

Accepted Answer

The answer of The ________ axis helps measure data from...

Question 15

Which of the following is not a chart type?

Accepted Answer

A) Circle 
B) Pie 
C) Bar 
D) Line 
A) Circle 
B) Pie 
C) Bar 
D) Line

Question 16

Even after selecting a data source for a chart you can still apply various filters on one or more series.

Accepted Answer

A) True 
 B)False

Question 17

Match between columns
                        Premises: X-axis
Legend
Plot area
Y-axis
Chart area

Accepted Answer

The Answer of Both axes form a border for this is...

Question 18

A bar chart uses ________ bars.

Accepted Answer

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

Question 19

Which axis in a chart displays the descriptive labels for the data points?

Accepted Answer

A) Category 
B) Value 
C) Data 
D) Series 
A) Category 
B) Value 
C) Data 
D) Series

Question 20

In rare cases you can chart text entries.

Accepted Answer

A) True 
 B)False

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

Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline?

What is not true about an effective chart?

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

Once a data source is selected for a chart,the only way to change the data source is to start over creating the chart.

What icon is not displayed when you select a chart?

Do not use data ________ and individual values in a chart.

When you want to chart two related types of data,the Combo chart is perfect.

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

A chart sheet can hold,at most,two charts.

The ________ axis helps measure data from left to right in a graph.

Which of the following is not a chart type?

Even after selecting a data source for a chart you can still apply various filters on one or more series.

A bar chart uses ________ bars.

Which axis in a chart displays the descriptive labels for the data points?

In rare cases you can chart text entries.

Introduction to Excel

Formulas and Functions

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

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

Office 2016 Common Features

Filters

Exam 3: Charts

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

Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline?

What is not true about an effective chart?

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

Once a data source is selected for a chart,the only way to change the data source is to start over creating the chart.

What icon is not displayed when you select a chart?

Do not use data ________ and individual values in a chart.

When you want to chart two related types of data,the Combo chart is perfect.

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

A chart sheet can hold,at most,two charts.

The ________ axis helps measure data from left to right in a graph.

Which of the following is not a chart type?

Even after selecting a data source for a chart you can still apply various filters on one or more series.

A bar chart uses ________ bars.

Which axis in a chart displays the descriptive labels for the data points?

In rare cases you can chart text entries.

Introduction to Excel

Formulas and Functions

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

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

Office 2016 Common Features

Filters