Page 47 - Dig_CodeAI_V2.1_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