T function, 743
Tab key, Tables menu, 241
Table Filter, 490
TABLE function, 360, 362
Table Name box, Tables menu, 256
Table object, 21
Table of Contents, Help system, 19
Table Styles, 239-240
Table Tools tab, Ribbon component, 21
tables. See also pivot tables
adding new rows or columns, 241-242
advanced filtering, 259-263
changing look of table, 239-240
converting to worksheets, 259
creating, 238-239
database functions, 271-273
deleting rows or columns, 242
example, 234-236
filtering, 248-249
formatting, 23
inserting subtotals, 273-276
moving, 242-243
navigating and selecting in, 241
referencing data in, 255-259
removing duplicate rows from, 244-245
setting options, 244
sorting, 246-247
and terminology, 234-237
uses for, 236-237
using formulas within, 253-255
working with Total Row, 249-253
worksheet database example, 234
tabs, 12-13
TAN function, 738
TANH function, 738
task pane, 15, 17
TBILLEQ function, 733
TBILLPRICE function, 734
TBILLYIELD function, 734
TDIST function, 742
technical support, 768-769
test scores, determining letter grades for, 223-224
testing and debugging functions
calling function from sub procedure, 637-640
setting breakpoint in functions, 640-641
using debug. print statements in code, 636-637
using VBA MsgBox statement, 634-636
text
number of characters in cells, 116
with numbers, displaying, 763
numbers as, 116-117
overview, 115-117
in quotes, displaying, 760
scrambling, 696
text cells, counting, 184
text formulas
counting number of words in cells, 137
counting occurrences of substrings in cells, 131
counting specific characters in cells, 131
determining column letters for column numbers, 132-133
expressing numbers as ordinals, 132
extracting all but first word of strings, 134-135
extracting filenames from path specifications, 133
extracting first names, middle names, and last names, 135-137
extracting first word of strings, 133-134
extracting last word of strings, 134
removing titles from names, 137
TEXT function, 120-121, 170, 743, 764
text functions
changing case of text, 127-128
character codes, 118-120
counting characters in strings, 123-124
creating text histogram, 124-125
custom VBA functions, 137
determining whether cells contain text, 117-118
determining whether two strings are identical, 120-121
displaying formatted currency values as text, 123
displaying formatted values as text, 122-123
extracting characters from strings, 128
finding and searching within strings, 129-130
joining two or more cells, 121-122
padding numbers, 125-126
removing excess spaces and nonprinting characters, 126-127
repeating characters or strings, 124
replacing text with other text, 128-129
searching and replacing within strings, 130
Text Length option, Settings tab, 557
text links, 449
text manipulation
extracting nth element from a string, 699-700
returning acronyms, 696-697
reversing strings, 695
scrambling text, 696
spelling out numbers, 700
whether cell contains text, 698-699
whether text matches a pattern, 697-698
Text number format, Options dialog box, 749
text string, 114, 151, 164
Thanksgiving Day, 164
thousands, displaying values in, 755
tilde, Search function, 130
TIME function, 164-166, 170-171, 729
time functions, 111
Time number format, Options dialog box, 749
Time option, Settings tab, 557
time value of money, 296
times. See dates and times
Times Interest Earned Ratio, 369
TIMEVALUE function, 164, 166, 170, 729
TINV function, 742
titles, removing from names, 137
TODAY function, 84, 109, 111, 148-149, 729
Toggle Breakpoint, Debug option, 640-641
toolbars, Visual Basic (VB) editor, 612
tools, 12-13
ToolTips, 12
Top Bottom Rules command, 528
"top n" values, summing, 203-204
total number of cells, counting, 182
Total Row, 107, 249-253
Totals Row check box, Tables menu, 244, 249, 253
Trace Error option, 586, 600
Transition Formula Entry option, 76
TRANSPOSE function, 383, 389, 413, 713, 736
trapezoids, area and parameter of, 283
Trend column, 540
TREND function, 232, 390, 477, 742
Trendline option, Chart Tools, 474
Trendline Options tab, Format Trendline dialog box, 474, 477-479
trendlines, 474-483
linear
calculating predicted values, 477
calculating R-squared, 478
calculating slope and y-intercept, 476-477
linear forecasting, 477-478
nonlinear
exponential trendlines, 481-482
logarithmic trendlines, 479-480
polynomial trendlines, 482-483
power trendlines, 480-481
trial balances, converting, 363-365
triangles, area of, 283
trigonometric identities, 280
trigonometry functions, 112
TRIM function, 124-125, 135, 547, 697, 743
TRIMMEAN function, 742
TRUE function, 735
TRUNC function, 287, 290, 738
Trust Center dialog box, Macro Settings, 609-610
Trusted Locations section, Trust Center dialog box, 610
TTEST function, 742
two-column lookup, 227-228
two-dimensional arrays, 376, 381-382
two-way data table, 360-362
two-way lookup, 225-227
Type argument, 297, 299-300, 302
TYPE function, 116, 735