Start free

Interview quiz track

First 2 free Junior Excel

Excel – IF and Logical Functions

Practice Excel IF and logical function interview questions covering IF, AND, OR, nested IFs, and IFS. Answer questions and receive feedback on correctness and approach. Ideal for data analyst and operations interview prep. First 2 questions are free with full feedback.

  • Level Junior
  • Questions 12
  • IF
  • logical functions

Try any track free — first 2 questions include full AI feedback. Subscribe to finish the track and unlock everything. Type or speak your answer — the first 2 questions include scoring and detailed AI feedback.

Try first 2 questions free All tracks

Sample excel – if and logical functions interview questions

Preview 6 questions from this track in quiz order. In the full quiz you answer one at a time — type or speak — then get a score and feedback.

  1. How does the IF function work?

    What a strong answer includes

    Tests a condition and returns one of two values.

  2. Write an IF formula that returns “Pass” if score >= 70.

    What a strong answer includes

    Correct syntax.

  3. How do you test multiple conditions with AND?

    What a strong answer includes

    Uses AND inside IF.

  4. How do you use OR in a formula?

    What a strong answer includes

    Returns true if any condition is true.

  5. What is a nested IF?

    What a strong answer includes

    IF inside another IF.

  6. When should you use IFS instead of nested IFs?

    What a strong answer includes

    Cleaner for multiple conditions.