When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

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

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

Currency is an example of a number format.

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

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

To change the background color of a cell, you use the Background color button.

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

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

Which of the following is TRUE of the Excel spell checker?

To accept a suggested spelling for one instance only, which of the following would you click?

Which of the following is true about adding cell borders?