DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Solver
|
|
|
Goal seek
|
|
|
Scenario Manager
|
|
|
All of above
|
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.
Detailed explanation-5: -Which of the following is not a ‘what-if analysis’tool? Explanation: Track change is correct answer.