077-427 試験問題を無料オンラインアクセス

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the
company's high selling products. You want to find out the matching values. You get an unexpected error that when you attempt to look up or match a lookup_value within an array, Excel is not able to recognize the matching value. Which of the following steps will you take to resolve the problem? Each correct answer represents a part of the solution. Choose all that apply.

• A.Delete the column having the TRIM function.
• B.Use the TRIM function in the new column.
• C.Copy the contents of the new column and paste them on the top of the original column by using paste > special > values sequence.
• D.Create a new column subsequent to the one with the additional spaces in it.
• E.Remove the unseen spaces at the start or end of the first Macro cell.

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.PRICEMAT function
• C.PRICE function
• D.PRICEDISC function

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the
company's high selling products. You input a formula for calculating the monthly sell of a particular product but your Excel cell shows a string of # symbols instead of returning a value as
shown below: Which of the following are the reasons that are causing the above problem? Each correct answer

represents a complete solution. Choose all that apply.

• A.You are inserting a new column, next to a column that is already formatted as text.
• B.The cell is not wide enough for displaying the calculated value.
• C.The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.
• D.Excel is trying to show the contents of the cell as a date or time stored as positive numeric values within Excel, but the cell contains a negative value.

You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have two budget situations in which one is the worst case and the other is the best case. You want to create both situations on the same worksheet and then switch between them with the change in requirements. Which of the following will you use to accomplish the task?

• A.Goal Seek
• B.Scenario
• C.Solver add-in
• D.Data table

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2013 and shared it with the other employees of the company. You select the Encrypt with Password option as a protection measure for the document you are sharing. Now, you have to specify a password in the Password box in the Encrypt Document dialog box appeared for editing the document. But you have forgotten the password. What will happen in this situation?

• A.You will use a new password.
• B.You will fetch the password from the list in which you have saved it.
• C.You will ask Microsoft to retrieve the password.
• D.You will create a new document.