Numbers totaled

• When there are decimal numbers in the list they are aligned so that their decimal points should be matched.
• This process is done in sheets like Excel
• It is easy to calculate sum or other functions in that numbers as shown in image below.

Examples:

Read More

Formulas

• There are inbuilt formulae in Excel like sum, average, product, etc.,
• We can also write the formula in the Excel to a particular column as shown in the images below.

Examples:

Read More

Sum

• Sum is a function in Excel sheet.
• We can use sum function when we want to total the values in number of columns.
• Syntax: =sum(column startrow : column endrow). Ex:- =sum(B1:B20)
• Sum function is used in the Excel as shown in the images below.

Examples: 

Read More

Internet Modem

• Internet modems are the devices which are connected to computer to access internet.
• They are connected to the PC or laptop through USB.
• They use mobile broad band to connect the computer to the internet wireless.
• A mobile broadband modem, also known as a connect card or data card, is a type of modem that allows a laptop, a personal computer or a router to receive Internet access via a mobile broadband connection instead of using telephone or cable television lines. 
• A mobile Internet user can connect using a wireless modem to a wireless Internet Service Provider (ISP) to get Internet access.

Notes:

Read More

Ipconfig

• The ipconfig command is used to display detailed IP information for each network adapter utilizing TCP/IP.
• This command is also used to release and renew IP addresses on system configurations to receive them via DHCP server.

1.  IPCONFIG /all: Display full configuration information.
2. IPCONFIG /release [adapter]: Release the IP address for the specified adapter. 
3. IPCONFIG /renew [adapter]: Renew the IP address for the specified adapter. 
4. IPCONFIG /flushdns: Purge the DNS Resolver cache. 
5. IPCONFIG /registerdns:  Refresh all DHCP leases and re-register DNS names. 
6. IPCONFIG /displaydns: Display the contents of the DNS Resolver Cache. 
7. IPCONFIG /showclassidadapter: Display all the DHCP class IDs allowed for adapter. IPCONFIG /setclassid adapter [classid] Modify the dhcp class id.

Read More