Computers & Software

Sorted by:  

How to Apply Fill Colors, Patterns, and Gradients to Cells in Excel 2007

You can add emphasis to selected cells in an Excel 2007 worksheet by changing the fill color or applying a pattern or gradient effect to the cells. If you’re using a black-and-white printer, restrict your [more…]

Understanding C#'s "If" Statement

The basis of all C# decision-making capability is the ifstatement, as follows:

if (bool-expression)
// Control goes here if the expression is true.
// Control passes to this statement whether the expression [more…]

How to Hook up Your Laptop to a Video Projector

You can easily connect your laptop to a video projector. Using your laptop with a video projector is great if you want to display your PowerPoint presentation on a large screen at the end of a meeting [more…]

Rounding Numbers in Excel 2007 with ROUND, ROUNDUP, and ROUNDDOWN

The mathematical functions ROUND, ROUNDUP, and ROUNDDOWN are included in the Math & Trig category in Excel 2007. You'll find these by clicking the Math & Trig button on the Ribbon’s Formulas tab or in [more…]

How to Test Whether Your PC Has Enough Memory

Knowing how much memory is in your PC is one thing, but knowing whether that amount is enough is entirely different! The amount of memory your PC needs depends largely on the memory requirement of your [more…]

Tuning Into Ten Short, Useful Perl Programs

Some people believe that short programs aren't good for very much, but that's not so with Perl. Just a couple lines of Perl code can go a long way. This article lists some handy teeny, tiny Perl programs [more…]

How to Test Your Laptop’s Battery

Laptop batteries can fail, or over time can lose their ability to hold a charge. If your laptop suddenly stops cooperating, you can usually determine if a bad battery is causing the problem by removing [more…]

How to Cut, Copy, and Paste in Windows XP

You can cut, copy, and paste in Windows XP to move items or copies of items to other locations within a file, or to a different file or application. Using the cut, copy, and paste features allows you to [more…]

How to Change Numbering Format in Word 2007 Numbered Lists

Word automatically formats text as a numbered list when you when you type a number and a period followed by a space: Word adds a tab and creates a ¼-inch hanging indent. [more…]

Creating a Sheet of Identical Labels with Word 2007

One of the things Word 2007 does easily and reliably is to print a sheet of identical labels. To do so, just follow these steps:

1. Click the Mailings tab. [more…]

Changing Chart Elements in Excel 2007

The command buttons on the Chart Tools Layout tab in Excel 2007 make it easy to change or customize particular parts of your chart. This customization includes buttons in the following groups on the Layout [more…]

How to Make a Wireless Network Connection

When you have your wireless network in place and your PC ready, you can easily make the wireless connection between the two. Microsoft recommends that your wireless base station or WAP broadcast the SSID [more…]

Setting Up E-Mail Reminders in Outlook 2007

In Microsoft Outlook 2007, you can set up a reminder to respond to or follow up on e-mail messages. If you know your way around the Calendar and Tasks windows in Outlook 2007, you know that the Reminder [more…]

How to Build an Array Formula in Excel 2007

Remember that an array formula is a special formula that operates on a range of values. When you build an array formula in a worksheet, you use the Ctrl+Shift+Enter keyboard shortcut to insert an array [more…]

The General Keyboard Layout on a Laptop

A typical laptop keyboard layout has typewriter keys, shift keys, function keys, and cursor control keys.

The below figure illustrates a typical laptop keyboard layout, where all the common keys found on [more…]

How to Change the Print Margins in Excel 2007

Print margins indicate how much white space Excel 2007 places between the worksheet data and the edge of the page. The Normal margin settings that Excel applies to a new workbook use top and bottom margins [more…]

Using AutoCAD DesignCenter

DesignCenter is a dumb name for a useful, if somewhat busy, palette. The DesignCenter palette is handy for mining data from all kinds of drawings. Whereas the Properties palette is concerned with object [more…]

How Does a Computer Program Work?

Computers don't do anything without someone telling them what to do, much like the average teenager. To make the computer do something useful, you must give it instructions in either of the following two [more…]

How to Remove Page Numbers in Word 2007

In Word 2007, you can remove page numbers you’ve inserted. If you used the Page Number menu to insert your page numbers, you can use the Remove Page Numbers command to remove those page numbers. [more…]

How to Program Your PC to Hibernate

You can save power and not-quite-exactly turn your PC by making it hibernate. When your computer hibernates, it saves all the memory — everything the system is doing — then turns the computer off. Hibernating [more…]

Adjusting Page Breaks in Excel 2007

The Page Break Preview feature in Excel 2007 enables you to spot page break problems in an instant as well as fix them, such as when the program wants to split onto different pages information that you [more…]

Installing and Configuring DHCP

If you have worked with Windows NT at all, you are probably familiar with Dynamic Host Configuration Protocol (DHCP) — a server service that enables the server to dynamically assign IP addresses to network [more…]

How to Create a Motion Path for Moving Elements Across a PowerPoint 2007 Slide

You can make elements on your PowerPoint slide behave like cartoon characters by making use of a kind of the PowerPoint animation effect called a motion path. Make your PowerPoint elements travel in a [more…]

Creating PivotCharts in Access 2003

You can display the information from any Access 2003 table, query, or PivotTable as a PivotChart. When you create a PivotChart, you actually create a special view of a form, and the PivotChart is stored [more…]

Word 2007 Mail Merge — Step 1: Creating the Main Document

To use the Word 2007 Mail Merge feature, you begin with a main document. This can be created from a new, blank document, a template, or an existing document. [more…]

Sign Up for RSS Feeds

Computers & Software