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

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.Scenario
• B.Solver add-in
• C.Data table
• D.Goal Seek

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-
based network. He is creating a form through Microsoft Excel 2013. He wants to enable worksheet forms to satisfy the flexible design requirements and to customize their appearance, behavior, fonts, and other characteristics. Which of the following will Rick use to accomplish the task?

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

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.=B3/100 * E8
• B.=B3/100 * &E&8
• C.=&B&3/100 * E8
• D.=$B$3/100 * E8
• E.=B3/100 * $E$8

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in
Microsoft Excel 2013. You want to export XMLdata to your Excel 2013 worksheet. On exporting the XML data, the following error message appears:
"XML MAPS IN MY WORKBOOK ARE NOT EXPORTABLE"
Which of the following are the reasons that are causing the above error? Each correct answer
represents a complete solution. Choose all that apply.

• A.The maxoccurs attribute is not equal to 1.
• B.The XML map associated with this XML table contains one or more required elements that are not mapped to the XML table.
• C.The relationship of the mapped element with other elements is not preserved.
• D.The element is a recursive structure.

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 in the columns. While doing so, 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. You want to store sets of values as text and convert sets of data to text by using Excel's Text To Columns tool. 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 cells to convert their data to text.
• B.Select the Text to Columns option from the Data tab at the top of the Excel workbook.
• C.Select the Delimited option and click Next
• D.Make sure that all delimiter options are unselected, and then again click Next.
• E.Select Text and click the Finish button in Column Data Formats.
• F.Remove the unseen spaces at the start or end of the first Macro cell.