DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
comparison operators
|
|
|
mathematical operators
|
|
|
logical symbols
|
|
|
None of the above
|
Detailed explanation-1: -Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.
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: -In Excel, we can perform a logical test for any situation. The most commonly used logical test is using the equals to the operator, which is “=” if we use =A1=B1 in cell A2, then it will return TRUE if the values are equal and FALSE if the values are not equal.
Detailed explanation-4: -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.