FUNDAMENTALS OF COMPUTER

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?
A
Solver
B
Goal seek
C
Scenario Manager
D
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.