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
   223   224   225   226   227   228   229   230   231   232   233