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

Which function is related to =XOR?

Question 2 of 10 2/10

In =XOR, which is argument #1?

Question 3 of 10 3/10

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

Question 4 of 10 4/10

Which is the correct syntax of =XOR?

Question 5 of 10 5/10

Which use case fits =XOR?

Question 6 of 10 6/10

Since which Excel version is =XOR available?

Question 7 of 10 7/10

How many arguments does =XOR have in total?

Question 8 of 10 8/10

Is =XOR volatile?

Question 9 of 10 9/10

Which statement about =XOR is correct?

Question 10 of 10 10/10

Which function is NOT related to =XOR?

Click a question to see the answer.

1. Which function is related to =XOR?

A. STDEVPA
B. DOLLAR
C. IF ✓
D. SEC

Explanation: “IF” is related to XOR.

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

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

Explanation: Argument #1 is “logical1”.

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

A. Select entire column for best performance
B. Write the condition as a comparison ✓
C. Volatile and recalculates every time
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

4. Which is the correct syntax of =XOR?

A. XOR(logical1, [logical2],…)
B. =XOR(logical1, [logical2],…) ✓
C. =XOR(logical1, [logical2],…, 0)
D. =IF(logical1, [logical2],…)

Explanation: Correct syntax: =XOR(logical1, [logical2],…)

5. Which use case fits =XOR?

A. Reporting
B. Loans & Installments
C. Comparation ✓
D. Numbering & Sample Data

Explanation: Use case “Comparation” fits XOR.

6. Since which Excel version is =XOR available?

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

Explanation: Version: “Excel 2013”.

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

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

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

8. Is =XOR volatile?

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

Explanation: XOR is not volatile.

9. Which statement about =XOR is correct?

A. The arguments must evaluate to logical values such as TRUE or FALSE, or in arrays or references that contain logical values. ✓
B. The result of XOR is TRUE when the number of TRUE inputs is odd and FALSE when the number of TRUE inputs is even.
C. 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.
D. Volatile and recalculates every time

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

10. Which function is NOT related to =XOR?

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

Explanation: “XNPV” is not related to XOR.