Free Microsoft 77-427 Exam Dumps Questions & Answers

HOTSPOT
You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2013 application on the network. You open the application and see various changes in Excel 2013. You have to open an existing worksheet through the application. You are unable to find the Office button.
Mark the option that you will click to accomplish the task.

Correct Answer:

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You have included various subtotals in a worksheet in the report to verify data accuracy. You want to remove all subtotals from the sheet before you send it to your manager.
Which of the following steps will you take to accomplish the task with the least administrative effort?

• A.Delete all the rows containing subtotals.
• B.Hide the rows containing subtotals.
• C.Select all the subtotals. From the shortcut menu, click the Remove All Subtotals option.
• D.Open the Subtotal dialog box by clicking the Subtotal option in the Outline group on the Data tab. Click the Remove All button.

You work as a Sales Manager for Maini Industries. Your company manufactures and sells
construction equipment. You have to create a report that will show the highest selling items of each month. The report will be in the following format:

In a workbook, you create a table named Item_table as shown below:

You fill in the required entries in the workbook.

For the third column of the sheet, you want to use formulas to fill in the values. You want the
cells in the third column to get automatically filled with the names corresponding to ItemID in the second column. You want the exact values to be filled in the column. You select the C2 cell in the third column.
Which of the following formulas will you enter in order to accomplish the task?

• A.=VLOOKUP(B2,Item_table,2,FALSE)
• B.=VLOOKUP(2,Item_table,B2,TRUE)
• C.=VLOOKUP(B2,Item_table,2,TRUE)
• D.=VLOOKUP(2,Item_table,B2,FALSE)

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

Which of the following steps will you take to merge copies of a shared workbook? Each correct
answer represents a part of the solution. Choose all that apply.

• A.Click Compare and Merge Workbooks on Macro Enabled Access Toolbar.
• B.Add Compare and Merge Workbooks.
• C.In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook containing changes to be merged, and then click OK.
• D.Click Compare and Merge Workbooks on Quick Access Toolbar.
• E.Save the workbook if prompted.
• F.Open the copy of the shared workbook to merge the changes.