DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which group on the ribbon contains Goal Seek and Scenario Manager?
|
|
Forecast
|
|
|
Data Tools
|
|
|
Queries & Connections
|
|
|
Get & Transform Data
|
Explanation:
Detailed explanation-1: -Use Scenario Manager Click the Data tab on the ribbon. Click the What-If Analysis button. Select Scenario Manager.
Detailed explanation-2: -Use Goal Seek Click the Data tab on the ribbon. Click the What-If Analysis button. Select Goal Seek.
Detailed explanation-3: -On the Data tab, in the Data Tools group, click What-If Analysis, and then click Goal Seek.
Detailed explanation-4: -What is Goal Seek in Excel? Goal Seek is Excel’s built-in What-If Analysis tool that shows how one value in a formula impacts another. More precisely, it determines what value you should enter in an input cell to get the desired result in a formula cell.
There is 1 question to complete.