USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
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: -AND(logical1, logical2, …) This function tests the logical value of each entry e.g. logical1. If they are all true, it will return the value TRUE. If any one of them is false, the function will return FALSE.
Detailed explanation-4: -Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.