077-427 무료 덤프문제 온라인 액세스

You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining the financial budget and other financial calculations. You want to return the price per $100 face value of a security that pays interest at maturity. Which of the following financial functions will you use to accomplish the task?

• A.PPMT function
• B.PRICEDISC function
• C.PRICEMAT function
• D.PRICE function

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.All filter
• C.Find
• D.Sort

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2013. You have a number of PivotTables in a single report. You want to apply the same filter to all of those PivotTables. For this purpose, you are required to create a slicer in one PivotTable and share it with other PivotTables. 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.Select the Macro enabled checkbox of the PivotTable fields for which you want to create a slicer in the Insert Security dialog box and then click OK.
• B.Hold down CTRL, and then click the items on which you want to filter.
• C.Click Insert Slicer in the Sort & Filter group on the Options tab.
• D.In the Insert Slicers dialog box, select the check box of the PivotTable fields for which
  you
  want to create a slicer.
• E.Click anywhere in the PivotTable report for which you want to create a slicer.

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.Click Compare and Merge Workbooks on Quick Access Toolbar.
• C.Add Compare and Merge Workbooks.
• D.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.
• E.Open the copy of the shared workbook to merge the changes.
• F.Save the workbook if prompted.

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel 2013. Rick wants to interact with cell data but his computer does not contain VBA code and few features of his computer are still Excel 5. 0 features. Which of the following will
Rick use to accomplish the task?

• A.Evaluate Formula
• B.Accounting template
• C.Form control
• D.Trust Center