A

A functions, 556

A status link indicator, 475

A1 reference style, 431–432

A4 paper, 405

Above Average filtering, 687–688

ABS function, 947

absolute cell references

cell names as, 443

computed filter criteria and, 695–697

copying, 432–433

defined, 429–430

dynamic hyperlinks and, 880

ignoring, 452

linked workbooks and, 476–477

linking data and, 897

macros and, 832

in names, 448

ACCDB files, 749–750

ACCDE files, 749–750

accelerated depreciation, 542–543

accepting changes, 797

Access databases, 746, 749–750, 759

access to documents with IRM protection, 805

accessibility features, 100

accounting formats, 301–304

Accounting Numbers Format button, 301

ACCRINT function, 545, 947

ACCRINTM function, 545, 947

ACOS function, 947

ACOSH function, 947

Across Worksheets command, 217

activating Excel 2007, 21–22

active area of worksheets, 29

active cells

defined, 25

displaying, 429

keyboard shortcuts, 944

overview, 128

active content in Microsoft Office Online, 47

active worksheets, 417

ActiveX Settings category, 106–107

ad hoc grouping in PivotTables, 737–738

ad hoc mapping of XML elements, 757–758

ad hoc text in chart labels, 653

add-ins

Analysis Toolpak add-in, 544–549

Conditional Sum Wizard, 478–483

Euro Currency Tools add-in, 549–551

Lookup Wizard, 478–479, 483–485

as OLE server applications, 887

Solver, 601–611

Trust Center, 106–107

workbooks as, 855

XPS documents, 423

Add To Selection mode, 127

addition, 497–498. See also SUM function

ADDRESS function, 516, 948

addresses

document workspaces, 817

entering with macros, 830–832

hyperlinks, 874–875

Administrator privileges, 808

advanced display options, 97

Advanced filtering

computed criteria, 695–697

criteria ranges, 689–690

defined, 684

extracting filtered rows, 697–698

multiple criteria on same column, 695

OR and AND example, 694

three ORs on a column, 693

two columns joined by OR, 690–693

Unique Records Only option, 698–699

 Advertising.xlsx file, 603

After Pressing Enter... option, 208

aggregate calculations, 764, 774–777

aggregate fields, 776–777

alerts

busy files, 790

compatibility errors, 55

SharePoint tasks, 814

time-consuming operations, 210

alignment

caution, 318

centering text across columns, 318

chart axis labels, 627

distributing cell contents, 318

filling cells with characters, 318

graphics, 391–393

headers and footers, 410

horizontal, 316, 317–320

indenting cell contents, 317–318

justification, 319–320

pasted tables in Word, 891–893, 895

rotating text, 320–322

shrinking text to fit, 322–323

text, 383

text direction, 317

text orientation, 317, 320–322

text wrapping, 317, 319

tools, 317

vertical, 317, 320–323

all, pasting, 187

All Dates In Quarter filtering, 688

All Except Borders pasting, 187

