Microsoft Excel II

To apply formats to data when it meets criteria you specify, you can use conditional formatting.

To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.

Changing a worksheet window to Normal view changes the contents of the worksheet.

To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

To enter data in a cell using examples already in your workbook, you can use the flash fill feature.

Currency is an example of a number format.

When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.

Jim frequently prints out the same section of a worksheet. To do so, he selects the cells he wants to define as print area, then clicks Print Area and then clicks Set Print Area on the Page Layout tab in the Scale to Fit group.

In formulas, calculations in square brackets are calculated first.