Engineering =BITAND( number1, number2)

Quiz =BITAND — 15 Questions

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

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

← BITAND ▦ Practice in Playground

Progress — 15 questions 1 of 15

Question 1 of 15 1/15

Does =BITAND return a dynamic array?

Question 2 of 15 2/15

Which is the correct syntax of =BITAND?

Question 3 of 15 3/15

Which formula is a valid example of =BITAND?

Question 4 of 15 4/15

What usually causes #VALUE! in =BITAND?

Question 5 of 15 5/15

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

Question 6 of 15 6/15

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

Question 7 of 15 7/15

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

Question 8 of 15 8/15

How many arguments does =BITAND have in total?

Question 9 of 15 9/15

How many required arguments does =BITAND have?

Question 10 of 15 10/15

Is argument “number1” required in =BITAND?

Question 11 of 15 11/15

Since which Excel version is =BITAND available?

Question 12 of 15 12/15

Which statement about =BITAND is correct?

Question 13 of 15 13/15

In =BITAND, which is argument #1?

Question 14 of 15 14/15

Which category does =BITAND belong to?

Question 15 of 15 15/15

Is argument “number2” required in =BITAND?

Click a question to see the answer.

1. Does =BITAND return a dynamic array?

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

Explanation: BITAND does not spill.

2. Which is the correct syntax of =BITAND?

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

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

3. Which formula is a valid example of =BITAND?

A. =BITAND(1,5, 0)
B. =CONVERT(1,5)
C. BITAND(1,5)
D. =BITAND(1,5) ✓

Explanation: Correct example: =BITAND(1,5)

4. What usually causes #VALUE! in =BITAND?

A. Volatile and recalculates every time
B. If either argument is a non-numeric value, BITAND returns the #VALUE! error value. ✓
C. Requires add-in
D. Only works in old versions

Explanation: If either argument is a non-numeric value, BITAND returns the #VALUE! error value. — Fix: مطمئن شوید هر دو آرگومان عدد هستند و موارد متنی یا خانه‌های خالی را اصلاح کنید.

5. What is the fix for #VALUE! in =BITAND?

A. Only works in old versions
B. Output is always a dynamic array
C. مطمئن شوید هر دو آرگومان عدد هستند و موارد متنی یا خانه‌های خالی را اصلاح کنید. ✓
D. Text is always ignored

6. What is the type of argument “number1” in =BITAND?

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

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

7. What is the fix for #NUM! in =BITAND?

A. Select entire column for best performance
B. زمانی رخ می‌دهد که هر آرگومانی مقداری غیرعددی باشد.
C. Output is always a dynamic array
D. A number in the range 0 to 281474976710655 ✓

Explanation: If either argument is less than 0, BITAND returns the #NUM! error value. If either argument is a non-integer or is greater than (2^48)-1, BITAND returns the #NUM! error value. — Fix: A number in the range 0 to 281474976710655

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

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

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

9. How many required arguments does =BITAND have?

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

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

10. Is argument “number1” required in =BITAND?

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

Explanation: “number1” is required.

11. Since which Excel version is =BITAND available?

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

Explanation: Version: “Excel 2013”.

12. Which statement about =BITAND is correct?

A. The values returned from the bit positions progress from right to left as powers of 2. The rightmost bit returns 1 (2^0), the bit to its left returns 2 (2^1), and so on.
B. BITAND returns a decimal number. ✓
C. Output is always a dynamic array
D. The value of each bit position is counted only if both parameter's bits at that position are 1.

Explanation: Correct: BITAND returns a decimal number.

13. In =BITAND, which is argument #1?

A. number1 ✓
B. lookup_value
C. value
D. range

Explanation: Argument #1 is “number1”.

14. Which category does =BITAND belong to?

A. Database
B. Engineering ✓
C. Lookup & Reference
D. Date & Time

Explanation: Category is “Engineering”.

15. Is argument “number2” required in =BITAND?

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

Explanation: “number2” is required.