What does the `XOR` function do in Excel?
A
Returns TRUE if all arguments are TRUE B
Returns TRUE if any argument is TRUE C
Returns TRUE if an odd number of arguments are TRUE D
Returns TRUE if an even number of arguments are TRUE
Analysis & Theory
`XOR` returns TRUE if an **odd number** of the supplied arguments evaluate to TRUE.
What is the correct syntax of the `XOR` function?
A
=XOR(logical1, [logical2], ...) B
=XOR(value1, value2) C
=XOR(range) D
=XOR()
Analysis & Theory
`XOR` takes one or more logical arguments and returns TRUE or FALSE.
What does `=XOR(TRUE, FALSE, TRUE)` return?
A
TRUE B
FALSE C
Error D
0
Analysis & Theory
There are 2 TRUE values (even number), so `XOR` returns FALSE.
What will `=XOR(FALSE, FALSE, TRUE)` return?
A
TRUE B
FALSE C
Error D
1
Analysis & Theory
There is 1 TRUE value (odd number), so `XOR` returns TRUE.
How many logical arguments can `XOR` accept?
A
Only 2 B
Up to 254 C
Unlimited D
Only 1
Analysis & Theory
`XOR` can accept up to 254 logical arguments.
Which Excel version introduced the `XOR` function?
A
Excel 2003 B
Excel 2010 C
Excel 2013 D
Excel 2016
Analysis & Theory
`XOR` was introduced in Excel 2016 and Office 365.
What will `=XOR(TRUE, TRUE, TRUE)` return?
A
TRUE B
FALSE C
Error D
0
Analysis & Theory
3 TRUE values (odd number) results in `XOR` returning TRUE.
What will `=XOR(FALSE, FALSE, FALSE)` return?
A
TRUE B
FALSE C
Error D
1
Analysis & Theory
0 TRUE values (even number) means `XOR` returns FALSE.
What is the logical equivalent of `XOR(A, B)`?
A
A AND B B
A OR B C
(A AND NOT B) OR (NOT A AND B) D
NOT A AND NOT B
Analysis & Theory
`XOR` is TRUE only when exactly one of A or B is TRUE.
Which of these is NOT a valid argument for `XOR`?
A
TRUE B
FALSE C
Numbers (treated as TRUE/FALSE) D
Text strings
Analysis & Theory
`XOR` treats numbers as TRUE/FALSE but text strings cause errors unless they evaluate logically.