Page 82 - Web_Application_v2.0_C12_Fb
P. 82

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.

              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.


























              Step 3:    By default, all values  are selected.
                       Click on the Section drop-down and
                       select the appropriate category from
                       the drop-down list.
              The values will be filtered out for section B only.

                80    Touchpad Web Applications (Ver. 2.0)-XII
   77   78   79   80   81   82   83   84   85   86   87