FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

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 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.
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 combination chart can be made up of area, bar, column, dot, and line charts. Each data series can be represented by a different type of chart. They are all then displayed simultaneously on the same chart.

Detailed explanation-3: -Use bar charts to show comparisons among individual items. Bar charts have the following chart subtypes: Clustered bar and 3-D Clustered bar chart Compares values across categories. In a clustered bar chart, the categories are typically organized along the vertical axis, and the values along the horizontal axis.

Detailed explanation-4: -A pie chart shows the data points of a single data series. It is a circular chart consisting of slices. One slice represents one data point. The entire pie represents the total of the individual data points.

There is 1 question to complete.
Previous
Next