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

3. How Many ways Macro can be Executed? Give steps.

           Ans.  We can use following three methods to run a macro:
                I.    Tools   Macro   Run
                II.   Use a Push Button
                   Steps are as follows:
                   Step 1: Select the View   Toolbars   Form Controls option.
                   Step 2: Drag a Button control in any blank cell.
                   Step 3  Right-click on the button and select the Control option. The Properties: Push Button dialog box
                         appears.
                   Step 4: Click on the Events tab.
                   Step 5:  Click on the ellipse (…) button in front of the Mouse button pressed event. The Assign action dialog
                         box appears.
                   Step 6: Click on the Macro button. The Macro Selector dialog box appears.
                   Step 7: Select the macro from Module   Library node.
                   Step 8: Click on OK button. The Assign action dialog box re-appears.
                   Step 9: Click on OK button.
                   Step 10: Using the General tab, give a name to the button and keep design mode ON form controls.
                   Step 11: Now  click on the button and find total points on sheet  and use same process for sheet .
                III.  Third method to run a macro is by adding a macro to a Standard  toolbar.
                   Steps are as follows:
                   Step 1: Select the View   Toolbar   Customize option.
                   Step 2: Select the Standard toolbar from a Toolbar drop-down list.
                   Step 3: Click on the Add button. The Add Commands dialog box appears.
                   Step 4: Select the OpenO ce Macro   Library   Module option.
                   Step 5: Select your macro name.
                   Step 6: Click on the Add button.
                   The selected macro is added in the Standard toolbar.

        Unsolved Exercise



                                                        Section A
                                                (Objective Type Questions)
        A.  Multiple choice questions:
            1.  Which menu is used to start track changes?
              i.  Edit                                          ii.  Insert
              iii. View                                         iv. Review
            2.  On which side of the cell, a small triangle appears to indicate changes in a cell?
              i.  Top left                                      ii.  Top right
              iii  Bottom left                                  iv. Bottom right
            3.  Which button is pressed to accept every change that has been made in the worksheet?
              i.  Accept                                        ii.  Accept All
              iii. Accept Changes                               iv. Accepted
            4.  The macros can be accessed from which of the following menus?
              i.  View                                          ii.  Review
              iii. Tools                                        iv. Data


         234       Touchpad Information Technology-X
   231   232   233   234   235   236   237   238   239   240   241