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 In Microsoft Excel, you can enter numbers and mathematical formulas into cells.

. + Addition - Subtraction * Multiplication. Shorthand. Shorthand is a term for the acronyms and other words used in chat rooms, e-mail, message boards, Internet, and other text-based messaging devices.

Shorthand

For example, lol, which is short for "laugh out loud" is an example of shorthand. Shorthand is used as an easy and quick way to express an emotion or type something in chat. Below is a listing of shorthand currently listed on Computer Hope. If you are looking for chat slang (common English misspellings and words) such as "wot" for "what" or "y" for "why" see the chat slang definition. Also see: Chat terms, Chat slang, Internet terms, Internet tips, Jargon. Keyboard definitions. PS/2. 1.

PS/2

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.

Keyboard

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. Computer Hopes computer dictionary. Browse through our list of over 12,000 computer terms and definitions either by using the above search, browsing by letter, or by clicking one of the links below.

Computer Hopes computer dictionary

Today's Computer Word: Gradient fill A gradient fill is a graphical effect that produces a three dimensional color look by blending one color into another. Multiple colors can be used, where one color gradually fades and changes to the other color, such as the gradient blue into white shown below. Continue reading >> Basic computer troubleshooting steps. Below is a listing of commonly asked computer questions and answers and basic troubleshooting steps for operating systems, software programs, and computer hardware.

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, highlighting text with the keyboard and pressing Ctrl + C is much faster than taking your hand from the keyboard, highlighting the text using the mouse, clicking copy from the file menu, and then putting your hand back in place on the keyboard. Below are our top 10 keyboard shortcuts we recommend everyone memorize and use. Ctrl + C or Ctrl + Insert Both Ctrl + C and Ctrl + Insert will copy the highlighted text or selected item. What is computer support? A Technology Word Definition From Webopedia.com.

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 Webopedia.com

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. Preventive Maintenance of a PC. Main » Did You Know » Hardware & Software » Posted January 25, 2008 Operating & Environment Conditions Do not place a PC directly near a heating or cooling source, such as heating vents or air conditioners.

Preventive Maintenance of a PC

Both excessive heat and cold can damage a PC. This includes putting the PC in the path of direct sunlight. Manufacturers often recommend that PCs be in a humidity-controlled environment, but again the PC should not be positioned so that an air conditioner is blowing cool air directly onto the unit (as temperature drops, the likelihood of static electricity increases). Tips to Diagnose and fix a slow running computer. It happens to the best of us.

Tips to Diagnose and fix a slow running computer

One day your Windows-based PC just seems to be taking far longer than usual to open applications and save files on your hard drive. 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.

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. From typing reports to taking and sharing class notes, this list of 30 free Web tools and open source software will help you get through your courses without spending a dime on software.

Deciphering Internet E-mail. Short for electronic mail, e-mail is the transmission of messages over communications networks. 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. 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. This list, courtesy of ServerWatch.com, 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 serverwatch.com 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. Mail Servers Almost as ubiquitous and crucial as Web servers, mail servers move and store mail over corporate networks (via LANs and WANs) and across the Internet. Server Platforms A term often used synonymously with operating system, a platform is the underlying hardware or software for a system and is thus the engine that drives the server.

Learn How Technology Works With Webopedia.com. Quick Reference articles breaks down complicated concepts and products in technology to digestible bite-sized bits for quick and easy understanding. 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. 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.

Internet Explorer. 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. CTT-TAC: Routing Information Protocol (RIP) In this module, you will learn the basic concepts behind RIP.

IP Routing. PARTS OF A SENTENCE. What is a URL (Uniform Resource Locator)? What is executable file. Different Parts of the Computer and Their Function. 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