Exam 7: Excel : Charts

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

What should you not select when selecting data for a chart?

Free
(Multiple Choice)
4.8/5
(28)
Correct Answer:
Verified

D

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

Free
(True/False)
4.9/5
(31)
Correct Answer:
Verified

False

The ________ is the visual key to a chart.

Free
(Short Answer)
4.7/5
(34)
Correct Answer:
Verified

legend

________ charts are often used to represent data in educational, scientific, and medical experiments.

(Short Answer)
4.7/5
(26)

In a column chart the horizontal axis displays the ________.

(Short Answer)
4.9/5
(35)

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

(Multiple Choice)
4.9/5
(33)

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

(Short Answer)
4.9/5
(45)

The ________ axis helps measure data from top to bottom in a chart.

(Short Answer)
4.8/5
(38)

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

(Multiple Choice)
5.0/5
(43)

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

(True/False)
4.7/5
(33)

In rare cases you can chart text entries.

(True/False)
4.8/5
(42)

Effective charts never overwhelm an audience.

(True/False)
4.7/5
(39)

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
(25)

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

(Short Answer)
4.9/5
(33)

What is not a purpose of using an effective chart?

(Multiple Choice)
4.8/5
(33)

Pie charts can only display one data series.

(True/False)
4.8/5
(30)

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

(Multiple Choice)
4.8/5
(33)

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

(Multiple Choice)
4.9/5
(29)

What is not true about an effective chart?

(Multiple Choice)
4.9/5
(35)

Where does Excel display the Quick Analysis tool?

(Multiple Choice)
4.8/5
(34)
Showing 1 - 20 of 100
close modal

Filters

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