📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!
  • google app store apple app store
    • ✖

      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
      ask-question