A. write t for true and false false statement.
1. sparkline are created in the sheet from which the data is selected.
2. rows can be sorted with respect to the colour of the cells in Excel.
3. more than filter can be applied on a given set of data in Excel.
4. data cannot be filtered in Excel.
5.all the field names appear in the single row above the data.
6. sorting data means rearranging data in a particular manner.
7. rows can be sorted based on a single column only in Excel.
8. certain rules can be set in excel to restrict the type of data or values to be entered in a cell.
9. custom sort option is used to arrange data based on column A.
B. tick the correct option and fill in the blanks.
1. the data filter icon in excel has the shape of a_____
a. strainer
b. funnel
c. can
2. the filter option in excel is found under the ____
group
a. editing
b. cells
c. styles
Answers
Answer:
Select a blank cell at the end of a row of data.
Select Insert and pick Sparkline type, like Line, or Column.
Select cells in the row and OK in menu.
More rows of data? Drag handle to add a Sparkline for each row.
Format a Sparkline chart
Select the Sparkline chart.
Select Design and then select an option.
Sparklines Tools
Select Line, Column, or Win/Loss to change the chart type.
Check Markers to highlight individual values in the Sparkline chart.
Select a Style for the Sparkline.
Select Sparkline Color and the color.
Select Sparkline Color > Weight to select the width of the Sparkline.
Select Marker Color to change the color of the markers.
If the data has positive and negative values, select Axis to show the axis.
Answer:
Sparklines are created in the sheet from which the data is selected