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
Q40: Ursula wants to freeze the header row
Q41: Sala wants to unfreeze the first column
Q42: Which of these tabs will you select
Q43: Grace wants to connect a slicer to
Q44: Leigh-Ann wants to filter data in a
Q45: Which of these keys will you hold
Q47: Which of these combination of keys will
Q48: To view a worksheet without gridlines showing
Q49: How can you remove Split panes in
Q50: What will you select as X in
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents