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

Quiz =XOR — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Does =XOR return a dynamic array?

Question 2 of 15 2/15

Since which Excel version is =XOR available?

Question 3 of 15 3/15

Which statement about =XOR is correct?

Question 4 of 15 4/15

What is the output type of =XOR?

Question 5 of 15 5/15

How many arguments does =XOR have in total?

Question 6 of 15 6/15

Is =XOR volatile?

Question 7 of 15 7/15

In =XOR, which is argument #1?

Question 8 of 15 8/15

Which function is NOT related to =XOR?

Question 9 of 15 9/15

How many optional arguments does =XOR have?

Question 10 of 15 10/15

Which category does =XOR belong to?

Question 11 of 15 11/15

What is the type of argument “logical1” in =XOR?

Question 12 of 15 12/15

How many required arguments does =XOR have?

Question 13 of 15 13/15

What usually causes #VALUE! in =XOR?

Question 14 of 15 14/15

Which formula is a valid example of =XOR?

Question 15 of 15 15/15

What is the fix for #VALUE! in =XOR?

Click a question to see the answer.

1. Does =XOR return a dynamic array?

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

Explanation: XOR does not spill.

2. Since which Excel version is =XOR available?

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

Explanation: Version: “Excel 2013”.

3. Which statement about =XOR is correct?

A. Only works in old versions
B. You can use an XOR array formula to see if a value occurs in an array. Note If you have a current version of Microsoft 365, then you can simply enter the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, entering the formula in the top-left-cell of the output range, and then pressing CTRL+SHIFT+ENTER to confirm it. Excel inserts curly brackets at the beginning and end of the formula for you. For more information on array formulas, see Guidelines and examples of array formulas.
C. The arguments must evaluate to logical values such as TRUE or FALSE, or in arrays or references that contain logical values. ✓
D. Requires add-in

Explanation: Correct: The arguments must evaluate to logical values such as TRUE or FALSE, or in arrays or references that contain logical values.

4. What is the output type of =XOR?

A. Logical ✓
B. Text
C. Number
D. Mixed

Explanation: Output is “Logical”.

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

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

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

6. Is =XOR volatile?

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

Explanation: XOR is not volatile.

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

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

Explanation: Argument #1 is “logical1”.

8. Which function is NOT related to =XOR?

A. IF
B. OR
C. DEVSQ ✓
D. AND

Explanation: “DEVSQ” is not related to XOR.

9. How many optional arguments does =XOR have?

A. —
B. 0 ✓
C. 1
D. 2

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

10. Which category does =XOR belong to?

A. Date & Time
B. Logical ✓
C. Engineering
D. Information

Explanation: Category is “Logical”.

11. What is the type of argument “logical1” in =XOR?

A. Logical ✓
B. Number
C. Value
D. Text

Explanation: Type of “logical1” is “Logical”.

12. How many required arguments does =XOR have?

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

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

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

A. Select entire column for best performance
B. Requires add-in
C. If the specified range contains no logical values, XOR returns the #VALUE! error value. ✓
D. Output is always a dynamic array

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

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

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

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

15. What is the fix for #VALUE! in =XOR?

A. Requires add-in
B. Write the condition as a comparison ✓
C. Output is always a dynamic array
D. Select entire column for best performance

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