Page 369 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 352
352 Excel Workbook For Dummies
• T • Text Import Wizard, 165
Text to Speech
Tab key, 16, 227 Speak on Enter feature, 59
table verifying data entries with, 58–59
building formulas that perform horizontal third-party add-ins/utilities, 326. See also
lookups in a, 143–144 installing CD files
building formulas that perform vertical lookups third-party software, on CD, 326–327. See also
in a, 145–146 installing CD files
formatting with AutoFormat, 32–33 tick mark, 173
using the Lookup Wizard to build formulas that time
perform two-way lookups in a, 147–148 building formulas with common functions,
Table dialog box, 234 112–113
TABLE function, 235, 237 number format, 28
table_array argument, 142, 151 time formulas
target cell, 242 building, 107–109
template overview, 107
creating a, 309 TIME function, 112–113
description of a, 11 TIMEVALUE function, 112–113
Template dialog box, 309 TIP icon, 6
templates tips for using Excel like a pro, 309–315
creating, 11 Title optional argument (Input Box), 297
filename extensions of, 11 toolbar
generating new workbooks from, 309 assigning hyperlinks to a, 279–281
Microsoft Office Home Page, 309 assigning macros to a, 290–291
opening a new workbook from a, 10–11 chart, 180
on Spreadsheet Solutions, 309 docking/undocking a floating, 65
Templates dialog box, 309 Drawing, 186, 189, 194–196, 196–198, 198–200
Templates folder, 10 External Data, 220, 271
text formatting, 26–27
number format, 28 Formula Auditing, 102
operators, 74 Picture, 193
text box PivotTable, 246, 249–250, 252–254
adding to a spreadsheet, 196–198 restoring the interactive, 266
border patterns of a, 197 Reviewing, 64
creating a, 196–198 Standard, 25
manipulating a, 65 using the customize dialog box to display a, 27
versus comments, 197 Visual Basic, 294
Text Control options in Format Cells dialog box, Web, 275
30–31 WordArt, 200
text entry Trace Precedents/Dependents buttons, 102
changing the capitalization of a, 164–167 transpose check box, 62
ink, 16 troubleshooting, CD, 328
voice, 16 TRUE function, 149–150
text formulas two-dimensional arrays, 99
building, 161–164 two-variable data table
caveats to, 161 creating a, 236–237
that join data entries, 162–164 placement of a formula in a, 236
uses for, 162 two-way lookups
text functions using the Lookup Wizard to build formulas that
that join date entries and change their case, perform, 147–148
165–167 using the Lookup Wizard for, 146–148
using, 164–167