Page 54 - ModularV1.1 _c7_flipbook
P. 54

Step 3   Type the desired field value that

                          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 it exists.
                  Deleting a Record
                                                                   Typing value to search          Searched result
                  Perform  the  following steps to  delete  a
                  record:

                  Step 1   Move to the record that 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.
                                                                                                  Deleting a record
                      SORTING DATA

                  Excel can arrange the selected data in ascending or descending order. This is
                  called sorting of data. To sort data, follow these steps:

                  Step 1  Select the data to be sorted.
                  Step 2   Click  the  Sort  &  Filter command from the  Editing group  under the

                          Home tab to open a drop-down list.

                                                                                                         Unsorted data






                                                Using Sort & Filter command
                  Step 3   Click 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.
                  Custom Sort                                                                             Sorted data

                  If  more than one column is to be sorted in such a way that the first column is in ascending order
                  and if some data is the same for more than one row, then the selected column of such rows gets
                  sorted in descending order. You can do this in Excel using Custom Sort.

                  To use Custom Sort, follow these steps:
                  Step 1  Select the range of columns to be sorted.
                  Step 2   Click the Sort & Filter command from the Editing
                          group under the Home tab to open a drop-down list.

                  Step 3   Click Custom Sort from the drop-down list to open the
                          Sort dialog box.                                                       Unsorted data


                  52      Modular (Ver. 1.1)-VII
   49   50   51   52   53   54   55   56   57   58   59