Excel 2013 Expert Part One: 77-427

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: B

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 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 anexisting macro to a control, or write or record a new macro.

These controls cannot be added to User Forms, used to control events, or modified to run Web scripts on Web pages.

Answer option A 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 D is incorrect. Trust Center is where a user can find security and privacy settings For Microsoft Office 2013 programs.

Correct Answer: D

In order to accomplish the task, you will have to insert the following formula:

=$B$3/100 * E8

According to the question, the formula will be inserted in cell F8 and then the cell's border will be dragged to the F12 cell. Furthermore, the incentive percentage is fixed for all sales managers

and the value is provided in the cell B3. You will have to insert a formula that refers to the B3 cell as an absolute reference. For this you will have to type currency symbol ($) before the row

name and column number. In order to accomplish the task, type the following formula in the cell F8:

=$B$3/100 * E8

When absolute reference is used for referencing a cell in a formula, dragging cell's border to another cell does not change the cell's reference. Answer options B and E are incorrect. This formula references the B3 cell as a relative reference.

After inserting the formula, when the cell's border is dragged, it will change the cell reference relatively.

Answer options A and C are incorrect. Ampersand symbol (and) is not used for referencing cells in Excel.