Filters
Question type

Study Flashcards

Match the following terms with their description:

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

Correct Answer

Quick Layout
Alt Text
Accessibility Compliance
Sparklines
Data labels

Match the following terms with their description:

Premises
Sizing handles
Chart font color
Triangle with white fill
Task pane
Diagonal black triangles
Responses
Used to show that all chart category options are not visible
A window of options
The default is Black, Text 1, Lighter 35%.
Used to show that all chart category options are visible
Seen as 8 circles

Correct Answer

Sizing handles
Chart font color
Triangle with white fill
Task pane
Diagonal black triangles

How many variations of the stock chart does Excel have?


A) 1
B) 2
C) 3
D) 4

Correct Answer

verifed

verified

Where does the primary axis display on a Combo chart?


A) Top
B) Bottom
C) Right side
D) Left side

Correct Answer

verifed

verified

Which chart element cannot be chosen from the Chart Elements dialog box?


A) Axis Titles
B) Chart Title
C) Format Back Wall
D) Error Bars

Correct Answer

verifed

verified

Which chart type is a visual "dashboard" of your data?


A) Bar chart
B) Sparkline
C) Line chart
D) Column chart

Correct Answer

verifed

verified

Excel uses ________ to determine what categories are visible in a chart.

Correct Answer

verifed

verified

chart filt...

View Answer

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

Correct Answer

verifed

verified

ScreenTip,...

View Answer

Picking a chart ________ will allow you to change several formatting elements at the same time.

Correct Answer

verifed

verified

It is good practice to delete any blank rows or columns before creating a chart.

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

Correct Answer

verifed

verified

If you are not sure which chart type to pick, it may be helpful to click ________ Charts in the Chart group.

Correct Answer

verifed

verified

In a stacked column chart the data must be ________.

Correct Answer

verifed

verified

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

If your chart is intended for presentation, as opposed to printing, you should use a(n)________ background.

Correct Answer

verifed

verified

In a(n)________ column chart data appears as side by side columns.

Correct Answer

verifed

verified

Effective charts never overwhelm an audience.

Correct Answer

verifed

verified

In rare cases you can chart text entries.

Correct Answer

verifed

verified

The ________ axis is the vertical axis.

Correct Answer

verifed

verified

In a column chart the horizontal axis displays the ________.

Correct Answer

verifed

verified

Showing 81 - 100 of 100

Related Exams

Show Answer