DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
column
|
|
line
|
|
pie
|
|
scatter
|
Detailed explanation-1: -Stacked column chart Shows the relationship of individual items to the whole, comparing the contribution of each value to a total across categories. A stacked column chart displays values in 2-D vertical stacked rectangles. A 3-D stacked column chart displays the data by using a 3-D perspective.
Detailed explanation-2: -Column chart: for comparing data across categories. Pie Chart: for showing the relative shares of categories in a total. Line Chart: for showing trends in a series over time. Scatter Plot: for showing the relationship between two series (given later).
Detailed explanation-3: -Line charts show changes in value across continuous measurements, such as those made over time. Movement of the line up or down helps bring out positive and negative changes, respectively.
Detailed explanation-4: -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.