Microsoft Excel Exam WK 2

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

• True

• False

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

• True

• False

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

• True

• False

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.

• True

• False

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

• True

• False

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

• True

• False

Currency is an example of a number format.

• True

• False

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

• True

• False

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.

• True

• False

In formulas, calculations in square brackets are calculated first.

• True

• False