what is "what-if'' analysis tool in Excel? Explain its Types.
.
.
Please explain as simple words as possible. You can also use Hinglish.
Please don't spam!
Answers
LMAO...
4 March ko me IT ka paper dekr aai hu...
you are lucky ki mujhe answer yaad h...
here we go...
THE 'WHAT-IF ANALYSIS' TOOL OF EXCEL ALLOW YOU TO USE DIFFERENT SETS OF VALUES IN ONE OR MORE FORMULAS TO EXPLORE ALL THE VARIOUS RESULTS. BY USING THESE TOOLS, YOU CAN TO WHAT-IF ANALYSIS TO ANALYSE COMPLEX DATA ON TWO DIFFERENT SETS OF DATA OF THE SAME SUBJECT FULL STOP YOU CAN SPECIFY A RESULT THAT YOU WANT TO A FORMULA TO PRODUCE, AND THEN DETERMINE WHAT SETS OF VALUE WILL PRODUCE THAT RESULT.
IN GENERAL THE WHAT IF ANALYSIS IS A PROCESS OF CHANGING THE VALUE IN THE CELLS TO SEE HOW THOSE CHANGES WILL AFFECT THE OUTCOME OF THE FORMULAS ON THE WORKSHEET.
THREE KINDS OF WHAT IF ANALYSIS TOOLS COMES WITH EXCESS : SCENARIO MANAGER, GOAL SEEK AND DATA TABLE.
TYPES-
- SCENARIO MANAGER IS AN IMPORTANT TOOL OF EXCEL, WHICH YOU USE TO TEST THE WHAT IF QUESTIONS. IT ENABLES USED TO MANAGE AND VIEW DATA FROM DIFFERENT INPUT VALUES. FOR EXAMPLE IF YOU WANT TO CALCULATE THE EFFECT OF DIFFERENT INTEREST RATES ON AN INVESTMENT, YOU COULD AND A SCENARIO FOR EACH INTEREST RATE AND QUICKLY VIEW THE RESULTS.
- GOAL SEEK IS ANOTHER USEFUL DATA ANALYSIS TOOL OF EXCEL. IT USED TO SET A GOAL TO FIND THE OPTIMUM VALUE FOR ONE OR MORE TARGET VARIABLE, GIVEN WITH CERTAIN CONDITIONS. IT ALLOWS YOU TO TRY DIFFERENT VALUES IN THE FORMULA TO ARRIVE AT A SOLUTION FOR INPUT VALUE.
- DATA TABLE IS A WAY TO SEE DIFFERENT RESULTS BY ALL TREATING AND INPUT CELL IN YOUR FORMULA. INSTEAD OF CREATING DIFFERENT SCENARIOS, YOU CAN CREATE A DATA TABLE TO QUICKLY TRY OUT THE DIFFERENT VALUES FOR THE FORMULAS. YOU CAN CREATE ONE OR TWO VARIABLE DATA TABLE.
Hey dude! hope it helps you.. please mark as brainlist...
Answer:
three kinds of what -if analysis tools come with excel : scenario manager,goal seek and data tabel