Question

which what-if analysis tool is the best option for complex calculations requiring constrained optimization?

Answer 1

The what-if analysis tool would be the most adequate choice for intricate calculations that need contrived optimization:

b). Scenario manager

• 'What-if analysis tool' is described as the tools that are employed to alter the values present in the cells.
• It is done to observe the effect of changing the values impact the results produced by the used formula.
• The what-if analysis tools have been categorized into three distinct types:
• a). Scenarios.
• b). Goal Seek.
• c). Data Tables.
• As per the question, in order to opt for complex calculations, 'Scenarios' what-if analysis would be most adequate as they examine a number of variables and set of numbers/values that affect the outcome.

Thus, option b is the correct answer.

Learn more about 'what-if tool' here:

brainly.com/question/14830872