Question 1

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 2

Which tab displays the tools for creating charts?

Accepted Answer

A) View 
B) Chart 
C) Insert 
D) Data 
A) View 
B) Chart 
C) Insert 
D) Data

Question 3

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 4

It is important to select parallel ranges.

Accepted Answer

A) True 
 B)False

Question 5

Pie charts can only display one data series.

Accepted Answer

A) True 
 B)False

Question 6

To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.

Accepted Answer

A) True 
 B)False

Question 7

What is not a purpose of using an effective chart?

Accepted Answer

A) Compares data 
B) Reveals trends and patterns 
C) Reveals even subtle errors in formulas 
D) Aids in making informed decisions 
A) Compares data 
B) Reveals trends and patterns 
C) Reveals even subtle errors in formulas 
D) Aids in making informed decisions

Question 8

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

Accepted Answer

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

Question 9

A(n)________ column chart displays the relationship of data points to the whole category.

Accepted Answer

The answer of A(n)________ column chart displays the relationship of...

Question 10

Match between columns
                        Premises: Chart style
Chart title
Chart sheet
Chart element
Chart filter

Accepted Answer

The Answer of Decides what is hidden or displayed in is...

Question 11

As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.

Accepted Answer

A) True 
 B)False

Question 12

When you want to create a chart you first need to select a data ________.

Accepted Answer

The answer of When you want to create a chart...

Question 13

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 14

Which chart type is preferable when the category names are long?

Accepted Answer

A) Column 
B) Bar 
C) Pie 
D) Stacked column 
A) Column 
B) Bar 
C) Pie 
D) Stacked column

Question 15

Match between columns
                        Premises: Chart filter
Parallel range
Exploded pie chart
Alt Text
Arrange

Accepted Answer

The Answer of Has the same starting and ending point is...

Question 16

Where does Excel display the Quick Analysis tool?

Accepted Answer

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

Question 17

The Chart Styles gallery displays style options for the selected chart only.

Accepted Answer

A) True 
 B)False

Question 18

A stacked column chart displays multiple columns for each category.

Accepted Answer

A) True 
 B)False

Question 19

When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.

Accepted Answer

A) True 
 B)False

Question 20

What should you not select when selecting data for a chart?

Accepted Answer

A) Column labels 
B) Row labels 
C) Data 
D) Worksheet titles 
A) Column labels 
B) Row labels 
C) Data 
D) Worksheet titles

Which of the following is not a chart type?

Which tab displays the tools for creating charts?

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

It is important to select parallel ranges.

Pie charts can only display one data series.

To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.

What is not a purpose of using an effective chart?

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

A(n)________ column chart displays the relationship of data points to the whole category.

As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.

When you want to create a chart you first need to select a data ________.

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

Which chart type is preferable when the category names are long?

Where does Excel display the Quick Analysis tool?

The Chart Styles gallery displays style options for the selected chart only.

A stacked column chart displays multiple columns for each category.

When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.

What should you not select when selecting data for a 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

Which of the following is not a chart type?

Which tab displays the tools for creating charts?

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

It is important to select parallel ranges.

Pie charts can only display one data series.

To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.

What is not a purpose of using an effective chart?

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

A(n)________ column chart displays the relationship of data points to the whole category.

As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.

When you want to create a chart you first need to select a data ________.

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

Which chart type is preferable when the category names are long?

Where does Excel display the Quick Analysis tool?

The Chart Styles gallery displays style options for the selected chart only.

A stacked column chart displays multiple columns for each category.

When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.

What should you not select when selecting data for a 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