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

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

Question 2 of 10 2/10

Is argument “logical1” required in =XOR?

Question 3 of 10 3/10

How many arguments does =XOR have in total?

Question 4 of 10 4/10

Which use case fits =XOR?

Question 5 of 10 5/10

How many required arguments does =XOR have?

Question 6 of 10 6/10

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

Question 7 of 10 7/10

Which statement about =XOR is correct?

Question 8 of 10 8/10

What usually causes #VALUE! in =XOR?

Question 9 of 10 9/10

Which is the correct syntax of =XOR?

Question 10 of 10 10/10

In =XOR, which is argument #1?

Click a question to see the answer.

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

A. Array
B. Reference
C. Logical ✓
D. Date

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

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

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

Explanation: “logical1” is required.

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

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

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

4. Which use case fits =XOR?

A. Forecasting & Trends
B. Comparation ✓
C. Workdays & Due Dates
D. Sort, Filter & Dedupe

Explanation: Use case “Comparation” fits XOR.

5. How many required arguments does =XOR have?

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

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

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

A. Output is always a dynamic array
B. Volatile and recalculates every time
C. Select entire column for best performance
D. Write the condition as a comparison ✓

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

7. Which statement about =XOR is correct?

A. 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.
B. The arguments must evaluate to logical values such as TRUE or FALSE, or in arrays or references that contain logical values. ✓
C. Text is always ignored
D. If an array or reference argument contains text or empty cells, those values are ignored.

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

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

A. If the specified range contains no logical values, XOR returns the #VALUE! error value. ✓
B. Requires add-in
C. Only works in old versions
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

9. 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],…)

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

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

Explanation: Argument #1 is “logical1”.