DATABASE FUNDAMENTALS
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: -An example of what-if analysis would be to ask: what would happen to my revenue if I charged more for each loaf of bread? In the simple case, where the volume of bread sold doesn’t depend on the price of the bread, the analysis is very easy. An X% rise in the price per loaf will lead to an X% increase in sales.
Detailed explanation-3: -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. A Data Table works with only one or two variables, but it can accept many different values for those variables.
Detailed explanation-4: -Solution(By Examveda Team) Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.