USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
bar
|
|
|
pie
|
|
|
column
|
|
|
line
|
Detailed explanation-1: -Column charts are mostly used to compare discrete values in excel. As shown in the above figure, each data point of the Column chart is plotted as a vertical rectangular bar where the height of the column represents the value of a data point.
Detailed explanation-2: -Use a histogram when you want to show the distribution of a data set across different buckets or ranges. The height of each bar represents the count of values in each range. For example, show how long customers were on hold with your call center.
Detailed explanation-3: -Column charts are useful for showing data changes over a period of time or for illustrating comparisons among items. In column charts, categories are typically organized along the horizontal axis and values along the vertical axis.
Detailed explanation-4: -A Bar Graph (also called Bar Chart) is a graphical display of data using bars of different heights.
Detailed explanation-5: -Line graphs are useful for illustrating trends such as temperature changes during certain dates.