USING MICROSOFT EXCEL
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: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.
Detailed explanation-4: -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.