Microsoft 77-427 Exam Questions & Answers

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

The following steps are taken to input Excel array formulas:

1.

Highlight the range of cells that a user wants to use as an input in his array formula.

2.

Type the array formula into the first cell or make this cell editable by pressing F2 or clicking

in the formula bar if a user has already specified a value into the first cell.

3.

Press CTRL-SHIFT-Enter.

Answer option C is incorrect. This is an invalid answer option.

Correct Answer: C

The various Protect Workbook options are as follows:

1.

Mark as Final: This option is used to make the document read-only. When a spreadsheet is marked as final, various options such as typing, editing commands, and proofing marks are disabled or turned off and the spreadsheet becomes

read-only. This command helps a user to communicate that he is sharing a completed version of a spreadsheet. This command also prevents reviewers or readers from making inadvertent modifications to the spreadsheet.

2.

Encrypt with Password: When a user selects the Encrypt with Password option, the Encrypt Document dialog box appears. In the Password box, it is required to specify a password. Microsoft is not able to retrieve lost or forgotten

passwords, so it is necessary for a user to keep a list of passwords and corresponding file names in a safe place.

3.

Protect Current Sheet: This option is used to select password protection and permit or prohibit other users to select, format, insert, delete, sort, or edit areas of the spreadsheet. This option

protects the worksheet and locked cells.

4.

Protect Workbook Structure: This option is used to select password protection and select options to prevent users from changing, moving, and deleting important data. This feature enables a user to protect the structure of the worksheet.

5.

Restrict Permission by People: This option works on the basis of Window Rights Management to restrict permissions. A user is required to use a Windows Live ID or a Microsoft Windows account to restrict permissions. These permissions

can be applied via a template that is used by the organization in which the user is working. These permissions can also be added by clicking

Restrict Access.

6.

Add a Digital Signature: This option is used to add a visible or invisible digital signature.

It authenticates digital information such as documents, e-mail messages, and macros by using computer cryptography. These signatures are created by specifying a signature or by using an image of a signature for establishing authenticity,

integrity, and non-repudiation.

Answer option D is incorrect. You can create a new document with the same details but it will increase the overhead and is a very time consuming process. Answer option D is incorrect. You can create a new document with the same details but it will increase the overhead and is a very time consuming process.