Question 1

Including the column and row labels in a chart makes the chart harder to understand.

Accepted Answer

A) True 
 B)False  False

Question 2

As a general rule, Pie charts should be limited to how many slices?

Accepted Answer

A) 5 
B) 7 
C) 9 
D) 11 
A) 5 
B) 7 
C) 9 
D) 11 B

Question 3

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

Accepted Answer

X

Question 4

A(n)________ is a type of chart which fits in one cell.

Accepted Answer

The answer of A(n)________ is a type of chart which...

Question 5

If you wanted to show trends over set periods of time, you probably want to use a(n)________ chart.

Accepted Answer

The answer of If you wanted to show trends over...

Question 6

A parallel range is one that consists of the same starting point of another range, but can have a different end point.

Accepted Answer

A) True 
 B)False

Question 7

In the Insert Chart dialog box, after you pick a chart type where are the subtypes listed?

Accepted Answer

A) Bottom left 
B) Bottom right 
C) Top left 
D) Top right 
A) Bottom left 
B) Bottom right 
C) Top left 
D) Top right

Question 8

What is a disadvantage of a stacked column chart?

Accepted Answer

A) Segments do not start at the same point. 
B) Segments do not end at the same point. 
C) There is a limit as to how many segments can be displayed. 
D) This is only useful for one data series. 
A) Segments do not start at the same point. 
B) Segments do not end at the same point. 
C) There is a limit as to how many segments can be displayed. 
D) This is only useful for one data series.

Question 9

What chart type represents data as spokes going from the center to the outer edge of the chart?

Accepted Answer

A) Surface 
B) Area 
C) Radar 
D) Histogram 
A) Surface 
B) Area 
C) Radar 
D) Histogram

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

In a bar chart, which axis displays the categories?

Accepted Answer

A) Horizontal 
B) Vertical 
C) X 
D) Z 
A) Horizontal 
B) Vertical 
C) X 
D) Z

Question 12

Which of the following is not a chart element?

Accepted Answer

A) Chart area 
B) Plot area 
C) Legend 
D) Data area 
A) Chart area 
B) Plot area 
C) Legend 
D) Data area

Question 13

Sparklines do not include the normal chart labels.

Accepted Answer

A) True 
 B)False

Question 14

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 15

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

Accepted Answer

The Answer of Columns are set side by side and is...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

The ________ axis helps measure data from top to bottom in a chart.

Accepted Answer

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

Question 18

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 19

What group is not found on the Sparkline Tools Design tab?

Accepted Answer

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

Question 20

What chart type can display two different chart types at the same time?

Accepted Answer

A) Combo 
B) Combination 
C) Mixed 
D) Multiple 
A) Combo 
B) Combination 
C) Mixed 
D) Multiple

Including the column and row labels in a chart makes the chart harder to understand.

As a general rule, Pie charts should be limited to how many slices?

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

A(n)________ is a type of chart which fits in one cell.

If you wanted to show trends over set periods of time, you probably want to use a(n)________ chart.

A parallel range is one that consists of the same starting point of another range, but can have a different end point.

In the Insert Chart dialog box, after you pick a chart type where are the subtypes listed?

What is a disadvantage of a stacked column chart?

What chart type represents data as spokes going from the center to the outer edge of the chart?

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

In a bar chart, which axis displays the categories?

Which of the following is not a chart element?

Sparklines do not include the normal chart labels.

What icon is not displayed when you select a chart?

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

The ________ axis helps measure data from top to bottom in a chart.

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

What group is not found on the Sparkline Tools Design tab?

What chart type can display two different chart types at the same time?

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

Including the column and row labels in a chart makes the chart harder to understand.

As a general rule, Pie charts should be limited to how many slices?

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

A(n)________ is a type of chart which fits in one cell.

If you wanted to show trends over set periods of time, you probably want to use a(n)________ chart.

A parallel range is one that consists of the same starting point of another range, but can have a different end point.

In the Insert Chart dialog box, after you pick a chart type where are the subtypes listed?

What is a disadvantage of a stacked column chart?

What chart type represents data as spokes going from the center to the outer edge of the chart?

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

In a bar chart, which axis displays the categories?

Which of the following is not a chart element?

Sparklines do not include the normal chart labels.

What icon is not displayed when you select a chart?

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

The ________ axis helps measure data from top to bottom in a chart.

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

What group is not found on the Sparkline Tools Design tab?

What chart type can display two different chart types at the same time?

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