pc health check: June 2008

A formatting that is applied to a cell or multiple cells and activated only if condition is met is called conditional formatting. For example, if a condition is applied in a selection that when any value in the selection is greater than 100, the value in the respective cell will be bold. In figure below, the conditional formatting is applied to the cells C3 to CIO. When values in these cells are changed, Excel automatically updates the format of the cell's.


In conditional formatting, you have to specify a condition or criteria for formatting. The criteria is specified in the Conditional Formatting dialog box.


To apply the conditional formatting, follow the steps.

1. Select the cell's, you want to apply conditional formatting.
2. Choose Conditional Formatting command from the Format menu. The Conditional Formatting dialog box will appear as shown below.
3. Specify the condition.
4. Click Format button to apply formatting. Format Cells dialog box will appear. Specify the format you want.
5. Click Add button to specify another condition. You can specify up to three different conditions.
   
6. Click OK.

To delete the conditional formatting, follow these steps.

1. Select the cell's, you want to delete the conditional formatting.
2. Choose Conditional Formatting command from the Format menu. The Conditional Formatting dialog box will appear.
3. Click Delete button to remove a condition. You will be asked to choose which condition (1, 2 or 3) you want to remove.
4. Select the condition and click Ok button.

source:computerfreetips.com

These are most commonly used output devices used to get prints of documents on the pager. Different printers have different mechanisms. Therefore purchasing a printer can be a sometimes confusing task. The following is additional information that will help in your purchasing decisions.

Technology of printers

There are many types and technology of printer are available in market but the most popular and commonly used are inkjet and laser printer.

Ink Jet Printer. The inkjet printer is not-impact character printer and prints one character at a time. The printing quality of inkjet printer is measured by the number of tiny ink of drops per inch(dpi). Most inkjet printers range from 300 to 2400 dpi. Printers with higher dpi usually are more expensive but having high printing quality. The speed of an inkjet printer is measured by the number of pages per minute (ppm) it can print. Its printing speed is up to 15 ppm. Therefore purchasing a printer can be depends upon printers dpi and ppm but It depends upon user need.

Laser Printer. A Laser printer is the fastest and high quality printer, but a laser printers are more expensive than inkjet printers and their print quality is also higher. The print quality and printing speed of laser printers make them ideal for offices and business. The laser printer can print text and graphics in very high quality resolution. The commonly user laser printers have resolution of 300 or 600 dpi and printing speed is from 5 to 30 ppm. The high quality laser printers have resolution from 600 to 2400 dpi. The printing speed of these printers is also more than 150 ppm.

Speed and price range

The price of laser printers depend on the quality and printing speed. The color printers are more costly than black-and-white laser printers. The higher the resolution and speed, the more expensive the printer.The price range can vary depending upon the quality of the printer and the type of printer for example inkjet, laser printers.

If you face any kind of probelm with your printer then go for Printer Help

source:computerfreetips

In Microsoft Excel, you can covert the digits list into Roman format automatically. MS Excel allows you to perform conversion by using a mathematical formula. The sentence structure for the Roman function is:

Roman( number, type )

Here number is the any specific digit or cell number that you want to perform conversion to roman and type is optional operator. Roman function will generate error message if you will try to enter here any negative number or values greater than 3999.

To apply a roman formula to MS Excel document, follow the given steps:

First click on Start button, go to Program then click on Microsoft Excel to open a new excel page.

Now enter any list of numbers in cell A1 to cell A15. In this example we are trying to insert any 15 numbers.

Here select the cells B1:B15 and then insert the Roman function =ROMAN(A1) in formula bar.

Now press "Control+ Enter" button to apply this formula to selected areas.

If you are facing any kind of computer problem the go for Technical Support

source:computertipsfree.com

Microsoft Office XP has working with built-in speech recognition features. The main purpose of this feature to understand the speech and then coverts to text file. You can run this feature in any Office XP applications, for example Microsoft Excel or Microsoft Word.

Follow the give steps to install the speech recognition features in office XP:

1.First click on Start button, go to Control Panel then click on Add or Remove Programs.

2. Now find and select the "Microsoft Office XP Professional with FrontPage" option in Add or Remove Programs list, then click on Change button.

3. Here select the option "Add or Remove Features" Change which features are installed or remove specific features", and click on Next button.

4. Here expand the "Office Shared Features"> Alternative User Input > Speech. Now click on Speech option and select "Run from My Computer" from menu and click on Update button to start installation process.

Now system will takes some time to install this feature.

After you have installed, open Microsoft Word > Tools > and click on Speech option.

Now click Next on welcome page.

If you are running it first time, then system will ask you for voice training, you can skip it but the voice training increase the chance of accuracy.

If the training is over, now try to speak "File" to open the File menu and check speech recognition feature has been working or not.

If you are facing any kind of problem with your computer then go for Computer Repair