FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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.