An analyst at Greendale Cycles builds a dashboard where clicking a bar in a regional sales chart should add the clicked customers to a set named 'Focus Cohort', and a second highlight worksheet should then react to that membership. The analyst configures a set action with the source sheet as the sales chart and the target set as 'Focus Cohort'. Which two statements about how this set action behaves are correct? Select TWO.
- AWhen 'Add to set' is chosen as the running-action behaviour, each new selection appends marks to the set rather than replacing the previous members. Correct
- BThe set action permanently rewrites the underlying data source rows so the membership survives even after the workbook is closed and reopened.
- CClearing the selection can reset the set to a defined value when the 'Clearing the selection will' option is set to keep, add to, or remove from the set. Correct
- DA set action is restricted to a fixed set whose members were typed in by hand, so a condition-based set cannot be a valid target.
- EBecause a set is binary, the target set must be split into two new sets before any set action will run against it on the dashboard.
Why A is correct: Set actions offer 'Add to set' so successive selections accumulate members, which is exactly how an additive Focus Cohort is built up across clicks.
Why B is wrong: This sounds plausible because set members persist in the view, but set actions only change in-session set membership and never alter source rows.
Why C is correct: The deselection setting controls what membership the set returns to on clearing, which is a genuine option in the set action dialog.
Why D is wrong: It is tempting because conditions feel separate, but a set action overwrites whatever members the target set holds regardless of how it was first defined.
Why E is wrong: Sets are indeed in-or-out, yet that binary nature is what a single set action drives directly, so no splitting into two sets is required.