USING MICROSOFT EXCEL
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.