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

      Question

      In MS Excel, the 'IF' function is used

      to:
      A Look up a value in a table. Correct Answer Incorrect Answer
      B Perform a logical test and return one value if true and another if false. Correct Answer Incorrect Answer
      C Calculate the sum of a range of cells. Correct Answer Incorrect Answer
      D Find the average of a range of cells. Correct Answer Incorrect Answer

      Solution

      The IF function is a logical function that returns one value if a specified condition evaluates to TRUE, and another value if it evaluates to FALSE. Its syntax is =IF(logical_test, value_if_true, [value_if_false]). It is fundamental for conditional calculations.

      Practice Next
      More Accounts Questions
      ask-question