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

You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the company. You have created a sales report in a workbook of Excel 2013.
Your workbook includes several worksheets as shown in the image given below:
You want the sheet tabs of the sheets containing charts to appear in red color. Which of the
following steps will you take to accomplish the task?

• A.Select the sheets containing charts.
  Right-click on the sheet tabs.
  Choose the Sheet Color option from the shortcut menu.
• B.Select the sheets containing charts.
  Select the Effects option in the Themes group on the Page Layout page.
• C.Select the sheets containing charts.
  Select the Colors option in the Themes group on the Page Layout page.
• D.Select the sheets containing charts.
  Right-click on the sheet tabs.
  Choose the Tab Color option from the shortcut menu.

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 Manager for Blue Well Inc. The company has a Windows-based network. You have a formula that uses one or two variables or multiple formulas that all use one common
variable. You want to examine a range of possibilities at a glance. Which of the following will you use to accomplish the task?

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

You work as a Help Desk Technician for Dreams Unlimited Inc. Martha, a Sales Manager, is creating a sales report in Microsoft Excel. The report contains many worksheets. Martha has used many formulas in her report. She wants to monitor a cell which contains a formula. The formula refers to many other cells that are located in different worksheets in the report. She wants to know the effects on the cell when the values in different sheets change. She requests that you help her out to accomplish the task. Which of the following steps would you suggest she take in order to accomplish the task?

• A.Select the cell which is to be monitored.
  On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch.
• B.Click the New Window option in the Window group on the View tab. Click the Arrange All
  option in the Window group on the View tab. Select the Cascade option.
• C.Click the New Window option in the Window group on the View tab. Click the Arrange All
  option in the Window group on the View tab. Select the Vertical option.
• D.Select the cell which is to be monitored.
  On the Formulas tab in the Formula Auditing group, click Evaluate Formula.

Which of the following steps will you take to merge copies of a shared workbook? Each correct
answer represents a part of the solution. Choose all that apply.

• A.Add Compare and Merge Workbooks.
• B.Save the workbook if prompted.
• C.Click Compare and Merge Workbooks on Macro Enabled Access Toolbar.
• D.Open the copy of the shared workbook to merge the changes.
• E.In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook containing changes to be merged, and then click OK.
• F.Click Compare and Merge Workbooks on Quick Access Toolbar.