Excel Functions Flashcard

Front

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

Back

True

Front

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

Back

True

Front

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

Back

False

Front

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.

Back

True

Front

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

Back

True

Front

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

Back

True

Front

Currency is an example of a number format.

Back

True

Front

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

Back

False

Front

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.

Back

False

Front

In formulas, calculations in square brackets are calculated first.

Back

False