Hari Wants to Connect a Slicer to Three Pivot Tables

question 44

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

---

Definitions:

AAR

Average Annual Return, which measures the average return generated by an investment per year over a specified period.

NPV

Net Present Value; a method used in capital budgeting to evaluate the profitability of an investment, calculating the difference between the present value of cash inflows and outflows.

Discounted Payback Period

The time it takes for an investment to generate cash flows to recover its initial cost, accounting for the time value of money.

Cash Inflows

The total amount of money being transferred into a business, project, or financial product, typically measured within a specific period.