FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB 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]

In a What-If Analysis Data Table, the reference to the formula being used in the analysis is displayed as number. What format option can be used display this number as an actual text label?

A	Custom
B	General
C	Accounting
D	Text

Explanation:

Detailed explanation-1: -=IF(logical test, value if true, value if false) The function uses the following arguments: Logical test (required argument) – This is the condition to be tested and evaluated as either TRUE or FALSE.

Detailed explanation-2: -2. Which statement best describes the What-if Analysis Data Table tool? A. Allows you to define output results and then shows what input values are needed to generate that result.

Detailed explanation-3: -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. For example, you can use a data table to vary the interest rate and term length for a loan-to evaluate potential monthly payment amounts.

Detailed explanation-4: -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.

There is 1 question to complete.