DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
PMT
|
|
|
False
|
|
|
True
|
|
|
Mode
|
Detailed explanation-1: -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. It is related to the FALSE function.
Detailed explanation-2: -There are TRUE and FALSE functions in Excel as well. For instance, if you type “=TRUE()” into a cell, it will return the value TRUE. If you type “=FALSE()” it will return FALSE.
Detailed explanation-3: -Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.
Detailed explanation-4: –The IF function returns the logical value TRUE if the condition is met, and FALSE if the condition is not met.-The VLOOKUP function returns the logical value TRUE if the lookup value is found in the table array, and FALSE if the lookup value is not found in the table array.