Filters
Question type

Study Flashcards

What is a disadvantage of a stacked column chart?


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.

Correct Answer

verifed

verified

The ________ is the visual key to a chart.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

In a bar chart,which axis displays the categories?


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

Correct Answer

verifed

verified

The ________ axis is the vertical axis.

Correct Answer

verifed

verified

Which of the following is not a chart element?


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

Correct Answer

verifed

verified

When you point to a chart element Excel displays a(n)________ with the name of the element.

Correct Answer

verifed

verified

ScreenTip,...

View Answer

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


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

Correct Answer

verifed

verified

Match the following terms with their description:

Premises
Chart element
Chart sheet
Chart title
Chart style
Chart filter
Responses
Decides what is hidden or displayed in a chart
Describes the entire chart
Sets the formatting of the chart
Contains no spreadsheet data
This helps make a chart clearer.

Correct Answer

Chart element
Chart sheet
Chart title
Chart style
Chart filter

Match the following terms with their description:

Premises
Arrange
Alt Text
Exploded pie chart
Chart filter
Parallel range
Responses
One or more pieces are separated from the others
Text based interpretation
Moves an object backward or forward
Helps you to focus on particular data
Has the same starting and ending point

Correct Answer

Arrange
Alt Text
Exploded pie chart
Chart filter
Parallel range

In the task pane,what does a diagonal white triangle next to a chart category indicate?


A) All the category's options are displayed.
B) None of the category's options are displayed.
C) There are no options for this category.
D) Every option for this category have already been chosen.

Correct Answer

verifed

verified

Sparklines do not include the normal chart labels.

Correct Answer

verifed

verified

Match the following terms with their description:

Premises
Radar
X Y (scatter)chart
Area
Combo chart
Histogram
Responses
Used for two different but related data types
Similar to a column chart
Often used in educational,scientific,and medical experiments
Spokes radiate from the center to the outer edges
Similar to a line chart

Correct Answer

Radar
X Y (scatter)chart
Area
Combo chart
Histogram

Match the following terms with their description:

Premises
Alt Text
Quick Layout
Data labels
Sparklines
Accessibility Compliance
Responses
Helps you use predefined layouts
Can be read by various devices
Examples include:Line,column,win/loss.
Easier to read than a legend
Applying features to make it easier on disabled users

Correct Answer

Alt Text
Quick Layout
Data labels
Sparklines
Accessibility Compliance

What is not found on the Chart Elements List?


A) Chart Type
B) Data Table
C) Gridlines
D) Legend

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

You can link to a cell as the title of a chart.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Showing 81 - 100 of 100

Related Exams

Show Answer