Question

Q-4. What is the use of WHAT-IF-Analysis Tool? Write the name of the tools​

Answer 1

Answer:

What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Three kinds of What-If Analysis tools come with Excel: Scenarios, Goal Seek, and Data Tables. Scenarios and Data tables take sets of input values and determine possible results.