Tag: tips

Shortcut function keys in excel

Here is a list of shortcut keys in Microsoft Excel.

  1. F1: Opens a help task pane
  2. F1 + Ctrl: Opens or closes the help window
  3. F2: To edit the text in the active cell
  4. F2 + Shift: To write a comment in the active cell
  5. F2 + Alt: Opens the save as dialog box
  6. F3 + Shift: opens the insert dialog box
  7. F3 + Ctrl: Opens the define name dialog box
  8. F3 + Shift + Ctrl:  Opens the create name dialog box
  9. F4:  To redo the last command
  10. F4 + Ctrl: To close the workbook window
  11. F4 + Alt: To close the excel program
  12. F5: Opens the Goto dialog box
  13. F5 + Ctrl: brings back to the first level of workbook
  14. F6: To shift between help taskbar and the excel window
  15. F6 + Shift: To goto the previous square in the open worksheet
  16. F6 + Ctrl: If more than one workbook is open to switch between them
  17. F7: To open spelling correction window
  18. F7 + Ctrl: When workbook window is not maximised it will move the window
  19. F8: To activate / deactivate extended mode
  20. F9: Will calculate all the worksheets in all open workbooks
  21. F9 + Shift: Will calculate the active worksheet
  22. F9 + Ctrl: To Minimise the workbook window
  23. F10: Will select the menu bar
  24. F10 + Ctrl: To open minimised window
  25. F11: Will create a chart using the current range
  26. F11 + Shift: To select a new worksheet
  27. F11 + Alt: To switch between visual basic editor and the worksheet
  28. F11 + Alt + Shift: Opens microsoft script editor
  29. F12: Opens save as dialog box
  30. F12 + Shift: Saves the active workbook
  31. F12 + Ctrl: To open the Open dialog box
  32. F12 + Ctrl + Shift: Opens the print dialog box

Which Internet Connection plan to choose?

Internet has become part and parcel of our lives. Not only for individuals but even for a country’s economic growth, scientific growth, organizations’ success, Internet is very essential. The companies that offer these internet connections are called ISPs (Internet Service Providers). These ISPs offer many different internet connection plans. How to select the best connection plan for home use or for offices? The following tips will give you an overview of different types of internet connections, their advantages and disadvantages.

PSTN Dialup

Public Switched Telephone Network (PSTN) dialup uses your phone connection to connect your computer to the internet. You need a modem, phone line and a computer for a PSTN dial up connection.

Advantages of PSTN dial up

  1. This is the basic internet connection and all the ISPs provide this type of dial up.
  2. To install PSTN dialup and to use it is very cheap and affordable.

Disadvantages of PSTN dial up

  1. The speed of a typical PSTN modem is 56KBPS. Therefore the speed of the internet connection will be slower than this.
  2. During the time you are connected to the internet, you have to pay the telephone charges.
  3. While you are connected to the internet you cannot use your telephone to call anyone because you are using that phone line for connecting to the internet. You also will not receive any calls from outside during this time.

ISDN dialup

Integrated Services Digital Network (ISDN) dialup uses a higher end digital telephone line to dial up. To use this type of connection you need ISDN telephone line, computer and a ‘Terminal Adapter’.

Advantages of an ISDN dialup

  1. While you are connected to internet using ISDN dialup connection you can use your ISDN phone to make phone calls simultaneously.
  2. When you are making phone calls while connected to the internet then the speed of internet will be 64KBPS.
  3. If you are using the ISDN phone line just for internet then the speed of internet will be 128KBPS.

Disadvantages of ISDN dialup

  1. Not every place has ISDN connection.
  2. Even if your place has this facility, it is expensive to get an ISDN dialup connection from your ISP.
  3. Not all the ISPs provide ISDN dialup plan.

Leased Line Internet Plan

In both ISDN dialup and PSTN dialup you need to dial up from your computer before getting connected to the internet. And you close this connection when you no longer need internet connection. If you need a continuous connection 24 hours of the day and 7 days a week then you need a ‘Leased Line’ also known as ‘dedicated line’. This type of permanent connection is called ‘Always On’.

Advantages of Leased Line

  1. You get ‘Always on’ connection 24 hours every day.
  2. The speed of the internet ranges from 2.4 KBPS to 2G based on your subscription.

Disadvantages of Leased Line

  1. The disadvantages of a leased line is that it is very expensive.
  2. Since your computer is always connected to the internet your computer is exposed to many vulnerabilities such as viruses and spywares. So you may need to secure your computer using firewall and Antivirus software

DSL

  1. Digital Subscriber Line (DSL) also uses a normal PSTN phone line. But using DSL you can use both internet and phone simultaneously. Therefore many prefer DSL to PSTN dial up.

Advantages of DSL

  1. The speed of DSL connection is fast. 64 KBPS, 512 KBPS, 1.5MBPS and higher speed can be achieved in DSL connections.
  2. DSL also provides ‘Always On’ connection 24 hours a day always.
  3. You can also use your phone while using internet

Disadvantages of DSL

  1. More expensive
  2. You need an ADSL modem to connect but the distance between this modem and your computer cannot be more than 18,000 feet.

What is Broadband? Broadband choosing tips

In this article we will discuss the basics of broadband and tips to choose the right broad band plan for your home or office.

What is Broadband?

The definition of a broadband connection may differ between different countries. But generally you can say that any Internet connection with a minimum speed of 256Kbps and above can be considered as a broadband connection.

In a ‘Dialup’ connection, we dialup whenever we need to connect to the Internet and then close the connection when we have finished using the Internet.

But you can connect your computer to Internet 24 hours a day and 7 days a week. In other words it is ‘Always On’. Broadband connection is an always on connection. Your computer will be always connected to the Internet.

While using a dialup connection the maximum speed of the connection is only 56Kbps. Moreover when you are connected to the Internet using your phone dialup line, you cannot make or receive phone calls.

Broadband may be available in your area in any of these forms, Copper, Fiber Optics, cable, ADSL, IP VPN or Wireless.

What you need to ask before choosing your broadband provider.

  • Which broadband technology the provider is using
  • What is the monthly subscription and what is the one time set up fee
  • What is the speed of the broadband? Most of them just tell you the download speed. Ask them about the upload speed also.
  • What is the bandwidth allowed? That means how much data can be downloaded or uploaded. If there is a limit then what is the charges for additional data usage.
  • Is free email provided? If yes what is the storage capacity
  • What software and hardware are required to use that broadband connection. Is the hardware proprietary or can be bought from anywhere?
  • Is the installation free or you have to do it yourself
  • What are other conditions such as contracts etc.
  • What is the support provided?

Copyright © 1996-2010 All PC Tips. All rights reserved.
iDream theme by Templates Next | Powered by WordPress