Filters
Question type

Study Flashcards

A data ________ is a group of related data points.

Correct Answer

verifed

verified

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

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) B) and D)
F) A) and D)

Correct Answer

verifed

verified

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


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

E) A) and D)
F) C) and D)

Correct Answer

verifed

verified

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


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

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

Correct Answer

verifed

verified

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


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

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

Correct Answer

verifed

verified

Which chart type displays the data horizontally?


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

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Scatter, X...

View Answer

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


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

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

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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) B) and C)
F) None of the above

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Which chart type displays the data vertically?


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

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

Correct Answer

verifed

verified

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


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

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

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

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

Correct Answer

verifed

verified

Match the following terms with their description:

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

Correct Answer

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

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

A) True
B) False

Correct Answer

verifed

verified

Match the following terms with their description:

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

Correct Answer

Data series
Legend
Data table
Data label
Data point

A bar chart uses ________ bars.

Correct Answer

verifed

verified

Showing 41 - 60 of 100

Related Exams

Show Answer