問題文
A published dashboard should only ever show data for the North America region, and the analyst wants to limit the data as early as possible so unrelated rows never reach the workbook. Which feature is designed for this?
選択肢
- A data source filter that restricts the rows returned from the data source for the whole workbook.
- A set that contains only the North America members.
- A context filter, because it removes the data permanently from the source, and every downstream worksheet inherits that deletion across the workbook.
- A quick filter placed on each worksheet to hide the other regions.