Free Microsoft 077-427 Exam Dumps Questions & Answers

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.  Run the created Macro by using the shortcut key specified while creating the Macro.
• C.  Put the workbook in a trusted location.
• D.  The Macro will be run in any worksheet of the Workbook.
• E.  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.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are using a slicer. After filtering the data, you want to disconnect the slicer. You have clicked anywhere in the PivotTable report. Which of the following steps will you take next to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A.  Click the slicer, and then press Delete.
• B.  Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort & Filter group.
• C.  Clear the check box of any PivotTable fields for which you want to disconnect a slicer.
• D.  Right-click the slicer, and then click Remove <Name of slicer>.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You are creating a chart in Excel 2013. You want to show the slope of data points in the chart to know the trend of the Business Intelligence data range. Which of the following will you use to accomplish the task?

• A.  Line charts
• B.  Backstage view
• C.  Sparkline
• D.  Trendline

DRAG DROP
You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2013 to create different
reports for your company. Drag and drop the appropriate methods for efficient data entry in front
of their descriptions.

Correct Answer:

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-
based network. He is creating a form through Microsoft Excel 2013. He wants to enable worksheet forms to satisfy the flexible design requirements and to customize their appearance, behavior, fonts, and other characteristics. Which of the following will Rick use to accomplish the task?

• A.  Trust Center
• B.  Accounting template
• C.  Form control
• D.  ActiveX control