USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which chart would you use if you wanted to show the distribution of items when there are more than 3 categories?Example:To show the % of students in 9th grade that drink whole milk, 2% milk, 1% milk, and skim milk.
|
|
Bar
|
|
|
Line
|
|
|
Column
|
|
|
Pie
|
Explanation:
Detailed explanation-1: -Stacked Bar Chart Use this chart to compare many different items and show the composition of each item you’re comparing.
Detailed explanation-2: -A line chart is, therefore, the best chart to show trends over time. It shows trends and data variables clearly. Besides, a line graph assists readers with making predictions for the future. However, for a data set comparison being useful, you must use the same scale on both axes.
Detailed explanation-3: -Pie charts show the size of items in one data series, proportional to the sum of the items. The data points in a pie chart are shown as a percentage of the whole pie. Consider using a pie chart when: You have only one data series.
There is 1 question to complete.