USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which is used to perform what if analysis?
|
Solver
|
|
Goal seek
|
|
Scenario Manager
|
|
All of above
|
Explanation:
Detailed explanation-1: -Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.
Detailed explanation-2: -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-3: -Goal Seek: 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-4: -Alt A W is the Excel shortcut that helps to get to What-If analysis quickly.
There is 1 question to complete.