nerdexam
Microsoft

77-427 · Question #34

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…

The correct answer is A. Create a copy of a slicer connected with the PivotTable. B. Create a slicer connected with the PivotTable. D. Use an existing slicer connected with another PivotTable. The various ways to use or create slicers to filter PivotTable data in an existing PivotTable are as 1. Create a slicer connected with the PivotTable. 2. Create a copy of a slicer connected with the PivotTable. 3. Use an existing slicer connected with another PivotTable. Answer…

Create Advanced Charts and PivotTables

Question

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.

Options

  • 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.

How the community answered

(27 responses)
  • A
    81% (22)
  • C
    19% (5)

Explanation

The various ways to use or create slicers to filter PivotTable data in an existing PivotTable are as 1. Create a slicer connected with the PivotTable. 2. Create a copy of a slicer connected with the PivotTable. 3. Use an existing slicer connected with another PivotTable. Answer option C is incorrect. This is an invalid answer option.

Topics

#slicers#PivotTable filtering#slicer connection#standalone slicers

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 77-427 Practice