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

