Explanation

• The main purpose of DNS (Domain Name System) is to translate domain names into IP addresses.
• It works like an internet phonebook.
• It helps users access websites using easy names instead of numeric IPs.
• Example: google.com → 142.250.190.14

Last verified on 09-06-2026

Explanation

• DHCP automatically assigns IP addresses to devices.
• It also provides subnet mask, gateway, and DNS information.
• DHCP stands for Dynamic Host Configuration Protocol.

Last verified on 15-01-2026

Explanation

• The MAX function returns the largest value in a set of numbers in Excel.
• It compares all selected values and displays the highest one.
• It is commonly used for finding the maximum score, salary, or price.

Additional information:

• MIN() → Returns the smallest value
• AVERAGE() → Returns the average value
• COUNT() → Counts cells containing numbers
• SUM() → Adds all numbers

Last verified on 18-07-2026

Explanation

• The dollar sign ($) is used to create an absolute cell reference in MS Excel.

Additional information:

• Absolute Reference: $D$2 (Row and column fixed)
• Relative Reference: D2 (Row and column change)
• Mixed Reference: $D2 (Column fixed)
• Mixed Reference: D$2 (Row fixed)
• Shortcut Key: F4 toggles between reference types.

Last verified on 18-07-2026

Explanation

• IPv4 (Internet Protocol version 4) uses a 32-bit address system.
• It allows about 4.3 billion unique IP addresses.
• It is written in dotted decimal format (e.g., 192.168.1.1).

Additional information:

• IPv6 length → 128 bits

Last verified on 26-05-2026