Engineering =BITXOR(number1, number2)

Quiz =BITXOR — 10 Questions

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

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

← BITXOR ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

What is the type of argument “number2” in =BITXOR?

Question 2 of 10 2/10

Which function is related to =BITXOR?

Question 3 of 10 3/10

Which statement about =BITXOR is correct?

Question 4 of 10 4/10

What is the output type of =BITXOR?

Question 5 of 10 5/10

Is =BITXOR volatile?

Question 6 of 10 6/10

Which function is NOT related to =BITXOR?

Question 7 of 10 7/10

Which formula is a valid example of =BITXOR?

Question 8 of 10 8/10

In =BITXOR, which is argument #1?

Question 9 of 10 9/10

How many optional arguments does =BITXOR have?

Question 10 of 10 10/10

Since which Excel version is =BITXOR available?

Click a question to see the answer.

1. What is the type of argument “number2” in =BITXOR?

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

Explanation: Type of “number2” is “Number”.

2. Which function is related to =BITXOR?

A. CONVERT ✓
B. IMSECH
C. PRODUCT
D. TAN

Explanation: “CONVERT” is related to BITXOR.

3. Which statement about =BITXOR is correct?

A. Volatile and recalculates every time
B. Using the same example, 0 is returned for the rightmost bit position because it is a 0, 2 (2^1) is returned for the second bit position from the right (a 1 value), and 4 (2^2) is returned for the leftmost bit (also a 1 value). The total is 6, in decimal representation.
C. BITXOR returns a decimal number that is the result of the sum of a bitwise 'XOR' (exclusive XOR) of its parameters. ✓
D. Select entire column for best performance

Explanation: Correct: BITXOR returns a decimal number that is the result of the sum of a bitwise 'XOR' (exclusive XOR) of its parameters.

4. What is the output type of =BITXOR?

A. Value
B. Number/Text ✓
C. Array
D. Reference

Explanation: Output is “Number/Text”.

5. Is =BITXOR volatile?

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

Explanation: BITXOR is not volatile.

6. Which function is NOT related to =BITXOR?

A. CONVERT
B. BITXOR_X
C. UNICODE ✓
D. —

Explanation: “UNICODE” is not related to BITXOR.

7. Which formula is a valid example of =BITXOR?

A. BITXOR(5,3)
B. =BITXOR(5,3) ✓
C. =BITXOR(5,3, 0)
D. =CONVERT(5,3)

Explanation: Correct example: =BITXOR(5,3)

8. In =BITXOR, which is argument #1?

A. number1 ✓
B. number2
C. range
D. criteria

Explanation: Argument #1 is “number1”.

9. How many optional arguments does =BITXOR have?

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

Explanation: =BITXOR has 2 required, 0 optional (2 total).

10. Since which Excel version is =BITXOR available?

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

Explanation: Version: “Excel 2013”.