USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
On the Quick Analysis Tools, you can select Win-Loss under Sparklines?
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -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.
Detailed explanation-2: -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-3: -To insert line sparkling, select the range of data for which you want to create the sparkline and click the ‘Quick Analysis’ icon at the lower right corner of the selection. Then, go to the ‘Sparkline tab’ and choose the ‘Line’ chart type.
There is 1 question to complete.