Free Microsoft 77-427 Exam Dumps Questions & Answers

You work as an Office Assistant for Blue well Inc. You want to record a macro and save it with the name "Auto_Open" so that the macro will run whenever you open the workbook containing the macro.
While doing so, you observe that the Auto_Open macro fails every time. Which of the following are the causes of this?
Each correct answer represents a complete solution. Choose all that apply.

• A.The default workbook or a workbook loaded from the XLStart folder is opened before running the macro.
• B.The workbook where a user wants to save the Auto_Open macro already contains a VBAprocedure in its Open event.
• C.The workbook is based on the record button that is disabled by default before running the Auto_Open macro.
• D.The workbook is opened programmatically using the Open method.

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2013 and shared it with the other employees of the company. You select the Encrypt with Password option as a protection measure for the document you are sharing. Now, you have to specify a password in the Password box in the Encrypt Document dialog box appeared for editing the document. But you have forgotten the password. What will happen in this situation?

• A.You will use a new password.
• B.You will fetch the password from the list in which you have saved it.
• C.You will ask Microsoft to retrieve the password.
• D.You will create a new document.

You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are at the step of adding the following lines of code to the procedure:
"Private Sub Workbook_Open() MsgBox Time Worksheets("Sheet2").Range("A2").Value = Time End Sub"
Which of the following are the next steps that you will take to accomplish the task? Each correct
answer represents a part of the solution. Choose all that apply.

• A.Switch to Excel and save the workbook with the .xslm extension as a macro-enabled workbook and close it.
• B.Reopen the workbook.
• C.Under Macro Settings in the Macro Settings category, click Enable all macros, and then click OK.
• D.Click OK in the message box.

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel
2013. Rick wants to trace the project with the actual requirements. For this purpose, he is
required to compare month to month, actual v budget, quarter to quarter, year to year variances.
Which of the following will Rick use to accomplish the task?

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

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the company's high selling products. You want to find out the matching values in the columns. While doing so, you get an unexpected error that when you attempt to look up or match a lookup_value within an array; Excel is not able to recognize the matching value. You want to store sets of values as text and convert sets of data to text by using Excel's Text To Columns tool. Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A.Select the Delimited option and click Next
• B.Select the Text to Columns option from the Data tab at the top of the Excel workbook.
• C.Remove the unseen spaces at the start or end of the first Macro cell.
• D.Make sure that all delimiter options are unselected, and then again click Next.
• E.Select the cells to convert their data to text.
• F.Select Text and click the Finish button in Column Data Formats.