999
Index
TBILLEQ function, 924
TBILLPRICE function, 924
TBILLYIELD function, 924
TDIST function, 919
T.DIST function, 931
T.DIST.2T function, 931
T.DIST.RT function, 931
templates
chart, 469–470
creating workbooks from, 162–164
custom
changing workbook defaults, 166–167
changing worksheet defaults, 167–168
editing, 168
ideas, 170
overview, 165–166
resetting default settings, 168
saving, 170
modifying, 164–165
viewing, 161–162
Templates icon, 470
test scores.xlsx sample file, 940
testing
custom number format, 565
UserForms, 848, 852, 854–855
text
adding to Shape images, 520
alignment
controlling the direction, 126–127
displaying at an angle, 125–126
horizontal alignment options, 122–123
merging cells, 124–125
vertical alignment options, 124
wrapping or shrinking, 124
case changing, 239–240
counting occurrences of, 292–293
counting text cells, 285
displaying, 40
entering and editing, 32–33
entries, 30
free-floating, 445
number formatting, 566–567
replacing with other text, 241–242
text alignment.xlsx sample file, 936
Text Axis option, 454
Text Category Functions, 932
text data, 29–31
Text Direction setting, 126
Text Filters option, 113
Text format category, 554RATE function, 332
Series formula, 459
syntax error, 649
system requirements, CD-ROM, 933T
T function, 932
Tab list, 6, 8
tab order, UserForm, 856–857
tab scrolling controls, 53
tab split control, 53
table and chart.xlsx sample file, 935
Table Filter, pivot table, 705
table formulas.xlsx sample file, 936
table headings, 63
Table Style Options group, 107
table_array argument
HLOOKUP function, 314
VLOOKUP function, 312
tables. See also data tables; Pivot tables
Access, importing, 679–680
changing look of, 103–105
converting back to ranges, 113
creating, 102–103
creating outlines, 585
filtering, 112–113
formulas within, 216–217
moving, 106–107
navigating, 105
options, setting, 107
overview, 99–102
parts, selecting, 105
referencing data, formulas, 217–218
rows and columns
adding, 105–106
deleting, 106
removing duplicate, 109
selecting entire, 105
sorting, 110–112
summarizing formula data, 214–216
Total Row feature, 107–109
Tables pane, Microsoft Query, 691, 693
tabs
changing color, 55–56
Ribbon interface, 11–12, 546–547
TabStrip control, 844
TAN function, 928
TANH function, 928
target cells, 765
task pane, 22
tasks, Query application, 681–68260_474877-bindex.indd 99960_474877-bindex.indd 999 3/29/10 11:48 PM3/29/10 11:48 PM