USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sparklines
|
|
|
Number Formatting
|
|
|
Styles
|
|
|
Conditional Formatting
|
Detailed explanation-1: -A Win-loss Sparkline only shows whether each value is positive or negative, whereas a Sparkline shows how high or low each value is.
Detailed explanation-2: -A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values.
Detailed explanation-3: -Sparklines in Excel are charts with a flair: they’re tiny charts that fit inside a single cell. Although Sparklines debuted with Excel 2010, many Excel users are still unfamiliar with this graphics feature.
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.