Filters
Question type
Study Flashcards

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

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

True

What icon is not displayed when you select a chart?


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

E) All of the above
F) None of the above

Correct Answer

verifed

verified

Match the following terms with their description:

Premises
Area chart
X Y (scatter)chart
Stock chart
Combo chart
Surface chart
Responses
Combines two chart types
Subtypes include:High-Low-Close,Open-High-Low-Close,Volume-High-Low-Close,and Volume-Open-High-Low-Close
Colors are used between the lines
One variable is plotted on the horizontal axis and the other on the vertical axis
Uses two dimensions and a continuous curve

Correct Answer

Area chart
X Y (scatter)chart
Stock chart
Combo chart
Surface chart

Match the following terms with their description (since the options are very similar,pick the most complete,descriptive answer):

Premises
Stacked column chart
100% stacked column chart
3-D chart
Clustered column chart
Column chart
Responses
Adds an additional dimension to your chart
Compares individual points to the whole category
Compares values across categories
Changes individual data points to percentages
Columns are set side by side

Correct Answer

Stacked column chart
100% stacked column chart
3-D chart
Clustered column chart
Column chart

Match the following terms with their description:

Premises
X-axis
Legend
Plot area
Y-axis
Chart area
Responses
Both axes form a border for this
Uses color or patterns to identify each data series
Holds the entire chart
Vertical border
Horizontal border

Correct Answer

X-axis
Legend
Plot area
Y-axis
Chart area

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


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

E) All of the above
F) A) and D)

Correct Answer

verifed

verified

In rare cases you can chart text entries.

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


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

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

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


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

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

A

Which of the following is not a chart type?


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

E) All of the above
F) A) and D)

Correct Answer

verifed

verified

A bar chart uses ________ bars.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

What is not true about an effective chart?


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

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Match the following terms with their description:

Premises
Data point
Data series
Data label
Data table
Legend
Responses
Helps to distinguish between various data series
A group of data points
A precise value in a chart
A grid used to plot data in a chart
Shows the precise value of a data point

Correct Answer

Data point
A precise value in a chart
Data series
A group of data points
Data label
Shows the precise value of a data point
Data table
A grid used to plot data in a chart
Legend
Helps to distinguish between various data series

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

A) True
B) False

Correct Answer

verifed

verified

Showing 1 - 20 of 100

Related Exams

Exam 1

Introduction to Excel

100 Questions

Exam 2

Formulas and Functions

100 Questions

Exam 4

Datasets and Tables

100 Questions

Exam 5

Subtotals, Pivot-tables, and Pivot-charts

100 Questions

Exam 6

What-If Analysis

100 Questions

Exam 7

Specialized Functions

100 Questions

Exam 8

Statistical Functions

100 Questions

Exam 9

Multiple-Sheet Workbook Management

98 Questions

Exam 10

Imports, xml, and Power Add-Ins

95 Questions

Exam 11

Collaboration and Workbook Distribution

96 Questions

Exam 12

Templates, styles, and Macros

97 Questions

Exam 13

Office 2016 Common Features

100 Questions

Show Answer