USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Bar chart
|
|
|
Column chart
|
|
|
Bar or Column Chart
|
|
|
None of the above
|
Detailed explanation-1: -Bar and column charts are used to compare different items. Bars on a column chart are vertical while bars on a bar chart are horizontal. Bar charts are generally used to help avoid clutter when one data label is long or if you have more than 10 items to compare. They are easy to understand and to create.
Detailed explanation-2: -With column charts, you could compare values for different categories or compare value changes over a period of time for a single category.
Detailed explanation-3: -a Bar Graph. Bar graphs are used to compare things between different groups or to track changes over time.
Detailed explanation-4: -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-5: -Ultimately, the bar and the column chart can be used either way; however, the column chart is better used in the case of making comparisons while the bar charts are better used in cases where the data to be represented are a lot, and the labels are lengthy.