FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The ____ chart type emphasizes the difference between positive and negative values in the data series.
A
Positive/Negative
B
Good/Bad
C
Win/Loss
D
Up/Down
E
None
Explanation: 

Detailed explanation-1: -Use a waterfall chart to show how an initial value changes with intermediate values-either positive or negative-and results in a final value.

Detailed explanation-2: -To chart a single data series, such as sales in one region, use a pie chart. Positive/negative column chart. Compare positive and negative values. Positive values appear above a mid-point (zero, by default) and negative values appear below the mid-point. You can set a custom mid-point.

Detailed explanation-3: -Line charts are useful for showing trends over time and comparing many data series.

Detailed explanation-4: -A scatter chart has two value axes. It shows one set of numeric data along the horizontal axis (x-axis) and another along the vertical axis (y-axis). It combines these values into single data points and displays them in irregular intervals, or clusters.

There is 1 question to complete.
Previous
Next