Excel Practice

XOR practice

Two-option rules often require exactly one condition to be true. XOR makes that distinction explicit; with more than two conditions it tests odd parity.

Lesson 80 of 81 · 3 exercises

Practise XOR

What you will practise

For two flags XOR is TRUE only when exactly one is true. With three or more inputs it is TRUE for an odd count of true values, not necessarily exactly one. Numeric zero is false; nonzero is true. Text and blank cells in references are ignored.

XOR(logical1, [logical2], …)

The syntax above is a guide. Read the data and each task to choose the right arguments for your formula.

3 exercises in this lesson

  1. Exercise 1 · answer in E10

    Check whether exactly one of the two delivery flags B2 and C2 is active.

  2. Exercise 2 · answer in E10

    Test odd parity across the three verification flags in B3:D3.

  3. Exercise 3 · answer in E10

    Return "Choose one" if exactly one of B4 and C4 is active, otherwise "Review options".

Before you check your answer

  • Keep the source data intact. Write your answer in the highlighted result cell. Changing a source value changes the question instead of solving it.
  • Use the requested cells. Check the first and last row of a range and read its column heading. A plausible total can still come from the wrong data.
  • Reference values that can change. A fixed number may match today's sheet. A cell reference keeps the formula connected when the source values change.

How the answer is checked

The workbook evaluates your formula against the requested result. It also checks the skill being practised and tests the formula with changed source data, so a fixed answer that happens to match is not enough.

Use progressive hints when you need help, then try the task again with fresh data. Correctly solving a step opens the next exercise.