Filters
Question type

Study Flashcards

Excel normally uses all the selected data in creating a chart.

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Including what, distorts the effectiveness of charting data points?


A) Too many series
B) Too many data points
C) Too much variance in the values of the data
D) Aggregates

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

Correct Answer

verifed

verified

Match the following terms with their description:

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

Correct Answer

Radar
Histogram
Combo chart
Area
X Y (scatter)chart

Match the following terms with their description:

Premises
Column chart
Sparkline
Pie chart
Bar chart
Line chart
Responses
Uses slices to display data points
Uses vertical bars
Chart resides in one cell
Line connect data points
Uses horizontal bars

Correct Answer

Column chart
Sparkline
Pie chart
Bar chart
Line chart

Column charts are the most effective when they have ________ or fewer categories.

Correct Answer

verifed

verified

How many sizing handle are found on embedded charts?


A) 4
B) 6
C) 8
D) 10

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

Correct Answer

verifed

verified

A chart style effects the formatting of the chart itself, but not the chart data.

A) True
B) False

Correct Answer

verifed

verified

Which chart type cannot be displayed as a sparkline?


A) Bar chart
B) Line chart
C) Column
D) Win/Loss

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

Correct Answer

verifed

verified

You cannot enter data or formulas on a chart sheet.

A) True
B) False

Correct Answer

verifed

verified

Which chart type is not listed in the All Charts window?


A) Treemap
B) Sparkline
C) Histogram
D) Waterfall

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

Correct Answer

verifed

verified

Match the following terms with their description:

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

Correct Answer

Plot area
Legend
Y-axis
Chart area
X-axis

To select nonadjacent ranges press and hold the ________ key while selecting the nonadjacent ranges.

Correct Answer

verifed

verified

Which chart type is best when you want to chart two unrelated data types?


A) Pie chart
B) Combo chart
C) Line chart
D) Radar chart

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

Correct Answer

verifed

verified

What is not found on the Chart Elements List?


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

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

Correct Answer

verifed

verified

The ________ is the visual key to a chart.

Correct Answer

verifed

verified

The range used for a sparkline cannot include more than one row.

A) True
B) False

Correct Answer

verifed

verified

Which axis in a chart displays incremental numbers for the data points?


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

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

Correct Answer

verifed

verified

Which of the following is not a chart element?


A) Chart foreground
B) Chart title
C) Axis title
D) Gridlines

E) B) and D)
F) A) and D)

Correct Answer

verifed

verified

In the task pane, what does a diagonal black 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.

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

Correct Answer

verifed

verified

Showing 61 - 80 of 100

Related Exams

Show Answer