home Java Script MS Access Perl HTML Delphi C ++ Visual Basic Java CGIPerl MS Excel Front Page 98 Windows 98 Ms Word Builder PHP Assembler Link to us Links |

Using Proofing Tools with Excel 97

What you will learn from this lesson

With Excel 97 you will:

- Use the built-in spelling checker.
- Use proofing formulas.
- Use AutoCorrect to correct your errors as you type.

What you should do before you start this lesson

- Start Excel 97.
- Open a new workbook.
- In cell C6, type
*Caan yoou wriite beter?* - On the
**Tools**menu, click**Spelling.** - Click
**AutoCorrect**for each misspelled word presented, select the correct word from the list of corrections. - Click
**OK**when the Excel 97 window shows spell checking is done. - Click cell C6, and press delete.
- In the worksheet from the previous lesson, click cell A2, and type
*=13/0*. (You tried to divide by zero.) - Click cell A4, and type
*=SQRT (“School”).*(You tried to find the square root of a word, rather than a number.) - Click cell A4, and type
*=SQRT ("School").*(You tried to find the square root of an undefined label.) - Click cell A5, and type
*=jk1*jm2*. (You tried to use a cell outside of the worksheet.) - Click cell A6, and type
*=1.25.5*2.45.3*. (You tried to multiply numbers with multiple decimal points.) - Close the workbook without saving changes.
- Open a new workbook.
- On the
**Tools**menu, click**AutoCorrect.** - In the
**Replace**dialog box, enter a word that you commonly misspell in the exact way that you misspell it. - In the
**With**dialog box, enter correct spelling. - Repeat steps 2 and 3, using words that you regularly misspell.
- Click
**OK.** - In cell B6, type a short sentence using one of your common misspellings.
- Close the workbook without saving changes.

Exploring the lesson

Using Excel 97, you can improve your worksheets and graphs with spelling and AutoCorrect functions. In the following exercises, you can check your spelling and your formula writing by entering wrong information, allowing Excel 97 to “fix” your errors, and then observing the results.

Checking your spelling

Identifying and correcting your spelling errors

- or -

Type the correct word.

Proofing formulas

Entering a wrong formula, or even part of a wrong one, will affect your calculations. Excel 97 will notify you when you have entered something that will not work.

Understanding formula error values

Excel 97 displays an error value in a cell when you have entered a formula incorrectly. Error values always begin with the number sign (#).

Correcting formulas

How you can use what you learned

Worksheets often contain text in titles and cells. You can use the spelling checker in Excel 97 to identify misspellings and prevent embarrassing mistakes. You can also use the spelling feature to correct graph titles and X-axis and Y-axis titles.

Office Assistant can suggest solutions to many of your problems. It opens the online Help feature of Excel and lists many subjects of interest.

Extensions

Many students are good spellers, but sometimes they consistently misspell certain words. For these few specific words, use the AutoCorrect feature of Excel 97 to anticipate and solve the spelling concerns. As you enter the specific word incorrectly, Excel 97 changes it for you. You can even enter those words that most often get tangled. By using the AutoCorrect feature in Excel 97, you and your students can avoid embarrassing mistakes on your charts and graphs.

Finding and correcting spelling errors with AutoCorrect

AutoCorrect makes the correction as soon as you finish typing the misspelled text and begin typing the next word or punctuation mark.

Using AutoCorrect

Summarizing what you learned

In this chapter you have explored and practiced:

- Using the built-in spelling checker.
- Proofing formulas.

- Using AutoCorrect to store your common errors with their corrections.