Online Access Free 77-427 Exam Questions

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

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You want to change values in cells to observe the way in which those changes are affecting the outcome of formulas in the worksheet. Which of the following will you use to accomplish the task?

• A.Accounting template
• B.Form control
• C.Trust Center
• D.What-if analysis

DRAG DROP
You work as a Help Desk Technician for Net Perfect Inc. You use Excel 2013 to create different
reports for your company. Drag and drop the appropriate methods for efficient data entry in front
of their descriptions.

Correct Answer:

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.Reviewing of changes
• B.Onscreen highlighting
• C.Slicer-enabled highlighting
• D.History tracking

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 want to protect the worksheet and locked cells by permitting or prohibiting other employees to select, format, insert, delete, sort, or edit areas of the spreadsheet. Which of the following options will you use to accomplish the task?

• A.Protect Current Sheet
• B.Protect Workbook Structure
• C.Encrypt with Password
• D.Mark as Final