Question

_________in Excel allows us to try out different scenarios. (a) Data validation (b) Pivot Table (c) Chart (d) What if analysis

Answer 1

(a)  Pivot Table in Excel allows us to try out different scenarios.

You can click on the pivot table or filter table data of the slicers for quick filtering.

It is an easy short-cut which will allow you to filter the table and when you select an item which is already included in the filter, then the data for that item will be displayed in the report automatically.