1. Sorting data :- Sorting in Excel is arranging data according to our requirements. It can be done alphabetically or numerically.
The steps to sort data are as follows.
1. Select all rows and columns that have to be sorted.
2. Click on Data, and then, select Sort. This will displays a Sort dialog box .
3. Click on Sort Key 1 and select total from the drop-down. By default the order is Ascending, which means from the lowest to the highest. We will change it to Descending. This will sort the data in the total field.
4. Click on OK.
The data will get rearranged in the entire list and the name of the cell with the highest number will appear at the top,and then, with the next highest number, and so on.
2. Filtering data:- Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets hidden.) Using the store data, if you are interested in seeing data where Roll No is 201, then you can set filter to do this.
The steps to apply filter to a table are as follows:-
1. Click on the AutoFilter icon on the Tool Bar.
2. This will put filters at the top of each column.
3. Click on the filter for (for example ‘class’) column.
4. The drop-down will show a list of all the values in that column, for example,Class XII- A and XII-B.
5. By default, all values are checked or selected.
6. If you want to see the data of students only from Class XII-A, uncheck Class XII-B .
7. Click on OK. Data of students only from Class XII-A will be displayed.
0 Comments:
Post a Comment