USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The TRUE and FALSE functions 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. There is no need to use these functions in standard situations.
Detailed explanation-2: -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")
Detailed explanation-3: -Cell Reference: A cell reference is the name of the cell that is found by combining the Column Letter with the Row Number. For example the cell in Column “C” in Row “3” would be cell C3.
Detailed explanation-4: -If we type =TRUE() in a cell, we get the result as TRUE. One can also enter TRUE function directly into a cell. Even if we do not add the parentheses, it will return the Boolean value TRUE.