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 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.FVSCHEDULE function
• B.DB function
• C.DDB function
• D.NPV function

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.Click anywhere in the PivotTable report for which you want to create a slicer.
• B.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.
• C.In the Insert Slicers dialog box, select the check box of the PivotTable fields for which
  you
  want to create a slicer.
• D.Click Insert Slicer in the Sort & Filter group on the Options tab.
• E.Hold down CTRL, and then click the items on which you want to filter.

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.Select all the five sheets.
  Write a disclaimer message in the A1 cell of the active sheet.
• B.Write a disclaimer message in the A1 cell of the first sheet.
  Copy the disclaimer message and paste it on the remaining sheets.
• C.Select all the five sheets. Click the first sheet.
  Write a disclaimer message in the A1 cell of the active sheet.
• D.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.

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.

정답:

You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a worksheet for preparing the report. You have inserted the sales figures of all sales managers as shown in the image given below:
You have to calculate the first quarter incentives for all sales managers. The incentive percentage
(provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their
total first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell
border to the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you
select the F8 cell. Which of the following formulas will you insert to accomplish the task?

• A.=$B$3/100 * E8
• B.=B3/100 * &E&8
• C.=&B&3/100 * E8
• D.=B3/100 * E8
• E.=B3/100 * $E$8