Page 287 - Trackpad IT-402_Class-IX
P. 287
SORTING
Sorting refers to the re-arranging of data on the basis of some defined criteria. For example, to find the highest / lowest
marks of a subject, the data of subject marks can be re-arranged either in ascending or descending order. Sorting can
also be done with numeric and non- numeric data i.e., numbers or alphabets. To sort data, follow the given steps:
Step 1: Select the data or portion of the worksheet which is to be sorted.
Step 2: Click on the Sort option from the Data menu. The Sort dialog box appears on the screen.
Step 3: In Sort by field, select the name of the column whose data is to be sorted.
Step 4: To sort the records in Ascending or Descending order, click on their respective checkboxes in the Sort Criteria tab.
Step 5: If the sorting has to be done on the subsequent columns also then in the Then by option, click on Ascending
or Descending.
Step 6: Click on the Options tab in the Sort dialog box.
Step 7: Select the sort options as required.
Step 8: Click on the OK button.
Electronic Spreadsheet 287

