USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AND
|
|
|
OR
|
|
|
IF
|
|
|
SUM
|
Detailed explanation-1: -The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition.
Detailed explanation-2: -Syntax. 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.
Detailed explanation-3: -The AND function takes multiple arguments and returns a boolean value – TRUE if all conditions are met, and FALSE if some or none of the conditions are met. In the example above, our AND functions in Column C are testing whether or not the values in both Columns A and B equal “A”.
Detailed explanation-4: -The AND function in Excel checks if every argument you put in it evaluates to TRUE. If everything evaluates to TRUE, then the function will return TRUE, otherwise, even if only one argument is FALSE, the function will return the value FALSE. This is the sister function to the OR function.