USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Showing the amount of change in data over time
|
|
|
Showing the relationship of parts to a whole
|
|
|
When searching the realation between two or more varibles
|
|
|
Comparing invidual items
|
Detailed explanation-1: -It allows you to compare different sets of data among different groups easily. It instantly demonstrates this relationship using two axes, where the categories are on one axis and the various values are on the other. A bar graph can also illustrate important changes in data throughout a period of time.
Detailed explanation-2: -Bar charts are one of the many techniques used to present data in a visual form so that the reader may readily recognize patterns or trends. Bar charts usually present categorical variables, discrete variables or continuous variables grouped in class intervals.
Detailed explanation-3: -A bar chart is especially useful with comparing two sets of data. The difference in the bars give us a quick snapshot that allows us to draw some conclusions.
Detailed explanation-4: -A bar chart illustrates comparisons between individual items. Categories are organized vertically and values horizontally to focus on comparing values and to place less emphasis on time.
Detailed explanation-5: -Column charts are useful for comparing discrete data or showing trends over time. Column charts use vertical data markers to compare individual values.