Engineering =BITLSHIFT(number, shift_amount)

Quiz =BITLSHIFT — 10 Questions

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

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

← BITLSHIFT ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

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

Question 2 of 10 2/10

How many arguments does =BITLSHIFT have in total?

Question 3 of 10 3/10

Which statement about =BITLSHIFT is correct?

Question 4 of 10 4/10

Which category does =BITLSHIFT belong to?

Question 5 of 10 5/10

In =BITLSHIFT, which is argument #1?

Question 6 of 10 6/10

Which function is related to =BITLSHIFT?

Question 7 of 10 7/10

What is the type of argument “shift_amount” in =BITLSHIFT?

Question 8 of 10 8/10

Which function is NOT related to =BITLSHIFT?

Question 9 of 10 9/10

What usually causes #VALUE! in =BITLSHIFT?

Question 10 of 10 10/10

What is the type of argument “number” in =BITLSHIFT?

Click a question to see the answer.

1. What is the fix for #NUM! in =BITLSHIFT?

A. Select entire column for best performance
B. یکی از آرگومان‌ها غیرعددی است.
C. Enter a non-negative value ✓
D. Requires add-in

Explanation: If either argument is outside their constraints, BITLSHIFT returns the #NUM! error value. If Number is greater than (2^48)-1, BITLSHIFT returns the #NUM! error value. If the absolute value of Shift_amount is greater than 53, BITLSHIFT returns the #NUM! error value. — Fix: Enter a non-negative value

2. How many arguments does =BITLSHIFT have in total?

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

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

3. Which statement about =BITLSHIFT is correct?

A. Shifting a number left is equivalent to adding zeros (0) to the right of the binary representation of the number. For example, a 2-bit shift to the left on the decimal value 4 converts its binary value (100) to 10000, or 16 in decimal. ✓
B. Text is always ignored
C. Volatile and recalculates every time
D. Select entire column for best performance

Explanation: Correct: Shifting a number left is equivalent to adding zeros (0) to the right of the binary representation of the number. For example, a 2-bit shift to the left on the decimal value 4 converts its binary value (100) to 10000, or 16 in decimal.

4. Which category does =BITLSHIFT belong to?

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

Explanation: Category is “Engineering”.

5. In =BITLSHIFT, which is argument #1?

A. number ✓
B. shift_amount
C. range
D. lookup_value

Explanation: Argument #1 is “number”.

6. Which function is related to =BITLSHIFT?

A. IMSUM
B. BETA.INV
C. EUROCONVERT
D. CONVERT ✓

Explanation: “CONVERT” is related to BITLSHIFT.

7. What is the type of argument “shift_amount” in =BITLSHIFT?

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

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

8. Which function is NOT related to =BITLSHIFT?

A. —
B. SECH ✓
C. BITLSHIFT_X
D. CONVERT

Explanation: “SECH” is not related to BITLSHIFT.

9. What usually causes #VALUE! in =BITLSHIFT?

A. If either argument is a non-numeric value, BITLSHIFT returns the #VALUE! error value. ✓
B. آرگومانی خارج از محدوده است، Number بزرگ‌تر از ‎(۲^۴۸)-۱ است یا قدرمطلق Shift_amount بزرگ‌تر از ‎۵۳ است.
C. Output is always a dynamic array
D. Requires add-in

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

10. What is the type of argument “number” in =BITLSHIFT?

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

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