USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A Line sparkline displays a green block for increasing values and a red block for declining values. You can add data markers to sparklines to indicate the high and low points in the chart. What can you do to make data series easier to distinguish from one another?
Detailed explanation-2: -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-3: -To customize how High and Low Points, First and Last Points, Markers and Negative Points are displayed, click on the Marker Color button [G] in the Style Click on the marker you want to change [H], then choose a color from the fly-out menu.
Detailed explanation-4: -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-5: -Conditional formatting allows you to automatically apply formatting-such as colors, icons, and data bars-to one or more cells based on the cell value. To do this, you’ll need to create a conditional formatting rule.