Logic Puzzles: Test Every Candidate Row
This lesson is part of the course
In this lesson
You solve a knights-and-knaves puzzle the spreadsheet way: list all 8 possible worlds, evaluate each person's claim, keep the rows where everybody is consistent and read off the unique solution.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Propositions & Truth Tables: AND, OR, NOT, XOR Locked
- Implication & Biconditional: IF–THEN Logic in Excel Locked
- Tautologies & Equivalences: Proving De Morgan with a Truth Table Locked
- Sets as 0/1 Membership Columns: Union, Intersection & Difference Locked
- Venn Diagrams from Data: Counting the 8 Regions of Three Sets Locked
- Logic Puzzles: Test Every Candidate Row Locked
- Quantifiers on Data: "For All" and "There Exists" with COUNTIF Locked
- Logic in Business Rules: Testing a Decision Table for Conflicts & Gaps Locked