[#A11] specifier, 458

#A11 tag, 704

All Using Source Theme pasting, 187

alphabet keyboard shortcuts, 934–935

alphabetical ranges of text, filtering lor, 689

alphabetical sorting, 683–684

Alt key, 927–946

alt text tags, 391

AM notation, 523, 529

AMORDEGRC function, 948

AMORLINC function, 948

ampersand (&), 436–437, 458

Analysis Toolpak add-in

Descriptive Statistics tool, 568–569

histograms, 570–573

installing, 567–568

Moving Average tool, 580–582

new and changed features, 13

random number functions, 574–579

Rank And Percentile tool, 573–574

Sampling tool, 579–580

securities functions from, 544–549

 Analysis.xlsx file, 562

Analyze tab, 920

AND conjunction, 692, 694

AND function, 508–509, 948

 And Or Not.xlsx file, 509

animation feedback, 100

annotations on charts, 628–629

annual duration of securities, 548–549

annual yields of securities, 547

ANSI characters, 682, 683–684

Answer reports, 610

apostrophe ('), 142–143, 458, 835, 852

AppData folder, 48

appearance, customizing. See customizing

Apply Names dialog box, 451–452

AREAS function, 520, 948

areas of shapes, 630

arguments

in arrays, 468

in custom functions, 849, 851

defined, 438

expressions as, 491

in financial functions, 535–536

in formulas, 243

Function Arguments dialog box, 489

in function syntax, 490–492

number of, in functions, 491

optional, in custom functions, 853–854

securities-related, 544

types of, 491–492

VBA methods and, 840–841

vector and array form, 513, 515

Arrange Windows dialog box, 166–168

array ranges, 468, 469

arrays

arguments, 468, 513, 515

cells in, 469

constants, 468, 471–473

defined, 468

For Each statements and, 867

editing, 469

expansion of, 473

formulas, 10, 191, 468

as function arguments, 492

INDEX function and, 517

jumping to, 133

keyboard shortcuts, 944

limits, 10

linear regression functions, 566

new and changed features, 10

one-dimensional, 468–469

pasting formulas as constants, 191

rules for, 469

single-cell array formulas, 471

transposing orientation, 520

two-dimensional, 470

arrow keys, 942

arrows, 465

ASC function, 948

ASCII functions, 504

ASIN function, 948

ASINH function, 949

Assert method, 864, 865

assigning tasks, 812–814

assistants, adding to organization charts, 360–361

asterisk (*), 225, 427, 458, 689

ATAN function, 949

ATAN2 function, 949

ATANH function, 949

attachments to e-mail, 800–802, 817

audience definition in worksheet design, 120–121

audio files, 363

auditing formulas, 243–245

auditing worksheets

cell references and, 245–246

dependents, 246, 247–248

displaying calculation steps, 242

editing in formula bar, 242

error checking, 242–243

error tracing, 249–250

formulas, 243–245

Help for, 242

ignoring errors, 242

precedents, 246, 248–249

references to other worksheets, 250–251

tracer arrows, clearing, 248

tracing, 245–250

watching formulas, 245

 Audit.xlsx file, 247

authentication, 803, 806

Auto Data Tips feature, 861

Auto List Members feature, 861

Auto Quick Info feature, 861

"AutoAutoFormat" feature, 228

AutoCalculate feature, 45

AutoComplete feature

accessibility and, 100

enabling, 210

formulas and, 11–12

new and changed features, 11–12

overview, 230–231

AutoCorrect feature

capitalizing first letter of sentences, 228

capitalizing names of days, 228

common spelling errors, 232. See also spelling checker

converting URLs to hyperlinks, 228

copyright symbols, 228

correcting Caps Lock key, 228

correcting two initial capitals, 228

displaying, 227

displaying options, 228

hyperlinks and, 874

Internet addresses and, 228

keyboard shortcuts, 936

network addresses and, 228

overview, 227

replacing text while typing, 228

smart tags and, 229–230

table features, 672

typing errors and, 227–230

URLs and, 228

autoexpansion in tables, 667

AutoFill feature. See also data series

commands, 217

custom lists and, 218–219

filling across worksheets, 217

filling columns, 216

filling in series, 216

filling rows, 216

filling with dates, 216

growth options, 216

justification and, 217–218

keyboard shortcuts, 217

linear options, 216

linear trends, 215

series of dates, 523–526

shortcut menu, 215

smart tags and, 212

suppressing, 213

trends and, 215, 216

AutoFilter feature, 9, 15, 16, 918. See also filtering

AutoFit feature, 335, 915

AutoFormat feature. See table styles

AutoLetter feature, 405

automatic actions

backup, 58

calculations, 45

colors, 636

completion. See AutoComplete feature

data recovery, 79–80

decimal point insertion, 209

error correction. See AutoCorrect feature

filtering, 9, 15, 16, 918

formatting, 219–220

online connection, disabling, 75

queries, 772

styles, 255

syntax checking, 860

updating linked objects, 889, 896

automatic links warning, 474

Automatic Query feature, 772

automatic styles, disabling, 255

AutoRecover feature, 79–80

AutoSum button, 439, 498, 923

available clip art, 363

AVEDEV function, 949

AVERAGE function

compared to AVG, 502

overview, 554, 949

in PivotTables, 732

total rows in tables, 675

AVERAGEA function, 502, 556, 949

AVERAGEIF function, 949

AVERAGEIFS function, 949

averages

functions, 554

Moving Average tool, 580–582

in Query, 764

replacing totals with, 674–675

switching syntax to Excel AVERAGE, 502

AVG function, 502, 775

axes

changing in charts, 625–626

charts, 619

depth, 651–652

intersection point, 644–645, 647–648

labels, 635, 643

line styles, 635–637, 642

logarithmic scaling, 645

moving labels, 635

nonadjacent data sources and, 656–657

rescaling, 644–645

reversing scale, 645

scaling factors, 645–648

secondary value, 653

Shape Styles feature, 630

single-axis PivotTables, 713

time-scaled, 645, 648–651

titles, 619, 626–627, 635

types of, 625

axis labels, 635, 643

axis titles, 619, 626–627, 635