Page 229 - Trackpad 402_Class-X_Final
P. 229

•  Data found in the edited version but not in the original is marked as inserted.
            •  Data found in the original file but not in the edited version is marked as deleted.
            •  Data which is changed is marked as changed.
            Step 5:  This is followed by accepting or rejecting the changes.

            Step 6:  Click on OK button to save the changes.



                    WHAT ARE MACROS?
            Sometimes you need to repeat a few commands very frequently to get the work done. For example, A teacher takes
            attendance in the class everyday morning by calling out the names. After that she marks the attendance in the computer
            followed by opening a new mail and forwarding the names of the absentees on a daily basis to higher authorities.
            Followed by sending a mail to the parents asking them the reason for the absentees. These repeated steps of working
            in a computer for writing mail and sending to two different categories of people on a daily basis can be made a little
            faster and less tedious by automating the steps using macros.
            This process of saving the sequence of commands or keystrokes by a specific name for the later use is called macros.
            The main advantages of using macros are:
            •  It helps you save time as the long and time consuming tasks are saved as macros and can be executed with a click
              of a button.
            •  It saves you from the tedious repetitive tasks.
            •  The chances of errors in the complex task are reduced.
            •  You can run a macro as many times as you want until you delete it from the computer.

            Steps for Creating a Macro
            Let us create a simple macro of storing the names of five cities and formatting it in a different colour, font and size. To
            do this, follow the steps given below:
            Step 1:  Create a new worksheet.
            Step 2:   Click on Tools menu and select Macros option and then click on Record Macros. The recording will start
                    immediately.



























            Step 3:  As soon as the record macro becomes active a dialog box of stop recording will be activated as shown below:







                                                                                 Electronic Spreadsheet (Advanced)  229
   224   225   226   227   228   229   230   231   232   233   234