DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
IF
|
|
|
A1=10
|
|
|
GOOD
|
|
|
SIGNS
|
Detailed explanation-1: -The formula returns TRUE if a value in cell A1 is greater than a value in cell B1; otherwise it returns FALSE.
Detailed explanation-2: -Microsoft Excel provides 4 logical functions to work with the logical values. The functions are AND, OR, XOR and NOT. You use these functions when you want to carry out more than one comparison in your formula or test multiple conditions instead of just one.
Detailed explanation-3: -Logical functions are used in spreadsheets to test whether a situation is true or false. Depending on the result of that test, you can then elect to do one thing or another. These decisions can be used to display information, perform different calculations, or to perform further tests.
Detailed explanation-4: -A logical reasoning test is used measure a candidate’s problem solving ability. They assess the ability to come to conclusions based on logic. You are presented with a series of shapes and are required to find patterns and rules to help you find the correct answer.