최신 77-427 무료덤프 - Microsoft Excel 2013 Expert Part One
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?
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?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You are creating a hot spot on a graphic that other users can click to run a macro. 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.
Each correct answer represents a part of the solution. Choose all that apply.
정답: A,B,C,D,E,F,G,H
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.
Which of the following financial functions will you use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.
정답: C,D
설명: (DumpTOP 회원만 볼 수 있음)
You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are at the step of adding the following lines of code to the procedure:
"Private Sub Workbook_Open() MsgBox Time Worksheets("Sheet2").Range("A2").Value = Time End Sub"
Which of the following are the next steps that you will take to accomplish the task? Each correct
answer represents a part of the solution. Choose all that apply.
"Private Sub Workbook_Open() MsgBox Time Worksheets("Sheet2").Range("A2").Value = Time End Sub"
Which of the following are the next steps that you will take to accomplish the task? Each correct
answer represents a part of the solution. Choose all that apply.
정답: A,C,D
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?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
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?
VLOOKUP(12, A2:C10, 3, FALSE )
Which of the following actions will be performed by the formula?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. Some employees have changed some data in the worksheet of the company. You want to identify changes that were made to the data in the workbook and then take a decision whether to accept or reject those changes. For this purpose, it is required to access and use the stored change history.
Which of the following will you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.
Which of the following will you use to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.
정답: B,C,D
설명: (DumpTOP 회원만 볼 수 있음)