Larkfield Logistics has a workbook of six worksheets built on one shared data source. An analyst sets a [Carrier] dimension filter on the first worksheet, then opens the filter card menu and chooses Apply to Worksheets, then All Using This Data Source. Which TWO statements correctly describe how this scoped filter then behaves? Select TWO.
- AThe same [Carrier] filter selection is shared by every existing worksheet that is built on that one data source, kept in step across them. Correct
- BA new worksheet added later on the same data source inherits the [Carrier] filter automatically, because the scope follows the data source not the sheets. Correct
- CWorksheets built on a different data source in the same workbook are also filtered by [Carrier] as long as they contain a matching field.
- DThe setting silently converts the [Carrier] filter into a data source filter that removes the excluded carriers before any worksheet queries run.
- EEach worksheet keeps its own independent copy of the [Carrier] filter, so changing it on one sheet leaves the others on their previous selection.
Why A is correct: All Using This Data Source binds the worksheets to one shared filter state, so a change on any of them updates the others together.
Why B is correct: Because the scope is tied to the data source, sheets created afterwards on that source pick up the existing shared filter without manual reapplication.
Why C is wrong: This sounds plausible but the scope is limited to the one data source, so sheets on a separate source are untouched even with a like-named field.
Why D is wrong: Apply to Worksheets is a sheet-scope option, not a data source filter, so it does not change the extract-level or pre-query filtering layer.
Why E is wrong: That describes the default Only This Worksheet scope, which is exactly the behaviour this All Using This Data Source choice overrides.