DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
included
|
|
|
other
|
|
|
nested
|
|
|
duplicate
|
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: -We nest an IF function by setting value if false to IF B2 greater than or equal to 80, return B. We use additional nested IF functions to test for C, D, and F grades. I am copying the formula. In this formula, we must test B2 greater than or equal to 90 first, and then, B2 greater than or equal to 80, and so on.
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.
Detailed explanation-5: -Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.