FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The logical function used to make selections based on certain conditions is ____
A
OR
B
IF
C
AND
D
ELSE
E
NAND
Explanation: 

Detailed explanation-1: -The syntax for an IF statement is. =IF (Logical Test, [Value if True], [Value if False]). Basic IF statements, IF statements with conditional AND’s or OR’s, and Nested IF statements are all based around this same syntax.

Detailed explanation-2: -Use the AND function, one of the logical functions, to determine if all conditions in a test are TRUE.

Detailed explanation-3: -The IF function has three arguments: Logical test – Here, we can test to see if the value in a selected cell is what we expect. You could use something like “B7=14” or “B7>12” or “B7<6” Value if true – If the requirements in the logical test are met – if B7 is equal to 14 – then it is said to be true.

Detailed explanation-4: -=IF(logical test, value if true, value if false) The function uses the following arguments: Logical test (required argument) – This is the condition to be tested and evaluated as either TRUE or FALSE. Value if true (optional argument) – The value that will be returned if the logical test evaluates to TRUE.

There is 1 question to complete.