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

