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
    More MS Office Questions

    Relevant for Exams:

    Hey, Don't leave. If you have any queries regarding any exam let us know here.

    ask-question