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

Step 5:  Sorted data will appear on the screen.  lick on  Stop  ecording  option.  OpenO ce  asic Macros
                    dialog appears on the screen.

            Step 6:  Click on ‘New Module’ button. ‘New Module’ dialog box appears on the screen.

            Step 7:  Type the name of the module.

            Step 8:  Click on ‘OK’ button.














                                                                                                6






                                                                                                             8
                                                  7






            Step 9:  Click on ‘Save’ button.


























            Step 10:  To use the created macro for sorting data in ascending order, let’s try in a new set of data.

            Step 11:  Select the cells. Click on ‘Tools’ menu and then select ‘Macro’ option.
            Step 12:  A sub-menu appears on the screen. Select ‘Run Macro’ option. ‘Macro Selector’ window appears on
                     the screen.

            Step 13:  ‘Selecting the Macro for sorting data.

            Step 14:  ‘Click on ‘Run’ button.



                                                                                 More About Spreadsheet        229
   226   227   228   229   230   231   232   233   234   235   236