Page 218 - IT 402 v2.0 class 10
P. 218

MACRO

        Macros are the set of stored functions that can be used to automate processes that are repeated often. They
        are tools which can be used to perform most of the redundant tasks with relative ease. A Macro is a saved
        sequence of commands or keystrokes that are stored for later use. An example of a simple macro is one that
         types  our address.  he OpenO ce macro language is very flexible  allowing automation of both simple and
        complex tasks. Macros are especially useful in execution of such type of tasks which are repeated again and
        again fre uently or within a specified time interval in the same manner.

        What are the Advantages of Macro?
        Some of the advantages of macro are as follows:

          It saves user’s time.
          It allows to repeat a number of commands in just one click or using the shortcut key.
          It allows a user to record numerous formatting commands or formulas in a single worksheet.

          It allows a user to use their names for each macro.
          It reduces the errors occurring with repetitive tasks.
          It is capable to perform any kind of complex calculations easily.

        Using the Macro Recorder

        The following steps to create a macro that performs paste special with 'Paste Special' with 'Multiply':

        Step 1:  Open a new spreadsheet.
        Step 2:  Enter numbers into a spreadsheet.




























        Step 3:  Select cell A3 which contains the number 3 and Press ‘Ctrl + C’ key combination to copy the value to
                the Clipboard.

        Step 4:  Select the range A1:C3.

        Step 5:  Click on ‘Tools’ menu and then select ‘Macros’ option. A sub-menu appears on the screen. Click
                ‘Record Macro’ option to start the macro recorder.





         216       Touchpad Information Technology-X
   213   214   215   216   217   218   219   220   221   222   223