FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.
A
included
B
other
C
nested
D
duplicate
Explanation: 

Detailed explanation-1: -A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function. You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.

Detailed explanation-2: -Nested IF functions, meaning one IF function inside of another, allow you to test multiple criteria and increases the number of possible outcomes.

Detailed explanation-3: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")

Detailed explanation-4: -The If function tests one or more conditions until a true result is found. If such a result is found, a corresponding value is returned.

There is 1 question to complete.
Previous
Next