Page 75 - Excel Workbook for Dummies

08_798452 ch04.qxp 3/13/06 7:36 PM Page 58
58 Part I: Creating Spreadsheets

Try It

Exercise 4-6: Editing Cell Entries

Open the Exercise4-6.xls workbook file in the Chapter 4 folder inside your My Practice
Spreadsheets folder or on the Excel Workbook CD-ROM. This file contains a copy of
the CG Media 2006 Sales worksheet that you can use to practice making simple editing
changes to the contents of particular cells in the spreadsheet:

1. Click the I-beam pointer in front of the C in Category, and then type Media and
on the Formula bar and click the Enter box to insert this text in the spreadsheet
title in cell A1.
The edited title in cell A1 now reads, CG Media – 2006 Sales by Media and
Category.
2. Double-click the white-cross pointer after the s in Discs in the row heading in cell
A3, and then remove this extraneous s.
The edited row heading in cell A3 now reads, Compact Disc Sales.

3. Position the cell cursor in cell A14, press F2 and then replace Cassette in the row
heading with Tape and press Tab to complete the edit.
The row heading in cell A14 now reads, Total Tape Sales.
4. Select cell A1 again and save your editing changes in a new file named
Solved4-6.xls in your Chapter 4 folder inside the My Practice Spreadsheets
folder, and then close the workbook file.

Catching Errors with Text to Speech

If you’re using Excel 2002 or 2003, you can use the Text to Speech feature to catch data
entry errors by listening to them. Text to Speech reads the entries in a data table or
list out loud, enabling you to check their accuracy by keeping your eyes focused on
the printed source from which they were originally entered.

Try It

Exercise 4-7: Verifying Data Entries with Text to Speech
If you have Excel 2002 or 2003 installed on your computer, open the Exercise4-7.xls
workbook file in the Chapter 4 folder inside your My Practice Spreadsheets folder or in
the Excel Workbook folder on the workbook CD-ROM. This file contains a copy of the
Spring 2006 Furniture Sale spreadsheet that you can use to practice using Text to
Speech to verify the accuracy of entries in a data table:

1. Choose Tools➪Speech➪Text to Speech on the Excel menu to open the Text to
Speech toolbar (see Figure 4-3).
If this is the first time you’ve used Text to Speech, Excel must install the program
before it can display this toolbar. Follow the prompts to install the program and
then after you have it installed proceed to the next step of the exercise.
2. Click the Speak Cells button on the Text to Speech toolbar and listen to the
entries in cell A1 and then across the column headings in the row. After you
hear the entry Sale Price in cell E2, click the Stop Speaking button.
3. Click the By Columns button and then click the Speak Cells button again and
listen to the entries in the cell range A3:A7.