USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Trend
|
|
Block
|
|
Group
|
|
Function
|
|
None
|
Detailed explanation-1: -Line sparkline is the default type of miniature chart you can return. So, it’s not necessary to use the “charttype” option in the SPARKLINE formula syntax – you can just specify the data range (up to two columns or rows) and hit enter. However, you have a few customization options to adjust your line graph.
Detailed explanation-2: -Sparklines are tiny charts inside single worksheet cells that can be used to visually represent and show a trend in your data. Sparklines can draw attention to important items such as seasonal changes or economic cycles and highlight the maximum and minimum values in a different color.
Detailed explanation-3: -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-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.