background preloader

PC Learning

Facebook Twitter

Useful Internet Stuff. Software. Computer printers. Excel Formulas. Lesson 1 familiarized you with the Excel 2007 window, taught you how to move around the window, and how to enter data.

Excel Formulas

A major strength of Excel is that you can perform mathematical calculations and format your data. In this lesson, you learn how to perform basic mathematical calculations and how to format text and numerical data. To start this lesson, open Excel. Set the Enter Key Direction In Microsoft Excel, you can specify the direction the cursor moves when you press the Enter key. Click the Microsoft Office button. Click Advanced. Perform Mathematical Calculations.

Shorthand. Keyboard definitions. PS/2. 1.


Often referred to as the mouse port or keyboard port, the PS/2 port was developed by IBM and is used to connect a computer mouse or keyboard to an IBM compatible computer. The PS/2 port is a mini DIN plug that contains six pins and is still found on all IBM compatible computers today, however, is starting to be replaced by USB. In the picture to the right, are two pictures of what the PS/2 ports look like on the back of your computer.

Keyboard. One of the primary input devices used with a computer, the keyboard looks very similar to the keyboards of electric typewriters, with some additional keys.


Keyboards allow a computer user to input letters, numbers, and other symbols into a computer and is what allows you to write e-mail and is what you used to visit this web page. Below is an example of a Saitek keyboard with indicators pointing to each of the major sections of the keyboard. Overview of each section of the keyboard Keyboard. Computer Hopes computer dictionary. Basic computer troubleshooting steps. Top 10 keyboard shortcuts everyone should know.

Using keyboard shortcuts can greatly increase your productivity, reduce repetitive strain, and help keep you focused.

Top 10 keyboard shortcuts everyone should know

For example, to copy text you can highlight text and press the Ctrl + C shortcut. The shortcut is faster than moving your hands from the keyboard, highlighting with the mouse, choosing copy from the file menu, and then returning to the keyboard. Below are the top 10 keyboard shortcuts we recommend everyone memorize and use. Ctrl + C or Ctrl + Insert and Ctrl + X Both Ctrl + C and Ctrl + Insert will copy the highlighted text or selected item. What is computer support? A Technology Word Definition From Main » TERM » C » Computer support companies and services specialize in troubleshooting and fixing a wide variety of primarily software-related personal computer issues and network connectivity problems as well as some hardware issues.

What is computer support? A Technology Word Definition From

Also known as technical support, computer support can take the form of an on-site visit or remote help via telephone, e-mail, text or instant messaging, online chat or even remote desktop control. Many larger companies have their own technical support departments, whereas smaller businesses and individuals typically turn to a computer support firm or the Internet when diagnosing and addressing computer-related issues. Preventive Maintenance of a PC. Tips to Diagnose and fix a slow running computer. Free Web Tools and Open Source Software Tools for Students - Webopedia. Main » Quick Reference » Posted June 01, 2011 If you are a student you're probably wondering how to manage the cost of tuition, books and living expenses – and still pay for the software you need for your student laptop or desktop computer for research and assignments.

Free Web Tools and Open Source Software Tools for Students - Webopedia

Commercial software purchases can quickly eat away at the budget you have. The good news is that there are many free Web tools and open source software for students that will help you stay on task and organize your busy student life. Deciphering Internet E-mail. Short for electronic mail, e-mail is the transmission of messages over communications networks.

Deciphering Internet E-mail

These messages can be notes entered from the keyboard or electronic files stored on disk. Most mainframes, minicomputers, and computer networks have an e-mail system. Some e-mail systems are confined to a single computer system or network, but others have gateways to other computer systems, enabling users to send electronic mail anywhere in the world. Internet E-mail. 10 Data Center Server Hardware Must-Haves. Server Types. Main » Quick Reference » Posted February 10, 2011 Servers are often dedicated, meaning that they perform no other tasks besides their server tasks.

Server Types

This list, courtesy of, categorizes the many different types of servers used in the marketplace today. Click on the type of server you'd like to know more about, and you will be taken directly to a page that provides additional information and resources. Proxy Servers A proxy server sits between a client program (typically a Web browser) and an external server (typically another server on the Web) to filter requests, improve performance, and share connections. Learn How Technology Works With Quick Reference articles breaks down complicated concepts and products in technology to digestible bite-sized bits for quick and easy understanding.

Learn How Technology Works With

Learn how to navigate the digital tech world with our Quick Reference. Featured Articles and Guides Flash Data Storage Vendor Trends Although it is almost impossible to keep up with the pace of ongoing product releases, here are three recent highlights in the flash data storage space. » 15 Important Big Data Facts for IT Professionals Keeping track of big data trends, research and statistics gives IT professionals a solid foundation to plan big data projects.

Here are 15 important big data facts that every IT professional should know. » Enterprise Storage Vendors There's a number of vendors that sell enterprise storage hardware or offer cloud-based enterprise storage. USB. Overview[edit] In general, there are four basic kinds or sizes related to the USB connectors and types of established connections: the older "standard" size, in its USB 1.1/2.0 and USB 3.0 variants (for example, on USB flash drives)the "mini" size (primarily for the B connector end, such as on many cameras)the "micro" size, in its USB 1.1/2.0 and USB 3.0 variants (for example, on most modern cellphones)the versatile "USB On-The-Go" scheme, in both mini and micro sizes.


Unlike other data cables (Ethernet, HDMI etc.), each end of a USB cable uses a different kind of connector; an A-type or a B-type. Internet Explorer. Web Page Translation Custom Search A browser is a program that allows you to interact and view the internet and contents of the Web. The Web Browser, Internet Explorer, or IE is developed by Microsoft and comes pre-installed when you buy a Windows computer. Internet Explorer is probably the most commonly used browser.

Open Internet Explorer by clicking the blue e Icon. Free Computer Tutorials for Beginner & Senior Users. Java SE Runtime Environment 7 Downloads. DSL Troubleshooting. Help Center. Network Troubleshooting. Taskbar Repair Tool Plus! Cleanup the Taskbar Notification Area (System Tray) in Windows XP & Vista. Remove Program Icons from the System Tray Some programs offer a choice so that you can remove their program icons from the Notification Area. To find these options, right-click the program’s icon and choose Properties, Preferences, or any other choice that will allow you to set the program’s configuration. How to make netbooks run faster. 5 Ways to Speed Up Your Netbook. Netbooks are a great solution for those who want a portable computer that doesn’t break the bank. They are a slimmed down version of the PC that you can take anywhere, but they don’t have the same power that notebooks do. Here’s five free ways to juice up your netbook and make it run faster. 1.

CTT-TAC: Routing Information Protocol (RIP) IP Routing. PARTS OF A SENTENCE. Parts of a Sentence (Also see Sentences, or follow the links to see more on a topic) Subject The subject of a sentence is the noun---or word group acting as a noun---that performs the action expressed in the predicate of a sentence or clause. The subject may be one word: Sally loves chocolate. What is a URL (Uniform Resource Locator)? What is executable file. Different Parts of the Computer and Their Function. Random Access Memory, or RAM, is the part of your computer that is used as instant memory. Exploring the Internet. Windows Basics: all topics. Computer Dictionary Glossary Lexicon Online. Computer Glossary. Glossary of Common Desktop Computer Terms. Computer Corp. - Support.

PC Virus/Problems Tools