Microsoft 077-427 Actual Free Exam Questions & Community Discussion

Which of the following is used to display a trend based on adjacent data in a clear and compact
graphical representation by taking up a small amount of space?

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.

Which of the following can be 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?

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.

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. 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. Which of the following steps will you take to resolve the problem? Each correct answer represents a part of the solution. Choose all that apply.

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick has to perform the following tasks:
Summarize large amounts of data. Analyze numeric data.
Answer unexpected questions about data.
Which of the following actions will Rick take to accomplish the task?

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in
Microsoft Excel 2013. You want to export XMLdata to your Excel 2013 worksheet. On exporting the XML data, the following error message appears:
"XML MAPS IN MY WORKBOOK ARE NOT EXPORTABLE"
Which of the following are the reasons that are causing the above error? Each correct answer
represents a complete solution. Choose all that apply.