New Cracking SEBI General in 60 Days - Possible or Not?
Register

Question

What does the IF function do in Excel?

A Performs arithmetic calculations on a range of cells Correct Answer Incorrect Answer
B Tests a condition and returns one value if the condition is true and another value if the condition is false Correct Answer Incorrect Answer
C Finds the highest value in a range of cells Correct Answer Incorrect Answer
D Counts the number of cells in a range that meet specified criteria Correct Answer Incorrect Answer
E None of these Correct Answer Incorrect Answer

Solution

The IF function in Excel tests a condition and returns one value if the condition is true and another value if the condition is false.

Practice Next
×
×