T

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