The BIN2DEC spreadsheet function
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. What does the spreadsheet function BIN2DEC do?
2. What value does =BIN2DEC(1101) give?
3. Which formula changes the binary number 111 into decimal?
4. You converted 1010 to decimal by hand. Which formula checks your answer?
5. =BIN2DEC(11001) shows 25, but your hand conversion gave 23. What should you do?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1=BIN2DEC(1101) | A=BIN2DEC("00000101") | |
| 2=BIN2DEC(111) | BChanges the binary number 1101 into decimal and shows 13 | |
| 3Check a hand conversion: you worked out that 10110 is 22, so ask the spreadsheet if it agrees | CThe number 1102 contains a 2, and binary only uses the digits 0 and 1, so the spreadsheet shows an error (#NUM!). | |
| 4Type binary with leading zeros as text by putting it in quotes, and still get its decimal value | DChanges the binary number 111 into decimal and shows 7 | |
| 5=BIN2DEC(1102) | EDEC2BIN goes the wrong way. It treats 1101 as a decimal number and turns it into binary, instead of turning binary 1101 into decimal. | |
| 6=DEC2BIN(1101) | F=BIN2DEC(10110)=22 |
C
Definitions
=BIN2DEC(1101)
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
=_______(1101)
2.
_BIN2DEC(1101)
3.
=BIN2DEC(1101)_13
4.
=_______("00001101")
5.
=IF(BIN2DEC(1010)=__,"OK","Wrong")
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
A1: 1101
B
B1: =BIN2DEC(A1)
C
C1: 13
D
D1: =IF(B1==C1,"OK","Check")
Question 2
A
=BIN2DEC(1121)
B
Result: 13
C
Check: 8+4+0+1 = 13
Question 3
A
A2: '00001010
B
B2: =BIN2DEC(A2)
C
Result in B2: 1010
Question 4
A
A1: 111
B
B1: =DEC2BIN(A1)
C
Result: 7
Question 5
A
BIN2DEC("10000")
B
Hand: 16+0+0+0+0 = 16
C
Result: 16
Answer Key
The BIN2DEC spreadsheet function
Section A: Quick Questions
Q1
B — Changes a binary number into a decimal number
Q2
A — 13
Q3
B — =BIN2DEC(111)
Q4
A — =BIN2DEC(1010)
Q5
A — Recheck your working, because the spreadsheet disagrees
Section B: Match the Pairs
Q1
=BIN2DEC(1101) → Changes the binary number 1101 into decimal and shows 13
Q2
=BIN2DEC(111) → Changes the binary number 111 into decimal and shows 7
Q3
Check a hand conversion: you worked out that 10110 is 22, so ask the spreadsheet if it agrees → =BIN2DEC(10110)=22
Q4
Type binary with leading zeros as text by putting it in quotes, and still get its decimal value → =BIN2DEC("00000101")
Q5
=BIN2DEC(1102) → The number 1102 contains a 2, and binary only uses the digits 0 and 1, so the spreadsheet shows an error (#NUM!).
Q6
=DEC2BIN(1101) → DEC2BIN goes the wrong way. It treats 1101 as a decimal number and turns it into binary, instead of turning binary 1101 into decimal.
Section C: Definitions
Q1
=BIN2DEC(1101) — BIN2DEC changes a binary number into its decimal value. =BIN2DEC(1101) gives 13. Use it to check a hand conversion.Section D: Fill in the Blanks
Q1
=BIN2DEC(1101)Q2
=BIN2DEC(1101)Q3
=BIN2DEC(1101)=13Q4
=BIN2DEC("00001101")Q5
=IF(BIN2DEC(1010)=10,"OK","Wrong")Section E: Spot the Error
Q1
D — Spreadsheets compare values with a single = sign, not ==. The check should be =IF(B1=C1,"OK","Check").
Q2
A — Binary numbers only contain the digits 0 and 1, so 1121 gives an error. It should be =BIN2DEC(1101), which gives 13.
Q3
C — BIN2DEC gives the decimal value and the leading zeros do not change it. 00001010 in binary is 8+2 = 10, so B2 shows 10.
Q4
B — DEC2BIN goes the other way, from decimal to binary. To convert binary 111 into decimal 7 you need =BIN2DEC(A1).
Q5
A — A spreadsheet formula must start with an equals sign. Without it the cell just shows text. It should be =BIN2DEC("10000").