Understanding Chart Types

10 Questions | By Nsurani | Last updated: Mar 22, 2022 | Total Attempts: 295

Questions

Settings

Create your own Quiz

Questions and Answers

1.

How many types of Charts are in Excel ?
- A.
  
  9
- B.
  
  11
- C.
  
  7
2.

Pie charts are most effective with ___________ or fewer slices.
- A.
  
  Six
- B.
  
  Seven
- C.
  
  Four
3.

What uses vertical rectangles to compare values across categories.
- A.
  
  Clustered columns chart
- B.
  
  Clustered column chart
- C.
  
  Cluster chart
- D.
  
  Column chart
4.

In excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.
- A.
  
  True
- B.
  
  False
5.

In pie charts with legends, it's best to make the slice colors as similar as possible.
- A.
  
  True
- B.
  
  False
6.

You can rotate a 3D chart in only two directions: horizontally along the x-axis and vertically along the y-axis.
- A.
  
  True
- B.
  
  False
7.

A chart that combines two or more chart types into a single graph is called a(n) _____________ chart.
- A.
  
  Compound Charts
- B.
  
  Combination Charts
- C.
  
  Normal Charts
8.

What Excel chart feature would be most helpful if you wanted to show two disparate (very different) values on the same chart?
- A.
  
  Bubble Chart
- B.
  
  Error bars
- C.
  
  Projection
- D.
  
  Secondary axis
9.

There are no right or wrong chart types, just ones that illustra the message you are trying to convey about your data better than others.
- A.
  
  True
- B.
  
  False
10.

You can modify an exisiting chart?
- A.
  
  True
- B.
  
  False

Related Topics

More Graph Quizzes

Quiz: The Pedigree Chart Reading

For a formal definition of the topic, it's a chart that is used to track the presence or absence of phenotype through one or more generations of a family. This quiz is a short assessment test for you consisting of six...

Questions: 6 | Attempts: 16168 | Last updated: Mar 21, 2022

Sample Question
How many affected individuals are on this pedigree chart and how can you tell?

6, those who are shaded black

3, those who are shaded black with a slash

11, those who have a slash

12, those who are not shaded