DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Allows you to define output results and then shows what input values are needed to generate that result.
|
|
|
Allows you to investigate how changes to one or two input variables in a formula changes output results.
|
|
|
Allows you to define input variables in various situations. The output result for each situation is show in a summary table.
|
|
|
None of the above
|
Detailed explanation-1: -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.
Detailed explanation-2: -Goal Seek works differently from Scenarios and Data Tables in that it takes a result and determines possible input values that produce that result.
Detailed explanation-3: -Goal Seek is a What-If Analysis tool that helps you to find the input value that results in a target value that you want. Goal Seek requires a formula that uses the input value to give result in the target value.
Detailed explanation-4: -1) Solver can solve formulas (or equations) which use several variables whereas Goal Seek can only be used with a single variable. 2) Solver will allow you to vary the values in up to 200 cells whereas Goal Seek only allows you to vary the value in one cell.