Applying a Subnet Mask A subnet mask neither works as an IP address, nor does it exist independently of IP addresses. Instead, subnet masks accompany an IP address, and the two values work together.

I have an Excel spreadsheet containing IP addresses and subnet masks. I need to derive the subnet of each IP address in the spreadsheet.Example: IP (column A): 10.1.230.84, Subnet Mask (column B ...

What they expect you to know is how to convert a subnet mask to a subnet size, and then know that the first address is the network address and can't be given to a host and neither the last address ...