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

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.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.
• B.Select the cell which is to be monitored.
  On the Formulas tab in the Formula Auditing group, click Evaluate Formula.
• C.Select the cell which is to be monitored.
  On the Formulas tab in the Formula Auditing group, click Watch Window. Click Add Watch.
• D.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.

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

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a user form through Microsoft Excel 2010. 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.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.
• B.Put the workbook in a trusted location.
• C.Run the created Macro by using the shortcut key specified while creating the Macro.
• D.The Macro will be run in any worksheet of the Workbook.
• E.Click on the 'Macros' icon in the 'Developer' tab under the 'Code' category to run a
  Macro.

You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 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 ask Microsoft to retrieve the password.
• B.You will create a new document.
• C.You will use a new password.
• D.You will fetch the password from the list in which you have saved it.

Which of the following can be defined as easy-to-use filtering components containing a set
of buttons that enable users to quickly filter data in a PivotTable report, without opening
drop-down lists to find the items to filter?

• A.Accounting templates
• B.ActiveX controls
• C.Slicers
• D.Form controls