Page 76 - Excel Workbook for Dummies

08_798452 ch04.qxp 3/13/06 7:36 PM Page 59
Chapter 4: Modifying the Spreadsheet 59
Notice how the mechanical voice, called LH Michael (LH stands for Lerner &
Hauspie, the folks who created the voice), pronounces the contents of cell A3 as
“twelve to three hundred five” rather than “twelve dash three hundred five” (the
program interprets the dash as indicating a range).
4. After LH Michael finishes speaking “retail price one thousand three hundred
ninety-nine” in cell C7, click the Stop Speaking button again.
5. Click the Start button on the Windows taskbar and then click Control Panel on
the Start menu.
6. Click the Sounds, Speech, and Audio Devices link followed by the Sound link (if
your Control Panel is in Classic view, simply double-click the Speech icon) and
then click the Text to Speech tab to display its options in the Speech Properties
dialog box.
7. Select LH Michelle in the Voice Selection drop-down list and listen to her voice
preview before you select OK.
8. Click the Speak Cells and listen to LH Michelle say the remaining entries in the
data table. When she’s finished speaking, click the Stop Speaking button.

In addition to listening to entries already made in a spreadsheet, you can have
Text to Speech read back each entry as you make it. Try this in a scratch work-
sheet in a blank workbook.
9. Open a new blank workbook by clicking the New button on the Standard toolbar.

10. Click the Speak on Enter button on the Text to Speech toolbar (upon which LH
Michelle tells you that “cells will now be spoken on Enter.” Make the following
entries down column A:
• Northeast Consortium in cell A1.
• Alfred E. Neuman in cell A2
• -89.45 in cell A3
• CD-ROM in cell A4
• 95-11-0034 in cell A5

• 415-555-0023 in cell A6
• 3678.6 in cell A7
• May 12, 2006
11. Close the blank workbook without saving your Speak on Enter text entries to the
scratch worksheet; then click the Speak on Enter button to turn off this feature
before you close the Text to Speech toolbar. Close the Exercise4-7.xls workbook
without saving your changes.

Figure 4-3: Speak Cells
The
Advanced Speak on Enter
tab of the
File Search By Rows
dialog box
enables you
to search
for work-
books using By Columns
summary
information. Stop Speaking