FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Sparklines are often used to emphasize a ____ in a data series.
A
Color
B
Trend
C
Text
D
Value
E
None
Explanation: 

Detailed explanation-1: -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. Position a sparkline near its data for greatest impact.

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: -There are three types of sparklines: Line: visualizes the data in a line graph form. Column: visualizes the data in column form, similar to the clustered column chart. Win/Loss: visualizes the data as positive or negative based on color.

Detailed explanation-4: -On the Charts tab, under Insert Sparklines, click the kind of sparkline that you want. In the Insert Sparklines dialog box, notice that the first box is already filled based on your selection in step 1. On the sheet, select the cell or the range of cells where you want to put the sparklines.

There is 1 question to complete.