Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 63 - Data_Science_Part_A C12
P. 63

    Step 3:  Select Sort criteria tab and select Total from the drop-down list.
                Step 4:  Then, tick on the checkbox selecting descending order.
                Step 5:  Click on the OK button. This will arrange the data in descending order of Total as shown:

                So, Yashwant has scored the highest marks and Nitin has scored the least out of all students.

                3.11.2 Filtering Data
                Suppose you want to check data of those students who belong to the section B, then we can apply a filter—another
                feature in Calc. This can be done by performing the following steps:

                Step 1:  Select the data.
                Step 2:  Click on Data   Autofilter. A drop-down icon will appear next to each column header.
                         OR
                         Click on the AutoFilter option on the standard toolbar.

                                                                                                     ICT Skills-III  61

| 58 59 60 61 62 63 64 65 66 67 68 |