Microsoft Excel 2010 Expert — Question 28

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a user form through Microsoft Excel 2010. While creating forms for a number of users, he is required to repeat some of the actions multiple times. It is a very time consuming process. To resolve the issue, he has created a macro to record the sequence of actions to perform a certain task. Now, he wants to run the macro to play those exact actions back in the same order. Which of the following steps will Rick take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

Answer options

• A. Click on the 'Macros' icon in the 'Developer' tab under the 'Code' category to run a Macro.
• B. The Macro will be run in any worksheet of the Workbook.
• C. Put the workbook in a trusted location.
• D. The Macro dialogue box appears on the screen which contains a list of Macros in it. Select the Macro to run and click the Run button.
• E. Run the created Macro by using the shortcut key specified while creating the Macro.

Correct answer: A, B, D, E

Explanation

To run the macro, Rick needs to access the Macros icon in the Developer tab (A), and he can execute the macro from any worksheet in the workbook (B). The Macro dialog box allows him to select and run the desired macro (D), and he can also use the defined shortcut key for quick access (E). Option C, while important for security, is not necessary for running the macro itself.