STATISTICS & DECISION RULES · ORIGINAL EXERCISE

Choose one route

Return TRUE when exactly one of the Delivery and Pickup flags in D2 and E2 is TRUE. Otherwise return FALSE.

This quest practices XOR using a fictional business dataset. Read the sheet below, then enter the interactive quest to write and check your formula.

Learner	Score	Tier	Delivery	Pickup
Ari	84	Gold	true	false
Bea	71	Silver	false	false
Cam	92	Gold	false	true
Dev	84	Gold	true	true
Em	63	Bronze	true	false
Fox	77	Silver	false	true
Gia	88	Gold	false	false
Hal	84	Gold	true	false

Play this quest · +70 XP →

Hints to get you started

OR accepts one or both true flags.
XOR tests odd parity; for two flags that means exactly one.
Pass D2 and E2 to XOR.

Show the worked solution

=XOR(D2,E2)

For two logical values, XOR rejects both true and both false. With more than two arguments, XOR means an odd number of true values.

Make the skill stick

After solving the task, explain what each reference does and why the formula answers the business question. Try the workbook download inside the quest to practice in your own spreadsheet app.

Explore the rest of this region →