MULTIPLE SORT AND MULTIPLE FILTERING
Multiple Sort
Sorting of data means putting the values of data into ascending or descending order . We can sort the complete data by selected multiple fields .
For example you have english marks of your class of 40 students and you want to know the number of students who have secured highest marks and you want to see how many girls are topping on the chart.
Example 1:
If you want to know what is highest number scored by boys and girls.
For this we need to sort the data by Gender and then by percentage( use data given in handout 1), follow the given steps:
1. Select all columns/data given in handout 1.
2. Go to Data menu and select Sort option from drop down Menu , a dialog box will appear.
3. As we want to do multiple sorting we have to mention the column or field name in sort key 1 here we are using field Gender as Sort key 1 , % as Sort Key 2 and Name as Sort Key 3.
4. Following result will be displayed.
MULTIPLE FILTERING
To apply multiple filters:
Filters are cumulative, which means you can apply multiple filters to help narrow down your results. For example, We want to see marks and names of only those girl students who scored % above 80 . For this we will use multiple filter .
Follow the following steps (using dataset given in Handout 1)
1. Go to Data Menu and choose Auto filter or click on Auto filter Tab
2. Following screen will be appeared and filter will be available on each field.
3. Now goto Data menu and give criteria of filtration in Standard filter. Here in this example we are giving condition and percentage more than value 80 and gender should be female.
4. After clicking OK , Following screen will come which will depict filtered data .
MULTIPLE SORT AND MULTIPLE FILTERING
Multiple Sort
Sorting of data means putting the values of data into ascending or descending order . We can sort the complete data by selected multiple fields .
For example you have english marks of your class of 40 students and you want to know the number of students who have secured highest marks and you want to see how many girls are topping on the chart.
Example 1:
If you want to know what is highest number scored by boys and girls.
For this we need to sort the data by Gender and then by percentage( use data given in handout 1), follow the given steps:
1. Select all columns/data given in handout 1.
2. Go to Data menu and select Sort option from drop down Menu , a dialog box will appear.
3. As we want to do multiple sorting we have to mention the column or field name in sort key 1 here we are using field Gender as Sort key 1 , % as Sort Key 2 and Name as Sort Key 3.
4. Following result will be displayed.
MULTIPLE FILTERING
To apply multiple filters:
Filters are cumulative, which means you can apply multiple filters to help narrow down your results. For example, We want to see marks and names of only those girl students who scored % above 80 . For this we will use multiple filter .
Follow the following steps (using dataset given in Handout 1)
1. Go to Data Menu and choose Auto filter or click on Auto filter Tab
2. Following screen will be appeared and filter will be available on each field.
3. Now goto Data menu and give criteria of filtration in Standard filter. Here in this example we are giving condition and percentage more than value 80 and gender should be female.
4. After clicking OK , Following screen will come which will depict filtered data .
MULTIPLE SORT AND MULTIPLE FILTERING
Multiple Sort
Sorting of data means putting the values of data into ascending or descending order . We can sort the complete data by selected multiple fields .
For example you have english marks of your class of 40 students and you want to know the number of students who have secured highest marks and you want to see how many girls are topping on the chart.
Example 1:
If you want to know what is highest number scored by boys and girls.
For this we need to sort the data by Gender and then by percentage( use data given in handout 1), follow the given steps:
1. Select all columns/data given in handout 1.
2. Go to Data menu and select Sort option from drop down Menu , a dialog box will appear.
3. As we want to do multiple sorting we have to mention the column or field name in sort key 1 here we are using field Gender as Sort key 1 , % as Sort Key 2 and Name as Sort Key 3.
4. Following result will be displayed.
MULTIPLE FILTERING
To apply multiple filters:
Filters are cumulative, which means you can apply multiple filters to help narrow down your results. For example, We want to see marks and names of only those girl students who scored % above 80 . For this we will use multiple filter .
Follow the following steps (using dataset given in Handout 1)
1. Go to Data Menu and choose Auto filter or click on Auto filter Tab
2. Following screen will be appeared and filter will be available on each field.
3. Now goto Data menu and give criteria of filtration in Standard filter. Here in this example we are giving condition and percentage more than value 80 and gender should be female.
4. After clicking OK , Following screen will come which will depict filtered data .
Multiple Sort
Sorting of data means putting the values of data into ascending or descending order . We can sort the complete data by selected multiple fields .
For example you have english marks of your class of 40 students and you want to know the number of students who have secured highest marks and you want to see how many girls are topping on the chart.
Example 1:
If you want to know what is highest number scored by boys and girls.
For this we need to sort the data by Gender and then by percentage( use data given in handout 1), follow the given steps:
1. Select all columns/data given in handout 1.
2. Go to Data menu and select Sort option from drop down Menu , a dialog box will appear.
3. As we want to do multiple sorting we have to mention the column or field name in sort key 1 here we are using field Gender as Sort key 1 , % as Sort Key 2 and Name as Sort Key 3.
4. Following result will be displayed.
MULTIPLE FILTERING
To apply multiple filters:
Filters are cumulative, which means you can apply multiple filters to help narrow down your results. For example, We want to see marks and names of only those girl students who scored % above 80 . For this we will use multiple filter .
Follow the following steps (using dataset given in Handout 1)
1. Go to Data Menu and choose Auto filter or click on Auto filter Tab
2. Following screen will be appeared and filter will be available on each field.
3. Now goto Data menu and give criteria of filtration in Standard filter. Here in this example we are giving condition and percentage more than value 80 and gender should be female.
4. After clicking OK , Following screen will come which will depict filtered data .
MULTIPLE SORT AND MULTIPLE FILTERING
Multiple Sort
Sorting of data means putting the values of data into ascending or descending order . We can sort the complete data by selected multiple fields .
For example you have english marks of your class of 40 students and you want to know the number of students who have secured highest marks and you want to see how many girls are topping on the chart.
Example 1:
If you want to know what is highest number scored by boys and girls.
For this we need to sort the data by Gender and then by percentage( use data given in handout 1), follow the given steps:
1. Select all columns/data given in handout 1.
2. Go to Data menu and select Sort option from drop down Menu , a dialog box will appear.
3. As we want to do multiple sorting we have to mention the column or field name in sort key 1 here we are using field Gender as Sort key 1 , % as Sort Key 2 and Name as Sort Key 3.
4. Following result will be displayed.
MULTIPLE FILTERING
To apply multiple filters:
Filters are cumulative, which means you can apply multiple filters to help narrow down your results. For example, We want to see marks and names of only those girl students who scored % above 80 . For this we will use multiple filter .
Follow the following steps (using dataset given in Handout 1)
1. Go to Data Menu and choose Auto filter or click on Auto filter Tab
2. Following screen will be appeared and filter will be available on each field.
3. Now goto Data menu and give criteria of filtration in Standard filter. Here in this example we are giving condition and percentage more than value 80 and gender should be female.
4. After clicking OK , Following screen will come which will depict filtered data .
MULTIPLE SORT AND MULTIPLE FILTERING
Multiple Sort
Sorting of data means putting the values of data into ascending or descending order . We can sort the complete data by selected multiple fields .
For example you have english marks of your class of 40 students and you want to know the number of students who have secured highest marks and you want to see how many girls are topping on the chart.
Example 1:
If you want to know what is highest number scored by boys and girls.
For this we need to sort the data by Gender and then by percentage( use data given in handout 1), follow the given steps:
1. Select all columns/data given in handout 1.
2. Go to Data menu and select Sort option from drop down Menu , a dialog box will appear.
3. As we want to do multiple sorting we have to mention the column or field name in sort key 1 here we are using field Gender as Sort key 1 , % as Sort Key 2 and Name as Sort Key 3.
4. Following result will be displayed.
MULTIPLE FILTERING
To apply multiple filters:
Filters are cumulative, which means you can apply multiple filters to help narrow down your results. For example, We want to see marks and names of only those girl students who scored % above 80 . For this we will use multiple filter .
Follow the following steps (using dataset given in Handout 1)
1. Go to Data Menu and choose Auto filter or click on Auto filter Tab
2. Following screen will be appeared and filter will be available on each field.
3. Now goto Data menu and give criteria of filtration in Standard filter. Here in this example we are giving condition and percentage more than value 80 and gender should be female.
4. After clicking OK , Following screen will come which will depict filtered data .
No comments:
Post a Comment