Microsoft 77-427 dumps - 100% Pass Guarantee!

Correct Answer: ABDE

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.

Correct Answer: C

A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 0. It is designed for use on XLM macro sheets. It can be used when a user wants to simply interact with cell data without using VBA code and when he wants to add controls to chart sheets. By using form controls, the user can run macros. He can attach an existing macro to a control, or write or record a new macro. These controls cannot be added to UserForms, used to control events, or modified to run Web scripts on Web pages. Answer option A is incorrect. The accounting template is used for numbering months of a financial year to period numbering. It is used to compare month to month, actual v budget, quarter to quarter, year to year variances. It is the initial point for other reports that need the use of months. Answer option D is incorrect. Evaluate Formula is the formula examination tool provided by Microsoft Excel. This tool is useful for examining formulas that do not produce any error but are not generating the expected result.Answer option B is incorrect. Trust Center is where a user can find security and privacy settings for Microsoft Office 2013 programs.

Correct Answer: D

A macro is defined as a tool that permits a user to automate tasks and add several functionalities to forms, reports, and controls. For example, if a user adds a command button to a form, he associates the button's OnClick event to a macro,

and the macro consists of the commands that are to be performed by the button each time it is clicked. 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 B is incorrect. Evaluate Formula is a formula examination tool provided by Microsoft Excel. This tool is useful for examining formulas that do not produce any error but are not generating the expected result.

Answer options A and C are 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 wheneverthe 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.

Correct Answer: D

Slicers are defined as easy-to-use filtering components containing a set of buttons that enable users to quickly filter data in a PivotTable report, without opening drop-down lists to find the items to filter.

When a user uses a regular PivotTable report filter to filter on multiple items, the filter indicates only that multiple items are filtered and the user has to open a drop-down list to find the filtering details. However, a slicer clearly labels the filter

that is applied and provides details so that the data displayed in the filtered PivotTable report can be easily understood.

Answer option B is incorrect. ActiveX controls are used on worksheet forms, with or without the use of VBA code, and on VBA UserForms.

They are used when a user needs more flexible design requirements than those provided by Form controls. They have extensive properties that can be used to customize their appearance, behavior, fonts, and other characteristics. The user

can control different events that occur when an ActiveX control is interacted with. He can also write macros that respond to events associated with the ActiveX controls. When a user interacts with the control, the VBA code runs to process any

events that occur for that control. The ActiveX controls cannot be added to chart sheets from the user interface or to XLM macro sheets. It is not possible to assign a macro to run directly from the ActiveX control. Answer option C is incorrect.

A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 0. It is designed for use on XLM macro sheets. It can be used when a user wants to simply interact with cell data without using

VBA code and when he wants to add controls to chart sheets. By using form controls, the user can run macros. He can attach an existing macro to a control, or write or record a new macro. These controls cannot be added to UserForms,

used to control events, or modified to run Web scripts on Web pages.

Answer option A is incorrect. The accounting template is used for numbering months of a financial year to period numbering. It is used to compare month to month, actual v budget, quarter to quarter, year to year variances. It is the initial point

for other reports that need the use of months.

Correct Answer: A

The Excel Won't Calculate My Function error occurs when a user types in a function and presses Enter, the cell shows the function as the user typed it, instead of returning the function's value. The reason that causes this problem is that the cells containing the formula are formatted as 'text' instead of the 'General' type. This happens when the user inserts a new column, next to a column that is already formatted as text due to which the new column inherits the formatting of the adjacent column. Answer option D is incorrect. The Failure to Look Up Values in Excel error occurs when a user gets an unexpected error while trying to look up or match a lookup_value within an array and Excel is not able to recognize the matching value. If the lookup_value or the array the user is searching resides in a cell, the user can have unseen spaces at the start or end of that cell. This will create the situation where the contents of the two cells that the user is comparing look the same but extra spaces in one of the cells cause the cells to have slightly different content. The other reason is that the contents of the cells that are being compared may have different data types.

Answer option B is incorrect. The Lookup Function Won't Copy Down to Other Rows error occurs when a user uses a function in one cell and it works perfectly but when he attempts to copy the function down to other rows, he gets the #REF error. The #REF! error arises when Excel tries to reference an invalid cell. This error occurs if the user has referenced an entire worksheet by clicking on the grey square at the top left of the worksheet. For Excel, this reference range is 1 to 1048576. Since the references are Relative References, Excel automatically increases the row references when this cell is copied down to other rows in the spreadsheet. Answer option C is incorrect. The Cell Shows a Date or Time Instead of a Number error occurs because the cell that contains the formula is formatted as a 'date' or 'time' instead of a 'General' type or a number. This situation arises because a user has inserted a new column, next to a column containing Dates or Times, the new column has 'inherited' the formatting of the adjacent column.