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: -Explanation: (a) allows you to define output results and then shows what input values are needed to generate that result. The word “goal-seeking” refers to the act of determining your input value based on a previously determined output value.
Detailed explanation-2: -A spreadsheet program like Microsoft Excel has a goal seeking tool built-in. It allows the user to determine the desired input value for a formula when the output value is already known.
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: -Unlike functions and formulas that take given values and return a result, what-if scenarios allow you to explore the results of multiple variables and Goal Seek lets you specify the result and then determines the values needed to generate it. You can learn about What-if Scenarios here.
Detailed explanation-5: -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.