Microsoft 77-427 Actual Free Exam Questions & Community Discussion

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel 2013. Rick wants to interact with cell data but his computer does not contain VBA code and few features of his computer are still Excel 5. 0 features. Which of the following will
Rick use to accomplish the task?

Jack wants the rows containing the name Tom and product Jam. There are thousands of entries in the log. Plowing through all the records will be time taking. Which option can be used to view only the relevant records?

Rick works as an Office Assistant for Tech Perfect Inc. He is responsible for preparing sales
reports of the company. He has created a sales report in a workbook of Excel 2013 and this workbook contains various worksheets as shown in the image given below:

Rick wants the sheet tabs of the sheets containing charts to appear in red color. Which of the
following steps will Rick take to accomplish the task?

You work as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. You are creating a business report by using. Microsoft Excel 2013. You have arranged sales data as shown below:

You want to provide pictorial representation of the trend of the sales data in front of each row.
Which of the following actions will you take to accomplish the task with the least amount of
administrative burden?

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.

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have a formula that uses one or two variables or multiple formulas that all use one common
variable. You want to examine a range of possibilities at a glance. Which of the following will you use to accomplish the task?

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?