Exam 3: Charts

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

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

(Multiple Choice)
4.8/5
(33)

How many sizing handle are found on embedded charts?

(Multiple Choice)
4.8/5
(32)

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

(Short Answer)
4.8/5
(42)

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

(True/False)
4.7/5
(42)

What is not found on the Chart Elements List?

(Multiple Choice)
4.9/5
(33)

Which of the following is not a chart element?

(Multiple Choice)
4.8/5
(33)

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

(Multiple Choice)
4.8/5
(26)

Which chart type cannot be displayed as a sparkline?

(Multiple Choice)
4.9/5
(36)

The ________ is the visual key to a chart.

(Short Answer)
4.9/5
(33)

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

(Multiple Choice)
4.9/5
(32)

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

(True/False)
4.8/5
(37)
Match the following terms with their description:
Radar
Similar to a line chart
Histogram
Used for two different but related data types
Combo chart
Spokes radiate from the center to the outer edges
Correct Answer:
Verified
Premises:
Responses:
Radar
Similar to a line chart
Histogram
Used for two different but related data types
Combo chart
Spokes radiate from the center to the outer edges
Area
Similar to a column chart
X Y (scatter)chart
Often used in educational, scientific, and medical experiments
(Matching)
4.8/5
(44)

Including what, distorts the effectiveness of charting data points?

(Multiple Choice)
4.8/5
(32)

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

(True/False)
4.7/5
(33)
Match the following terms with their description:
Column chart
Uses slices to display data points
Sparkline
Uses vertical bars
Pie chart
Chart resides in one cell
Correct Answer:
Verified
Premises:
Responses:
Column chart
Uses slices to display data points
Sparkline
Uses vertical bars
Pie chart
Chart resides in one cell
Bar chart
Line connect data points
Line chart
Uses horizontal bars
(Matching)
4.8/5
(37)

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

(Short Answer)
4.8/5
(43)
Match the following terms with their description:
Plot area
Uses color or patterns to identify each data series
Legend
Horizontal border
Y-axis
Vertical border
Correct Answer:
Verified
Premises:
Responses:
Plot area
Uses color or patterns to identify each data series
Legend
Horizontal border
Y-axis
Vertical border
Chart area
Holds the entire chart
X-axis
Both axes form a border for this
(Matching)
4.9/5
(36)

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

(True/False)
4.8/5
(33)

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

(Multiple Choice)
4.9/5
(40)

You cannot enter data or formulas on a chart sheet.

(True/False)
4.9/5
(39)
Showing 61 - 80 of 100
close modal

Filters

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