Free Microsoft 77-427 Exam Dumps Questions & Answers

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?

• A.  Autofilter
• B.  Sort
• C.  All filter
• D.  Find

Rick works as a Sales Manager for Tech Perfect Inc. He is creating a report in Excel 2013. He has entered data in five worksheets in a workbook. He wants to enter a disclaimer message in the A1 cell of each sheet in the workbook as shown in the image given below: Which of the following is the easiest way to accomplish the task?

• A.  Write a disclaimer message in the A1 cell of the first sheet.
  In the other sheets, insert a formula that points to the A1 cell of the first worksheet.
• B.  Select all the five sheets. Click the first sheet.
  Write a disclaimer message in the A1 cell of the active sheet.
• C.  Write a disclaimer message in the A1 cell of the first sheet.
  Copy the disclaimer message and paste it on the remaining sheets.
• D.  Select all the five sheets.
  Write a disclaimer message in the A1 cell of the active sheet.

You work as an Office Assistant for Tech Perfect Inc.
You are working in a spreadsheet as shown below:
You want to use Excel Transpose Function for copying the contents of cells B1:B3 into cells A5:C5.
You simply type '=TRANSPOSE( B1:B3 )' into the cells A5:C5. It displays the Excel #VALUE! error message because the cells are working independently and the function will not work for each individual cell. Therefore, it is required to make the cells A5:C5 work together as an ARRAY. For this purpose, you are required to use an array formula. Which of the following steps will you take to input Excel array formulas in the spreadsheet?
Each correct answer represents a part of the solution. Choose all that apply.

• A.  Highlight the range of cells that you want to use as an input in his array formula.
• B.  Press CTRL-SHIFT-Tab to remove the error message.
• C.  Press CTRL-SHIFT-Enter.
• D.  Type the array formula into the first cell.

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 a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining financial budget and other financial calculations. You want to return the depreciation of an asset for a specified period by using the fixed-declining balance method and to return the future value of a starting principal after applying a series of compound interest rates.
Which of the following financial functions will you use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

• A.  NPV function
• B.  DDB function
• C.  DB function
• D.  FVSCHEDULE function