Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ..... analysis or sensitivity analysis.

HOW TO INSERT HEADERS FOOTERS 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]

Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ____ analysis or sensitivity analysis.

A	what-if
B	who-could
C	NOW
D	possibility

Explanation:

Detailed explanation-1: -the NOW function is an example of a volatile function. using excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called what-if analysis or sensitivity analysis.

Detailed explanation-2: -What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.

Detailed explanation-3: -You must start each formula by typing the equal sign (=). When you change the value in a cell that is referenced in a formula, you must re-enter the formula to make sure it also changes. You can click a cell or select a range to enter its address in the formula. Formulas and functions are NOT case sensitive.

Detailed explanation-4: -Precedent cells-cells that are referred to by a formula in another cell. For example, if cell D10 contains the formula =B5, then cell B5 is a precedent to cell D10. Dependent cells-these cells contain formulas that refer to other cells.

There is 1 question to complete.

FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT HEADERS FOOTERS IN EXCEL