USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Logical
|
|
|
Alphabetical
|
|
|
Numerical
|
|
|
Currency
|
Detailed explanation-1: -As well as AND, the Excel OR function is a basic logical function that is used to compare two values or statements. The difference is that the OR function returns TRUE if at least one if the arguments evaluates to TRUE, and returns FALSE if all arguments are FALSE.
Detailed explanation-2: -Use the OR function, one of the logical functions, to determine if any conditions in a test are TRUE.
Detailed explanation-3: -What is the NOT Function? The NOT Function[1] is an Excel Logical function. The function helps check if one value is not equal to another. If we give TRUE, it will return FALSE and when given FALSE, it will return TRUE.
Detailed explanation-4: -A logical test can be a comparison between two cell references such as A2>B1. Or A logical test can be a comparison between a cell reference and a fixed amount such as C7>= 100. A comparative operator will always return a True or False result. Excel recognized True and False Statements as 1 and 0.