Page 47 - Digicode_AI_class_7
P. 47

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
                   byte 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.





                                                                        Advanced Features of Excel 2016   45
   42   43   44   45   46   47   48   49   50   51   52