Skip to content

In MS Excel, if you need to compare values over categories what type of chart would you use?

Answer: D) Column chart

  1. A) Line chart
  2. B) Dot chart
  3. C) Pie chart
  4. D) Column chart

Explanation

A column chart. It shows each category as a separate vertical bar, so values can be compared side by side at a glance. A line chart is better for change over time, and a pie chart shows parts of one whole, not comparisons across many categories.

Asked in: MPEMR

Topic: Computer and IT