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
   282   283   284   285   286   287   288   289   290   291   292