FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which function returns a value if all conditions are met?
A
AND
B
OR
C
IF
D
IFERROR
Explanation: 

Detailed explanation-1: -The IFERROR function is similar to the IF function, which checks for a condition and returns a value if the condition is met. The IFERROR function is also similar to the VLOOKUP function, which checks for an error and returns a value if there is an error.

Detailed explanation-2: -IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula.

Detailed explanation-3: -The Excel IFERROR function returns a custom result when a formula generates an error, and a standard result when no error is detected. IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.

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

There is 1 question to complete.