Microsoft 77-427 Real Exam Dumps

Question No : 6

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a user form through Microsoft Excel 2013. 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.

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:
Take the following steps to run a Macro:
1. Click on the 'Macros' icon in the 'Developer' tab under the 'Code' category to run a Macro.

2. 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.

3. The Macro will be run in any worksheet of the Workbook. 

4. A user can run the created Macro by using the shortcut key that he has specified while creating the Macro. The macro records the user's mouse clicks and keystrokes while he works and lets him play them back later. The macro can be used to record the sequence of commands that the user uses to perform a certain task. When the user runs the macro, it plays those exact commands back in the same order. Answer option C is incorrect. The benefit of connecting to external data from Microsoft Excel is that a user can automatically update Excel workbooks from the real data source whenever the data source is updated with new information. It is possible that the external data connection might be disabled on the computer. For connecting to the data source whenever a workbook is opened, it is required to enable data connections by using the Trust Center bar or by putting the workbook in a trusted location.