Page 228 - TP_IT_V1.0_C10_flipbpookl
P. 228
Step 7: Click on Keep Result button to keep the change in the sheet.
This will change the values of the cells to get the desired 94%. The spreadsheet after the changes will appear as follows:
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.
The Macro keeps track of what you type and click with your keyboard and mouse. But it doesn’t record certain things
like:
• Opening new windows
• Doing stuff in a different window from where you started recording
226 Trackpad Information Technology (Ver. 1.0)-X

