FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following chart types is useful for comparing individual values between a small set of data?
A
Bar chart
B
Column chart
C
Line chart
D
Pie chart
Explanation: 

Detailed explanation-1: -This chart is best used to compare different values when specific values are important, and it is expected that users will look up and compare individual values between each column.

Detailed explanation-2: -A pie chart helps organize and show data as a percentage of a whole. True to the name, this kind of visualization uses a circle to represent the whole, and slices of that circle, or “pie”, to represent the specific categories that compose the whole.

Detailed explanation-3: -Bar charts illustrate comparisons among individual items. In a bar chart, the categories are typically organized along the vertical axis, and the values along the horizontal axis.

Detailed explanation-4: -Column Charts are useful to visually compare values across a few categories or for showing data changes over a period of time. A Column Chart typically displays the categories along the horizontal (category) axis and the values along the vertical (value) axis.

Detailed explanation-5: -A Dual Axis Line Chart is one of the best graph to compare two sets of data. The chart has a secondary y-axis to help you display insights into two varying data points. More so, it uses two axes to easily illustrate the relationships between two variables with different magnitudes and scales of measurement.

There is 1 question to complete.