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
