Have Questions? 

Ip Addressing And Subnetting Workbook Version 2.0 Student Answers -

: Perform bitwise AND with mask to find network ID; add inverse mask to find broadcast. Part 6 – Supernetting / Route Summarization Question : Summarize these Class C networks into a single route: 192.168.4.0/24, 192.168.5.0/24, 192.168.6.0/24, 192.168.7.0/24

| | CIDR | Subnet Mask | Network ID | Hosts usable | |-------------|----------|----------------|----------------|------------------| | LAN A | /25 | 255.255.255.128 | 192.168.10.0 | 126 | | LAN B | /26 | 255.255.255.192 | 192.168.10.128 | 62 | | LAN C | /27 | 255.255.255.224 | 192.168.10.192 | 30 | | WAN link | /30 | 255.255.255.252 | 192.168.10.224 | 2 | : Perform bitwise AND with mask to find

Alex later passes the CCNA – thanks to the methodical practice of subnetting by hand. Part 1 – Address Classification & Default Masks

Below is Alex’s with explanations written in the margins. Part 1 – Address Classification & Default Masks | IP Address | Class | Default Subnet Mask | Network ID | Host ID | |-----------------------|-----------|-------------------------|----------------|--------------| | 10.250.1.15 | A | 255.0.0.0 | 10.0.0.0 | 250.1.15 | | 172.31.200.99 | B | 255.255.0.0 | 172.31.0.0 | 200.99 | | 192.168.5.10 | C | 255.255.255.0 | 192.168.5.0 | 10 | | 203.0.113.88 | C | 255.255.255.0 | 203.0.113.0 | 88 | | 8.8.8.8 | A | 255.0.0.0 | 8.0.0.0 | 8.8.8 | | | Hosts needed | CIDR | Subnet

: Class A (1–126), B (128–191), C (192–223). D/E ignored here. Part 2 – Subnetting a Class C Address (192.168.1.0/24) Problem : Create 4 subnets with at least 25 hosts each.

| | Hosts needed | CIDR | Subnet mask | Network ID | |----------------|--------------|------|-------------------|-----------------| | Headquarters | 2000 | /20 | 255.255.240.0 | 10.0.0.0/20 | | Branch1 | 500 | /22 | 255.255.252.0 | 10.0.16.0/22 | | Branch2 | 200 | /24 | 255.255.255.0 | 10.0.20.0/24 | | WAN1 | 2 | /30 | 255.255.255.252 | 10.0.21.0/30 | | WAN2 | 2 | /30 | 255.255.255.252 | 10.0.21.4/30 |

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2026 ExcelVbaIsFun
locklaptop-phonerocketlistchevron-down
X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram
0