Free Microsoft 077-427 Exam Dumps Questions & Answers

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You are creating a chart in Excel 2013. You want to show the slope of data points in the chart to know the trend of the Business Intelligence data range. Which of the following will you use to accomplish the task?

• A.  Backstage view
• B.  Trendline
• C.  Line charts
• D.  Sparkline

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 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.  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.
• B.  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.
• C.  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.
• D.  Wrong syntax used.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to get the trend of the Business data range. For this purpose, you want to use trendlines in the chart. Which of the following steps will you take to apply the trendlines in the chart?
Each correct answer represents a part of the solution. Choose all that apply.

• A.  Clear the check box of any Trendline fields to disconnect a slicer.
• B.  Select the type that you want from Trendline options.
• C.  Select a chart and then navigate to the Chart Tools Layout tab.
• D.  Click the Insert Trendline arrow, and then click Trendline Connections on the Options tab in the Sort & Filter group.

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,TRUE)
• B.  =VLOOKUP(2,Item_table,B2,TRUE)
• C.  =VLOOKUP(B2,Item_table,2,FALSE)
• D.  =VLOOKUP(2,Item_table,B2,FALSE)