Exam 3: Charts

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

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

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

You cannot enter data or formulas on a chart sheet.

(True/False)
4.8/5
(39)

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

(Short Answer)
4.8/5
(34)

The Chart Styles gallery displays style options for the selected chart only.

(True/False)
4.9/5
(34)

To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.

(True/False)
4.8/5
(36)

What does Excel not determine about the value axis when you create a chart?

(Multiple Choice)
4.8/5
(33)

What chart type represents data as spokes going from the center to the outer edge of the chart?

(Multiple Choice)
4.8/5
(33)

A(n)________ is a type of chart which fits in one cell.

(Short Answer)
4.9/5
(37)

A 100% stacked column chart is similar to what other chart in that it converts values to percentages?

(Multiple Choice)
4.9/5
(37)

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

(Multiple Choice)
4.9/5
(42)

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

(Short Answer)
4.9/5
(35)

It is important to select parallel ranges.

(True/False)
4.9/5
(38)

As long as you pick the correct chart you can mix numeric value systems,such as dollars and number of units sold.

(True/False)
4.8/5
(43)

As a general rule,Pie charts should be limited to how many slices?

(Multiple Choice)
4.8/5
(35)

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

(True/False)
4.9/5
(36)

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

(True/False)
4.9/5
(28)

In a pie chart which of the following is a good reason for using category data labels rather than the legend?

(Multiple Choice)
4.7/5
(38)

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

(Short Answer)
4.9/5
(38)

If you wanted to show trends over set periods of time,you probably want to use a(n)________ chart.

(Short Answer)
4.8/5
(38)
Showing 21 - 40 of 100
close modal

Filters

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