Multiple Choice
Hari wants to connect a slicer to three pivot tables so that he can control the entire dashboard with a single slicer.To do so,he selects the pivot tables to connect a slicer,then selects a cell in any of them,then clicks on three group/tab/button in a series.Next from the "Insert Slicer" dialog box,he selects the column to use as a filter in the slicer and clicks OK.What can be the three clicks he made during the procedure?
A) Analyze tab → Filter → Refresh
B) Analyze tab → Filter → Insert Slicer
C) Analyze tab → Show/Hide → Field List
D) Analyze tab → Show/Hide → Field Button
Correct Answer:

Verified
Correct Answer:
Verified
Q39: Dante wants to calculate the currently monthly
Q40: To collapse data views using the Outline
Q41: How can you remove Split panes in
Q42: To remove duplicate values from an Excel
Q43: Nisha wants to freeze all rows above
Q45: Which of the following keys will you
Q46: Leigh-Ann wants to filter data in a
Q47: Adele wants to extract a list of
Q48: Which of these tabs will you select
Q49: Which of the following boxes will you