Understanding Chart Types

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Nsurani

Nsurani

Community Contributor

Quizzes Created: 14 | Total Attempts: 15,327

Questions: 10 | Attempts: 394 | Updated: Mar 22, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Questions and Answers

1.

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

Explanation
There are 11 types of charts in Excel.

Rate this question:
2.

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

Explanation
Pie charts are most effective with six or fewer slices because having too many slices can make the chart cluttered and difficult to read. With fewer slices, it is easier to compare the sizes of the slices and understand the proportions represented by each slice. This allows for a clear and concise representation of the data, making it more effective in conveying information to the audience.

Rate this question:
3.

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

Explanation
A column chart is a type of chart that uses vertical rectangles to compare values across categories. Each rectangle represents a category, and the height of the rectangle represents the value for that category. By comparing the heights of the rectangles, it is easy to visually understand the relative values across different categories.

Rate this question:
4.

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

Explanation
Charts in Excel can remain linked or connected to their data sources even if they appear in different worksheets. This allows for easy updating and maintaining the accuracy of the chart data.

Rate this question:
5.

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

Explanation
In pie charts with legends, it is best to make the slice colors as similar as possible. This is because using similar colors helps in distinguishing the different slices more easily. When the colors are too different, it can lead to confusion and make it harder for the viewer to interpret the chart accurately. Therefore, making the slice colors similar is recommended for better clarity and understanding of the data represented in the pie chart.

Rate this question:
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
Correct Answer
A. True

Explanation
A 3D chart can be rotated horizontally along the x-axis and vertically along the y-axis. This means that the chart can be tilted or turned in these two directions to view it from different angles. The statement is true because rotating a 3D chart in only these two directions is possible.

Rate this question:
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
Correct Answer
B. Combination Charts

Explanation
A chart that combines two or more chart types into a single graph is called a Combination Chart. This type of chart allows for the visualization of multiple data sets or variables in a single graph, making it easier to compare and analyze different data points. By combining different chart types, such as bar charts, line charts, or pie charts, a combination chart provides a comprehensive view of the data and can help identify patterns or relationships between variables.

Rate this question:
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
Correct Answer
D. Secondary axis

Explanation
A secondary axis in Excel allows you to plot two different sets of data with different scales on the same chart. This is particularly useful when you have two disparate values that cannot be easily compared on the same scale. By adding a secondary axis, you can effectively display and analyze the two sets of data side by side, making it easier to identify any patterns or relationships between them.

Rate this question:
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
Correct Answer
A. True

Explanation
This statement is true because the choice of chart type depends on the specific data and the message you want to convey. Different chart types have different strengths and weaknesses in representing different types of data. It is important to choose a chart type that effectively communicates the information and insights you want to share with your audience. Therefore, there is no definitive right or wrong chart type, but rather the one that best suits the purpose and effectively conveys the message about the data.

Rate this question:
10.

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

Explanation
The statement is asking if it is possible to modify an existing chart. The correct answer is "True" because it is indeed possible to make changes or modifications to a chart that has already been created. This can include adjusting the data, formatting, design, or other elements of the chart to better suit the needs or preferences of the user.

Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 22, 2023

Quiz Edited by
ProProfs Editorial Team
Apr 08, 2011

Quiz Created by
Nsurani

Understanding Chart Types

How many types of Charts are in Excel ?

Pie charts are most effective with ___________ or fewer slices.

What uses vertical rectangles to compare values across categories.

In excel, charts do not remain linked or connected to their data sources if they appear in different worksheets.

In pie charts with legends, it's best to make the slice colors as similar as possible.

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

A chart that combines two or more chart types into a single graph is called a(n) _____________ chart.

What Excel chart feature would be most helpful if you wanted to show two disparate (very different) values on the same chart?

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.

You can modify an exisiting chart?