077-427 무료 덤프문제 온라인 액세스

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.ActiveX control
• B.Trust Center
• C.Accounting template
• D.Form control

You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are at the step of adding the following lines of code to the procedure:
"Private Sub Workbook_Open() MsgBox Time Worksheets("Sheet2").Range("A2").Value = Time End Sub"
Which of the following are the next steps that you will take to accomplish the task? Each correct
answer represents a part of the solution. Choose all that apply.

• A.Click OK in the message box.
• B.Under Macro Settings in the Macro Settings category, click Enable all macros, and then click OK.
• C.Switch to Excel and save the workbook with the .xslm extension as a macro-enabled workbook and close it.
• D.Reopen the workbook.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to make a slicer available for use in another PivotTable. 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.Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort & Filter group.
• B.Click the slicer that you want to share in another PivotTable.
• C.In the PivotTable Connections dialog box, select the check box of the PivotTables in which you want the slicer to be available.
• D.In the Slicer Connections dialog box, clear the check box of any PivotTable fields for which you want to disconnect a slicer.

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 Vertical 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 Cascade option.

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick is creating a project through Microsoft Excel 2013. The project on which he is working has 98 project tasks and 57 team members. Rick wants to check the progress of his project quickly and easily. Which of the following will Rick use to accomplish the task?

• A.Trust Center
• B.Gantt Chart Template
• C.Accounting template
• D.Form control