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

HOTSPOT
You work as a Sales Manager for Rainbow Inc. You are working on a report in a worksheet in Excel 2013. You want to insert flow-chart in the sheet. Mark the option that you will choose to insert flow- chart symbols in the report.
Explanation:
In order to accomplish the task, you will have to choose the Shapes option. Shapes are simple objects provided by Microsoft Office to add them to a document. A single shape or combined multiple shapes can be inserted in the document. The Office includes simple shapes, such as lines, basic geometric shapes, arrows, equation shapes, flowchart
shapes, stars, banners, and callouts. Users can add text, bullets, numbering, and Quick Styles to
these shapes after inserting them in the document. Take the following steps to add a shape in a
document:

正解：

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 create a new document.
• D.You will ask Microsoft to retrieve the password.

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick wants to display data series, categories, data markers, and axes in the report. Which of the
following actions will Rick take to accomplish the task?

• A.He will configure form controls.
• B.He will create a PivotTable report.
• C.He will create a PivotChart report.
• D.He will use stand-alone slicers.

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

You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team
Using Microsoft Excel. You want the report to appear in the following format: You want the Remark column to be filled through a conditional formula. The criteria to give the

remark is as follows:
If the sales of the First Quarter are greater than or equal to 1200, display "Well Done" If the
sales of the First Quarter is less than 1200, display "Improve in Next Quarter"
You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:
Which of the following conditional formulas will you insert to accomplish the task?

• A.=IF(E2>=1200,"Improve in Next Quarter","Well Done")
• B.=IF(E2<=1200,"Well Done","Improve in Next Quarter")
• C.=IF(E2>=1200,"Well Done","Improve in Next Quarter")
• D.=IF(E2>1200,"Improve in Next Quarter","Well Done")