Page 74 - IT-802_class_12
P. 74

Lab Assignment ‘n Activity                               Subject Enrichment



             Create the following worksheet and perform the given operations:















              Ê ÐInsert a column after column C.
              Ê ÐMove the marks of Maths in the newly inserted column.

              Ê ÐInsert a new row before last record.
              Ê ÐInsert the following details in the new row

                 1006      Diya      70      85      69      65

              Ê ÐChange the row height of all the rows.
              Ê ÐChange the column width of columns A to F.




          3.7 SORTING DATA


        Sorting is the process of arranging and displaying the data in the worksheet as per the requirements of information, i.e.,
        in an organised and meaningful order so that a user can view the required data to evaluate further. There are three types
        of sorting in OpenOffice Calc. They are:
        Ð ÐSimple sorting
        Ð ÐMulti-sorting

        Ð ÐSort by selection
        3.7.1 Simple Sorting

        Sorting the data on the basis of a single column is known as simple sorting. Simple sorting can be categorised into two
        types.

        Ð ÐSort Ascending: Such sorting enables us to display the data in order from small to large or in alphabetical order
           (A to Z/Small to Large).

        Ð ÐSort Descending: Such sorting enables us to display the data in order from larger value to smaller in reversed
           alphabetical order (Z to A/Large to Small).

        Sorting data can be easily done in Calc with the help of the Sort command from the Standard toolbar or from the Data menu.
        To sort data in ascending or descending order, perform the following steps:
         1   Select the desired cells to sort.
         2   Click on the Sort Ascending icon or Sort Descending icon from the Standard Toolbar.





          72    Touchpad Information Technology-XII
   69   70   71   72   73   74   75   76   77   78   79