FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

James wants his spreadsheet to return a specific value when his logical test is true and another value when his logical test is false. What function should he use?

A	IF
B	AND
C	OR
D	NOT

Explanation:

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.

Detailed explanation-2: -Value If True: The value that is returned if Logical test is TRUE. If omitted, TRUE is returned. Value If False: The value that is returned if Logical test is FALSE. If omitted, FALSE is returned.

Detailed explanation-3: -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.

Detailed explanation-4: -Logical functions are used in spreadsheets to test whether a situation is true or false. Depending on the result of that test, you can then elect to do one thing or another. These decisions can be used to display information, perform different calculations, or to perform further tests.

There is 1 question to complete.