Logical =XOR(logical1, [logical2],…)

Quiz =XOR — 10 Questions

10 quiz questions about =XOR — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← XOR ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Does =XOR return a dynamic array?

Question 2 of 10 2/10

What is the output type of =XOR?

Question 3 of 10 3/10

Is =XOR volatile?

Question 4 of 10 4/10

Which formula is a valid example of =XOR?

Question 5 of 10 5/10

Is argument “logical1” required in =XOR?

Question 6 of 10 6/10

In =XOR, which is argument #1?

Question 7 of 10 7/10

Which function is related to =XOR?

Question 8 of 10 8/10

What usually causes #VALUE! in =XOR?

Question 9 of 10 9/10

Since which Excel version is =XOR available?

Question 10 of 10 10/10

How many arguments does =XOR have in total?

Click a question to see the answer.

1. Does =XOR return a dynamic array?

A. —
B. Yes
C. No
D. No ✓

Explanation: XOR does not spill.

2. What is the output type of =XOR?

A. Value
B. Mixed
C. Array
D. Logical ✓

Explanation: Output is “Logical”.

3. Is =XOR volatile?

A. Yes
B. —
C. No
D. No ✓

Explanation: XOR is not volatile.

4. Which formula is a valid example of =XOR?

A. XOR(3>0,2<9)
B. =XOR(3>0,2<9) ✓
C. =XOR(3>0,2<9, 0)
D. =IF(3>0,2<9)

Explanation: Correct example: =XOR(3>0,2<9)

5. Is argument “logical1” required in =XOR?

A. —
B. Yes
C. Yes ✓
D. No

Explanation: “logical1” is required.

6. In =XOR, which is argument #1?

A. lookup_value
B. logical1 ✓
C. range
D. value

Explanation: Argument #1 is “logical1”.

7. Which function is related to =XOR?

A. CHIDIST
B. IFERROR
C. SUMSQ
D. IF ✓

Explanation: “IF” is related to XOR.

8. What usually causes #VALUE! in =XOR?

A. Requires add-in
B. Select entire column for best performance
C. Volatile and recalculates every time
D. If the specified range contains no logical values, XOR returns the #VALUE! error value. ✓

Explanation: If the specified range contains no logical values, XOR returns the #VALUE! error value. — Fix: Write the condition as a comparison

9. Since which Excel version is =XOR available?

A. Excel 2007 (Compatibility)
B. Excel 2019
C. All versions
D. Excel 2013 ✓

Explanation: Version: “Excel 2013”.

10. How many arguments does =XOR have in total?

A. 1 ✓
B. 2
C. 3
D. 4

Explanation: =XOR has 1 required, 0 optional (1 total).