Online Access Free 077-427 Practice Test

You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You have inserted the following formula in a cell:
VLOOKUP(12, A2:C10, 3, FALSE )
Which of the following actions will be performed by the formula?

• A.Wrong syntax used.
• B.Search the value 3 in the last column of the range, and then returns the value that is in the column of the range and on the same row as the lookup value.
• C.Search the value 12 in the third column of the range and then returns the value that is contained in the 12th column of the range and on the same column as the lookup value.
• D.Search for the value 12 in the first column of the range, and then returns the value that is contained in the third column of the range and on the same row as the lookup value.

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 fetch the password from the list in which you have saved it.
• B.You will ask Microsoft to retrieve the password.
• C.You will create a new document.
• D.You will use a new password.

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the
company's high selling products. You are trying to intersect two ranges that do not intersect each
other. Which of the following errors will be occurred in this situation?

• A.#NULL!
• B.#DIV/0!
• C.#VALUE!
• D.#NAME?

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

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.Scenario
• B.Solver add-in
• C.Data table
• D.Goal Seek