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

You work as a Project Manager for Blue Well Inc. The company has a Windows-based network. You want to rename a worksheet as Important.
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.Enter the name and click the OK button.
• B.Right-click on the Sheet tab and select the Rename option.
• C.Delete the old name, type the new name, and then click OK.
• D.Click the Insert tab and open the name sheet.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You have changed some data in the worksheet of the company. You are submitting the sell workbook of the company to the Administrator of the company for comments. Now, you want to merge input that you receive into a copy of that workbook, including the changes and comments that you want to keep. 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?

• A.Slicer-enabled highlighting
• B.History tracking
• C.Onscreen highlighting
• D.Reviewing of changes

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a user form through
Microsoft Excel 2013. While creating forms for a number of users, he is required to repeat some of the actions multiple times. It is a very time consuming process. To resolve the issue, he has created a macro to record the sequence of actions to perform a certain task. Now, he wants to run the macro to play those exact actions back in the same order. Which of the following steps will Rick take to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A.Put the workbook in a trusted location.
• B.Click on the 'Macros' icon in the 'Developer' tab under the 'Code' category to run a
  Macro.
• C.The Macro dialogue box appears on the screen which contains a list of Macros in it.
  Select the
  Macro to run and click the Run button.
• D.The Macro will be run in any worksheet of the Workbook.
• E.Run the created Macro by using the shortcut key specified while creating the Macro.

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

You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You use a function in one cell and it works perfectly but when you attempt to copy the function down to other rows, you get the #REF error. 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.Excel is trying to reference an invalid cell.
• B.You are referencing an entire worksheet by clicking on the grey square at the top left of the worksheet.
• 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.You are inserting a new column, next to a column that is already formatted as text.