77-888 무료 덤프문제 온라인 액세스

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 2010. 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.Gantt Chart Template
• B.Form control
• C.Accounting template
• D.Trust Center

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to quickly filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are required to use a slicer. Which of the following are the ways that you can use to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.

• A.Create a slicer connected with the PivotTable.
• B.Create a copy of a slicer connected with the PivotTable.
• C.Use an existing slicer connected with another PivotTable.
• D.Create a slicer by disabling Macros associated with the PivotTable.

You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2010. The report worksheet will include the sales made by all the sales managers in the month of January.
In the worksheet, you are required to place a pictorial representation displaying the percentage of
total sales made by each sales manager in January. Which of the following charts will you use to
accomplish the task?

• A.Pie
• B.Bar
• C.Column
• D.Line

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

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in
Microsoft Excel 2010. You want to summarize a large amount of data to analyze numerical data and to answer unexpected questions about your data in the Business Intelligence (BI) report that you are working with. For this purpose, you are required to create a 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.Choose Select a table or range under Choose the data that you want to analyze.
• B.Click OK.
• C.Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.
• D.Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.
• E.Click a cell in the cell range that contains data for using worksheet data as the data source.