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

Index 753
destination area, 262, 267 destinations for
hyperlinks, 456 Developer tab, adding to
Ribbon, 24, 711, 722 DGET function, 621 Diagram View, PowerPivot
add-in, 699–701 Dialog Box launcher,
Ribbon, 21 dictionary languages, 52 Different First Page check
box, 290–291
Different Odd & Even Pages
check box, 292 digital ink, marking up with, 486–488
digital signatures, 18, 465–470, 716–718
digital stamps, 470
direct dependents, 347 direct precedents, tracing,
347, 349–352
Disable All Macros except
Digitally Signed Macros
option, 717–718 Disable All Macros with
Notification option, 717 Disable All Macros without
Notification option, 717 DISC function, 386
display, default settings
for, 55
display options, Excel
Options dialog box,
57–59
Display tab, PivotTable
Options dialog box, 692 Distributed alignment
option, 158, 159
Divide option, Paste Special
dialog box, 214 DMAX function, 621
DMIN function, 621 E Document Inspector, 464
Document panel, 19 Document Recovery feature, 122–123
Documents button, Open dialog box, 188
dollar sign ($), 89, 153, 318 DOLLARDE function, 386 DOLLARFR function, 386 double-declining balance
depreciation,
calculating, 383–385 double-sided printing,
270, 292 doughnut charts,
inserting, 520 downloading
graphics from Web, 556–557
templates, 77–79 DPRODUCT function, 621 draft-quality setting, 544 drag-and-drop technique,
206–207, 259, 461,
501–503
Drill Down/Up buttons, 676 DSTDEV function, 621 DSTDEVP function, 621 DSUM function, 621–622 duplicate records, deleting,
586–587
Duplicate Values Columns
dialog box, 179–180 duplicates
removing from data tables, 641
of values in cell ranges, highlighting, 179–180
DURATION function, 386 DVAR function, 621 DVARP function, 621
EDATE function, 368–369 Edit Hyperlink dialog
box, 460
Edit Name dialog box, 330 Edit Scenario dialog
box, 655
Edit Shape option, 564 editing. See also collective
editing; copying array formulas, 323 cell editing, 190–191 cell ranges, enabling in
protected files, 445–450 chart titles, 534–535 clearing cells, 194–196 comments, 485–486 Custom Views feature,
204–205
Data Validation feature,
226–228 embedded data in
PowerPoint, 507 embedded data in
Word, 504
Find feature, 216–219 formulas, 301–302 Freeze Panes feature,
201–204
hyperlinks, 460–461 inserting cells, 196–198 linked data in Word,
505–506
moving data, 206, 207,
208–211
online workbooks,
496–499
overview, 183
pictures, 558
in protected worksheets,
enabling, 443 range names, 330