USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -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.
Detailed explanation-2: -The OR function in Excel either returns a TRUE or a FALSE. It returns FALSE only if all arguments evaluate to FALSE. The function returns TRUE even if a single argument evaluates to TRUE. This logical function will help you compare data and test multiple conditions.
Detailed explanation-3: -The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.
Detailed explanation-4: -The TRUE Function[1] is categorized under Excel Logical functions. It will return the logical value of TRUE. The function is equivalent to using the Boolean value TRUE directly in a formula. In financial analysis, the TRUE function is often used with other logical functions such as IF, ERROR, etc.