Page 73 - TechPluse_C6_Flipbook
P. 73
Step 1 Select the data to be sorted.
Step 2 Click on the Data menu.
Step 3 Select the Sort Ascending or Sort Descending option to sort the data in ascending or
descending order respectively. In case of numbers, the ascending order is from 0 to 9
and in case of letters the ascending order is from A to Z. The data gets arranged in the
selected order.
Unsorted data Using Data menu Sorted data (ascending)
Multiple Sort
If you want to sort more than one column in such a way that the first column is in ascending
order and if some data is same for more than one rows then the second column of such rows
gets sorted in descending order. You can do this in Calc using Sort option of Data menu.
To use Sort, follow these steps:
Step 1 Select the range of columns to be sorted.
Step 2 Select the Sort option from Data menu. The Sort dialog box will open.
Step 3 Check the Range contains column labels check box under the Options tab.
Step 4 Click on the Sort Key 1 box to open list of column headers under the Sort Criteria tab.
Select a column head, for example ‘Marks Obtained’.
Step 5 Click on the Ascending radio button for Sort Key 1.
Step 6 Repeat steps 4 and 5 to sort ‘Marks in Previous Term’ column in descending order
under Sort Key 2.
Step 7 Click on the OK button. The data will be sorted according to the criteria defined.
Formulas, Functions and Charts in Calc 71

