Engineering › DEC2BIN, BIN2DEC136 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeDEC2BINBIN2DEC

DEC2BIN & BIN2DEC: an IP address in binary

Networking students at a vocational high school in Klaten are learning subnetting. Their teacher, Mr. Yusuf, asks them to write each octet of the IP address 192.168.10.25 as an 8-digit binary number, then turn a subnet mask written in binary back into decimal.

Task

Fill in:

B2:B5: the octet in column A as an 8-digit binary number with DEC2BIN (leading zeros included).
D2:D5: the binary subnet mask in column C as a decimal with BIN2DEC.

Cells to fillB2:B5D2:D5

Required functionsDEC2BINBIN2DEC

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
DEC2BIN(number, [places]) converts decimal to binary. The places argument sets the number of digits and pads with leading zeros.
Hint 2
An IP octet is always 8 bits, so places = 8. Without it, 10 becomes just 1010.
Hint 3
Pattern: =DEC2BIN(A2, …). For column D, BIN2DEC only needs one argument: the binary cell in column C.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

B2:B5

=DEC2BIN(A2,8)

Write it in B2, then fill down to B5.

D2:D5

=BIN2DEC(C2)

Write it in D2, then fill down to D5.

Explanation

=DEC2BIN(A2,8) turns 192 into 11000000 and 10 into 00001010. The result is text, so the leading zeros stay visible. =BIN2DEC(C2) turns 11111111 into 255, so the subnet mask is 255.255.255.192, or /26. DEC2BIN only accepts numbers up to 511; for larger numbers, use BASE(number, 2, digits).

Starting worksheet: Sheet1
Row	A	B	C	D
1	IP octet	Binary	Binary mask	Decimal mask
2	192		11111111
3	168		11111111
4	10		11111111
5	25		11000000
6
7
8
9
10
11
12
13
14

Fill in the requested cells, then press Check answer.

Validation result