Page 764 - Excel 2013 All-in-One For Dummies

746 Excel 2013 All-In-One For Dummies
Align option, 531, 551 Align Right button, 146 Align Text Left button, 146 aligning
charts, 531
graphics, 551
pivot tables, 679–680 text boxes, 563
Alignment group, Home tab, 145–146
Alignment tab, Format Cells dialog box, 157–161
All Except Borders option, Paste Special dialog box, 213
All Merging Conditional Formats option, Paste Special dialog box, 214
All option, Paste Special dialog box, 213
All Using Source Theme
option, Paste Special
dialog box, 213
Allow Users to Edit Ranges
dialog box, 446, 449 Alt Text tab, PivotTable
Options dialog box, 692 AMORDEGRC function, 385 AMORLINC function, 385 Analysis Services, importing
data from, 632
Analysis ToolPak add-in, 69,
70, 385–388, 407, 424 Analysis ToolPak - VBA add-
in, 69, 70
Analyze tab, PivotTable
Tools contextual
tab, 676
AND conditions, setting up,
615–617
AND function, 341, 619 Angle Clockwise orientation
option, 160
Angle Counterclockwise
orientation option, 160
Answer reports, 665 apostrophes (’), in cell
entries, 86
Apple iPad, SkyDrive app
for, 499 applets, 41
Apply Names dialog box, 331–333
Arabic function, 389
area charts, inserting, 520 AREAS function, 417 arguments of functions,
299, 304, 311–312,
375–376
arithmetic operators, 306 Arrange Windows dialog
box, 256, 257, 258, 261 array constants, 319, 320 array formulas
building, 320–323 editing, 323 functions returning
number of columns and
rows in, 417–418 general discussion,
319–320
orientation, changing with
TRANSPOSE function,
418–419
TABLE function, 649
array ranges, 319 arrows
adding to text boxes, 565–566
for tracing, removing, 347–348, 358
Artistic Effects option, 559 ARX CoSign Digital
Signatures, 466 ascending sort order, 588 assets, calculating
depreciation of,
383–385
Assign Macro dialog
box, 720
asterisk (*) wildcard, 217, 263, 406, 614
attached text, 517 attachments, sending
workbooks as, 494 authenticating macros,
716–718
Authenticode, Microsoft, 716 authors, 19, 47
Auto Outline feature,
238–244 AutoCalculate section,
Status bar, 34 AutoComplete feature,
96–97, 312 AutoCorrect button,
Spelling dialog box, 223 AutoCorrect Exceptions
dialog box, 51 AutoCorrect feature, 51,
97–98 AutoFill feature
copying cell entries, 206 copying formulas, 313 custom lists, filling out
with, 106–109 general discussion,
100–103
increment settings for,
105–106
on touchscreens, 103–104 using Fill button on
Ribbon, 104 AutoFilter drop-down
buttons, 141–142 AutoFilter feature
basic filtering, 603–605 custom filters, 609–612 Date Filters options,
605–607
Number Filters options,
607–608
overview, 603
Text Filters options, 605