DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Goal Seek, Scenario Manager, and Data Table
|
|
|
Goal Seek, Projections, Data Table
|
|
|
Scenario Manager, Projections, Data Table
|
|
|
None of the above
|
Detailed explanation-1: -Scenario manager in Excel allows you to change or substitute input values for multiple cells (maximum up to 32). Therefore, you can view the results of different input values or different scenarios at the same time. For example: What if I cut down my monthly traveling expenses?
Detailed explanation-2: -By using What-If Analysis tools in Excel, you can use several different sets of values in one or more formulas to explore all the various results. For example, you can do What-If Analysis to build two budgets that each assumes a certain level of revenue.
Detailed explanation-3: -From the Data tab, click the What-If Analysis command, then select Goal Seek from the drop-down menu. A dialog box will appear with three fields. The first field, Set cell:, will contain the desired result. In our example, cell B5 is already selected.