Engineering =BITOR(number1, number2)

Quiz =BITOR — 15 Questions

15 quiz questions about =BITOR — test syntax, arguments, examples & errors!

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

← BITOR ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Which formula is a valid example of =BITOR?

Question 2 of 15 2/15

In =BITOR, which is argument #2?

Question 3 of 15 3/15

Is =BITOR volatile?

Question 4 of 15 4/15

What is the fix for #NUM! in =BITOR?

Question 5 of 15 5/15

Which use case fits =BITOR?

Question 6 of 15 6/15

What usually causes #NUM! in =BITOR?

Question 7 of 15 7/15

Since which Excel version is =BITOR available?

Question 8 of 15 8/15

How many arguments does =BITOR have in total?

Question 9 of 15 9/15

Which is the correct syntax of =BITOR?

Question 10 of 15 10/15

What usually causes #VALUE! in =BITOR?

Question 11 of 15 11/15

How many required arguments does =BITOR have?

Question 12 of 15 12/15

What is the type of argument “number1” in =BITOR?

Question 13 of 15 13/15

Which category does =BITOR belong to?

Question 14 of 15 14/15

Does =BITOR return a dynamic array?

Question 15 of 15 15/15

In =BITOR, which is argument #1?

Click a question to see the answer.

1. Which formula is a valid example of =BITOR?

A. =CONVERT(23,10)
B. BITOR(23,10)
C. =BITOR(23,10) ✓
D. =BITOR(23,10, 0)

Explanation: Correct example: =BITOR(23,10)

2. In =BITOR, which is argument #2?

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

Explanation: Argument #2 is “number2”.

3. Is =BITOR volatile?

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

Explanation: BITOR is not volatile.

4. What is the fix for #NUM! in =BITOR?

A. Select entire column for best performance
B. یکی از آرگومان‌ها غیرعددی است.
C. 0 to 2^48-1 ✓
D. Requires add-in

Explanation: If either argument is outside their constraints, BITOR returns the #NUM! error value. If either argument is greater than (2^48)-1, BITOR returns the #NUM! error value. — Fix: 0 to 2^48-1

5. Which use case fits =BITOR?

A. Conditional Aggregation
B. Daily Tasks
C. Scientific & Unit Conversion ✓
D. Rounding & Numeric

Explanation: Use case “Scientific & Unit Conversion” fits BITOR.

6. What usually causes #NUM! in =BITOR?

A. If either argument is outside their constraints, BITOR returns the #NUM! error value. If either argument is greater than (2^48)-1, BITOR returns the #NUM! error value. ✓
B. Text is always ignored
C. Output is always a dynamic array
D. یکی از آرگومان‌ها غیرعددی است.

7. Since which Excel version is =BITOR available?

A. Excel 2019
B. Excel 2013 ✓
C. All versions
D. Excel 365

Explanation: Version: “Excel 2013”.

8. How many arguments does =BITOR have in total?

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

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

9. Which is the correct syntax of =BITOR?

A. =CONVERT(number1, number2)
B. =BITOR(number1, number2) ✓
C. =BITOR(number1, number2, 0)
D. BITOR(number1, number2)

Explanation: Correct syntax: =BITOR(number1, number2)

10. What usually causes #VALUE! in =BITOR?

A. If either argument is a non-numeric value, BITOR returns the #VALUE! error value. ✓
B. Output is always a dynamic array
C. Requires add-in
D. Only works in old versions

Explanation: If either argument is a non-numeric value, BITOR returns the #VALUE! error value. — Fix: هر دو آرگومان را به‌صورت عددی وارد کنید.

11. How many required arguments does =BITOR have?

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

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

12. What is the type of argument “number1” in =BITOR?

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

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

13. Which category does =BITOR belong to?

A. Engineering ✓
B. Statistical
C. Logical
D. Information

Explanation: Category is “Engineering”.

14. Does =BITOR return a dynamic array?

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

Explanation: BITOR does not spill.

15. In =BITOR, which is argument #1?

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

Explanation: Argument #1 is “number1”.