Page 38 - Computer Genius Class 07
P. 38

Searching a Record

                  Follow the given steps to search a particular record:


                                  1  Click on the Insert tab.      2  Click on the Form command.







                                                                                               4  Type the  desired
                                                                                               field value which you
                                                                                               want  to search  and
                      3  Click on  the                                                         press the enter key.
                      Criteria button.




                  The searched record will appear if exist.

                  Deleting a Record

                  Perform the following steps to delete a record:


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


















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

                                                                                       Information Literacy
                         Quest                                                         Critical Thinking


                       Complete the step to add a new record in Excel.

                        Step 1   Click on the               command from the ribbon.
                        Step 2   Click on the               button. All the fields will be blank.

                        Step 3   Enter the details and click on the               button. Record will be added in
                                the worksheet.





                       36    Computer Genius-VII
   33   34   35   36   37   38   39   40   41   42   43