Question

difference between scenario manager and data table in excel

Answer 1

Answer:

Scenarios and Data tables take sets of input values and determine possible results. A Data Table works with only one or two variables, but it can accept many different values for those variables. A Scenario can have multiple variables, but it can only accommodate up to 32 values.

Answer 2

Explanation:

Data Table is for 1 or 2 inputs changing, resulting changes in output. Scenario Manager is to compare multiple business scenarios based on multiple inputs changing