Which of following is Not one of Excel's what-if function?

Solution (By Examveda Team)

Which of the following is Not one of Excel's what-if functions?

Goal seek: This is a what-if analysis tool in Excel. It allows you to find the necessary input value to achieve a desired result in a specific cell. By adjusting one input value, Excel calculates the value needed to reach the goal.

Solver: This is another what-if analysis tool in Excel. Solver is more complex than Goal Seek as it can handle multiple variables and constraints. It helps in finding an optimal value for a formula in one cell, subject to constraints on the values of other formula cells.

Scenario manager: This is also a what-if analysis tool in Excel. It allows you to create and save different groups of values, or scenarios, and then switch between them to see how the different scenarios affect your results.

Auto Outline: This is not a what-if analysis tool. Auto Outline is used for organizing data in a worksheet by creating an outline of the data. It groups data into a hierarchical structure, making it easier to summarize and analyze.

Conclusion: The Auto Outline feature is not one of Excel's what-if functions, making Option D the correct answer.