USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
format
|
|
|
data
|
|
|
sort
|
|
|
show
|
Detailed explanation-1: -Mark data points on sparklines You can distinguish specific data points, such as high or low values, by using markers. Click a sparkline. On the Sparkline Design tab, in the Show group, select the markers that you want, such as high and low points. You can customize marker colors by clicking the Marker Color button.
Detailed explanation-2: -Types of sparklines Win/Loss is similar to Column, except it only shows whether each value is positive or negative instead of how high or low the values are.
Detailed explanation-3: -You can highlight individual data markers (values) in a line Sparkline by making some or all of the markers visible. To show all values, select the Markers check box. To show negative values, select the Negative Points check box. To show the highest or the lowest values, select the High Point or Low Point check boxes.
Detailed explanation-4: -The Sparkline control supports three different sparkline types, namely Line, Column and Winloss, for visualizing data in different context. For example, Line charts are suitable to visualize continuous data, while Column sparklines are used in scenarios where data comparison is involved.