Online Access Free 077-427 Practice Test

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.
Rick has to perform the following tasks:
Summarize large amounts of data. Analyze numeric data.
Answer unexpected questions about data.
Which of the following actions will Rick take to accomplish the task?

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

You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in
Microsoft Excel 2013. 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.Select the Macro-enabled checkbox in the Insert Security dialog box, and then click OK.
• B.Click PivotTable or click the arrow below PivotTable, and then click PivotTable in the Tables group on the Insert tab.
• C.Choose Select a table or range under Choose the data that you want to analyze.
• D.Click a cell in the cell range that contains data for using worksheet data as the data source.
• E.Click OK.

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 by disabling Macros associated with the PivotTable.
• B.Create a copy of a slicer connected with the PivotTable.
• C.Create a slicer connected with the PivotTable.
• D.Use an existing slicer connected with another PivotTable.

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 Tab Color option from the shortcut menu.
• B.Select the sheets containing charts.
  Right-click on the sheet tabs.
  Choose the Sheet Color option from the shortcut menu.
• 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.
  Select the Effects option in the Themes group on the Page Layout page.

You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to 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 using a slicer. After filtering the data, you want to disconnect the slicer. You have clicked anywhere in the PivotTable report. Which of the following steps will you take next to accomplish the task?
Each correct answer represents a part of the solution. Choose all that apply.

• A.Clear the check box of any PivotTable fields for which you want to disconnect a slicer.
• B.Click the slicer, and then press Delete.
• C.Click the Insert Slicer arrow, and then click Slicer Connections on the Options tab in the Sort & Filter group.
• D.Right-click the slicer, and then click Remove <Name of slicer>.