Microsoft Exam 77-427 Topic 9 Question 30 Discussion

Actual exam question for Microsoft's exam

Question #: 30
Topic #: 9

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.

ACreate a copy of a slicer connected with the PivotTable.

BCreate a slicer connected with the PivotTable.

CCreate a slicer by disabling Macros associated with the PivotTable.

DUse an existing slicer connected with another PivotTable.

Show Suggested Answer

Suggested Answer: A, B, D

The various ways to use or create slicers to filter PivotTable data in an existing PivotTable are as follows:

Create a slicer connected with the PivotTable.

Create a copy of a slicer connected with the PivotTable.

Use an existing slicer connected with another PivotTable. Answer option C is incorrect. This is an invalid answer option.

by Lawrence at May 08, 2022, 08:53 PM

Limited Time Offer

25%

Off

Get Premium Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!