Page 60 - TP_Modular_V2.1_Class7
P. 60

Step 3    Type the desired field value which

                          you want to search. In this case, we
                          have  typed  the  Employee  Code
                          value A1114.
                  Step 4    Press  the  Enter key.  The  searched
                          record will appear if exist.

                  Deleting a Record                                 Typing value to search         Searched result

                  Perform  the  following  steps to  delete  a
                  record:
                  Step 1    Move on the record which you want to delete by clicking on
                          the Find Next or Find Prev button.

                  Step 2    Click on the Delete button. The record will be deleted from the
                          worksheet.
                      SORTING DATA

                                                                                                  Deleting a record
                  Excel can arrange the selected data in ascending or descending order.
                  This is called sorting of data. To sort data, follow the given steps:
                  Step 1  Select the data to be sorted.

                  Step 2   Click on the  Sort &  Filter command from
                          Editing group under the Home tab to open a
                          drop-down list.
                  Step 3   Click on the Sort A to Z (for text) and Sort
                          smallest to largest (for numbers) to sort the
                          data in ascending order.
                           The selected data gets arranged in ascending
                          order.
                                                                                Unsorted data           Sorted data
                  Custom Sort

                  In case, more than one column are to be sorted in such a way that the first column is 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 Excel using Custom Sort.
                  To use Custom Sort, follow the given steps:

                  Step 1  Select the range of columns to be sorted.
                  Step 2   Click Sort & Filter command from Editing group
                          under Home tab to open a drop-down list.

                  Step 3   Click Custom Sort from the drop-down list to open
                          Sort dialog box.
                  Step 4   Check My data has headers checkbox if the selected                    Unsorted data
                          columns have a heading at the top.



                   58       Modular (Ver. 2.1)-VII
   55   56   57   58   59   60   61   62   63   64   65