USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
VLOOKUP
|
|
|
AND
|
|
|
OR
|
|
|
NOT
|
Detailed explanation-1: -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. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")
Detailed explanation-2: -How do you check what a function does or what the argument is asking for? Dialog box shows a description of the function. The NOT function returns True when given two arguments that evaluate to True. Goal Seek will return the optimal value to set the selected cell to the desired value.
Detailed explanation-3: -Technical Details. The AND function returns TRUE if all its arguments evaluate to TRUE, and returns FALSE if one or more arguments evaluate to FALSE. One common use for the AND function is to expand the usefulness of other functions that perform logical tests.