Exam 3: Charts

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags
Match the following terms with their description:
Chart element
Decides what is hidden or displayed in a chart
Chart sheet
Describes the entire chart
Chart title
Sets the formatting of the chart
Correct Answer:
Verified
Premises:
Responses:
Chart element
Decides what is hidden or displayed in a chart
Chart sheet
Describes the entire chart
Chart title
Sets the formatting of the chart
Chart style
Contains no spreadsheet data
Chart filter
This helps make a chart clearer.
(Matching)
4.9/5
(38)

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

(Short Answer)
4.9/5
(33)

Sparklines do not include the normal chart labels.

(True/False)
4.7/5
(36)

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

(Multiple Choice)
4.8/5
(30)

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

(True/False)
4.9/5
(38)

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

(Multiple Choice)
4.8/5
(33)

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

(True/False)
4.7/5
(35)

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

(True/False)
4.7/5
(36)

What is not found on the Chart Elements List?

(Multiple Choice)
4.9/5
(37)

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

(True/False)
4.9/5
(39)

What is a disadvantage of a stacked column chart?

(Multiple Choice)
4.9/5
(41)

In a bar chart,which axis displays the categories?

(Multiple Choice)
5.0/5
(27)

The ________ is the visual key to a chart.

(Short Answer)
4.8/5
(31)

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

(Short Answer)
4.9/5
(38)

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

(Short Answer)
4.8/5
(34)

The ________ axis is the vertical axis.

(Short Answer)
4.8/5
(34)

Which of the following is not a chart element?

(Multiple Choice)
4.7/5
(34)
Match the following terms with their description:
Alt Text
Helps you use predefined layouts
Quick Layout
Can be read by various devices
Data labels
Examples include:Line,column,win/loss.
Correct Answer:
Verified
Premises:
Responses:
Alt Text
Helps you use predefined layouts
Quick Layout
Can be read by various devices
Data labels
Examples include:Line,column,win/loss.
Sparklines
Easier to read than a legend
Accessibility Compliance
Applying features to make it easier on disabled users
(Matching)
4.8/5
(30)
Match the following terms with their description:
Radar
Used for two different but related data types
X Y (scatter)chart
Similar to a column chart
Area
Often used in educational,scientific,and medical experiments
Correct Answer:
Verified
Premises:
Responses:
Radar
Used for two different but related data types
X Y (scatter)chart
Similar to a column chart
Area
Often used in educational,scientific,and medical experiments
Combo chart
Spokes radiate from the center to the outer edges
Histogram
Similar to a line chart
(Matching)
4.9/5
(35)
Match the following terms with their description:
Arrange
One or more pieces are separated from the others
Alt Text
Text based interpretation
Exploded pie chart
Moves an object backward or forward
Correct Answer:
Verified
Premises:
Responses:
Arrange
One or more pieces are separated from the others
Alt Text
Text based interpretation
Exploded pie chart
Moves an object backward or forward
Chart filter
Helps you to focus on particular data
Parallel range
Has the same starting and ending point
(Matching)
4.9/5
(38)
Showing 81 - 100 of 100
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)