Online Access Free 077-427 Exam Questions

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that were made to the data in the workbook and then take a decision whether to accept or reject those changes. For this purpose, it is required to access and use the stored change history.
Which of the following will you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.

• A.Slicer-enabled highlighting
• B.History tracking
• C.Onscreen highlighting
• D.Reviewing of changes

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have two budget situations in which one is the worst case and the other is the best case. You want to create both situations on the same worksheet and then switch between them with the change in requirements. Which of the following will you use to accomplish the task?

• A.Data table
• B.Solver add-in
• C.Scenario
• D.Goal Seek

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?

• A.He will use stand-alone slicers.
• B.He will create a PivotTable report.
• C.He will configure form controls.
• D.He will create the accounting template.

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?

• A.Create sparklines.
• B.Configure form controls.
• C.Use stand-alone slicers.
• D.Create a PivotTable report.

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-
based network. He is creating a form through Microsoft Excel 2013. He wants to enable worksheet forms to satisfy the flexible design requirements and to customize their appearance, behavior, fonts, and other characteristics. Which of the following will Rick use to accomplish the task?

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