Page 78 - IT-802_class_12
P. 78

6   Click on the OK button.




                                                                                       3




                                                                                       4

                                                                                       5








                                                                                       6

        The result after sorting appears as:















        3.7.3 Sort by Selection

        In Office Calc, we can also sort the data by selecting a range of data. This is not a recommended method while working
        in the original worksheet, as some of the relevant data is replaced by the newly sorted data. This causes the selected
        data to be left unsorted and the copy of the sorted data to be copied to the specified location. Therefore, it is suggested
        to apply this sorting to the duplicate copy of the worksheet.
        The various options for sorting in the options tab are:

        Ð ÐCase Sensitive: The letter in uppercase is placed after the letter in lowercase if the sort is ascending, and vice versa
           if the sort is descending, if the cells to be sorted contain the same letter in the same position but differ in case.
        Ð ÐDirection (sorting by rows or columns): It selects whether sorting is to be performed row-wise (vertically) or
           column-wise (horizontally).

          3.8 fIlTERING DATA

        Filtering is a quick and simple approach to identifying and working with selected data based on the criteria you specify.
        The filter feature allows you to selectively exclude the data you do not want to see and only display the rows or columns
        that meet the criteria you specify. Sorting rearranges the range of cells, but filtering only temporarily hides the rows or
        columns you do not want.
        Different ways in which filtering can be done in Calc are:

        Ð ÐAutoFilter
        Ð ÐStandard Filter



          76    Touchpad Information Technology-XII
   73   74   75   76   77   78   79   80   81   82   83