Page 63 - modular4.0
P. 63

Chapter Profile
                 Deleting a Record
                 Follow the given steps to delete a record:



                                                                        2  Click on the
                                                                        Delete button.

                                                                        1   Move on the record which
                                                                          you want to delete by
                                                                          clicking on the Find Next
                                                                          or Find Prev button.





                 The record will be deleted from the worksheet.

                        SORTING DATA


                 Excel can arrange the selected data in ascending or descending order. This is called sorting of data.
                 Follow the given steps to sort data:


                                                                     2  Click on the Sort & Filter command.













                      1  Select a column
                      or range of  data
                      to be sorted.







                                                           3  Select Sort A to Z (for text) or Sort Smallest to Largest
                                                          (for numbers) to sort the data in ascending order.



                 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.








                                                                                                   Excel as Database  61
   58   59   60   61   62   63   64   65   66   67   68