Page 77 - IT-802_class_12
P. 77
5
6
6 Click on the OK button. Finally, the result of the sorted list of the three columns will be displayed as:
In OpenOffice Calc, only three fields can be sorted multiple times.
For example, consider the following illustration with the data as given below:
Suppose we have to sort data in ascending order with respect to price per item, and if two items have the same price,
then in descending order of the number of items, and if two items have the same price and the same number, then
according to their code that is sorted alphabetically in increasing order.
To perform multiple sorting on this data as per the given requirement, perform the following steps:
1 Select the cells to sort, including the headers, since the data you have selected contains headers (Price per Item
and Number of Items).
2 Click on the Sort option from the Data menu.
3 In the Sort by section, select the ‘Price per Item’ column and click on the Ascending radio button.
4 In the Then by section, select the ‘Number of Items’ column and click on the Descending radio button.
5 Select the ‘Item Code’ and click on the Ascending radio button.
ICT Skills-IV 75

