Which chart would you use if you had two categories and you wanted to show distribution (how they add up to 100%) of those two categories?Example:% of people who bought whole milk and % of people who bought skim milk in December.

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

A	Bar
B	Line
C	Column
D	Pie

Explanation:

Detailed explanation-1: -Following are the best chart types for comparing data in Excel: Column chart. Bar chart.

Detailed explanation-2: -A scatter chart has two value axes. It shows one set of numeric data along the horizontal axis (x-axis) and another along the vertical axis (y-axis). It combines these values into single data points and displays them in irregular intervals, or clusters.

Detailed explanation-3: -Bar graphs can help you compare data between different groups or to track changes over time. Bar graphs are most useful when there are big changes or to show how one group compares against other groups.

Detailed explanation-4: -Column charts are useful for comparing discrete data or showing trends over time. Column charts use vertical data markers to compare individual values.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL