USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Find the how raises will affect employee salaries
|
|
Find the five top sales people in a company
|
|
Find the business profits for different levels of sales
|
|
Find the loan payments based for different interest rates
|
Detailed explanation-1: -Answer: Identifying the top five sales people is not a “what-if” analysis.
Detailed explanation-2: -Click the Summary button in the Scenario Manager. 2. Next, select cell D10 (total profit) for the result cell and click on OK. Conclusion: if you sell 70% for the highest price, you obtain a total profit of $4100, if you sell 80% for the highest price, you obtain a total profit of $4400, etc.
Detailed explanation-3: -Solution(By Examveda Team) Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.
Detailed explanation-4: -2. Which statement best describes the What-if Analysis Data Table tool? A. Allows you to define output results and then shows what input values are needed to generate that result.