FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
We can determine which of the two choices uses certain conditions with the IF function. The correct form of writing is ____
A
=IF(logical test, ‘value ____ if ____ true’, ‘value ____ if ____ false’)
B
=IF(logical test‘`value ____ if ____ true” “value ____ if ____ false”)
C
=IF(logical test, “value ____ if ____ true”, “value ____ if ____ true”)
D
=IF(logical test, “value ____ if ____ false”, “value ____ if ____ false”)
E
=IF(logical test, “value ____ if ____ true”, “value ____ if ____ false”)
Explanation: 

Detailed explanation-1: -Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.

Detailed explanation-2: -Nested IF statement to check multiple logical tests If you want to evaluate multiple logical tests within a single formula, then you can nest several functions one into another. Such functions are called nested IF functions.

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: -IF is one of logical functions that evaluates a certain condition and returns one value if the condition is TRUE, and another value if the condition is FALSE.

There is 1 question to complete.
Previous
Next