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

754 Excel 2013 All-In-One For Dummies
editing (continued)
records in data forms, 584 Redo command, 191–193 Replace feature, 219–221 Research pane, 225, 226 scenarios, 655
sources of data for
charts, 526–528 Spell Check feature,
222–225
text in text boxes, 565 Text to Speech feature,
228–230
Thesaurus, 225 Translation option, 226 Undo command, 191–193 Zoom feature, 199–201
Editing Formatting Rule dialog box, 181
editing options, Excel Options dialog box, 55, 56–57
EFFECT function, 387 effects
for chart titles, 537–538 for charts, 530
for text boxes, 564 themes, 573
elapsed dates, formulas for, 363
elapsed time, formulas for, 363–364
Eliminate Duplicates feature, 586–587
e-mail, 456, 458, 490–492, 494
embedded charts, 82, 518, 544
embedding data in other programs
overview, 500
in PowerPoint, 506–507 in Word, 501
Emoticon key, Touch keyboard, 95
Enable Background Error Checking check
box, 355
Enable Iterative Calculation
option, Excel Options
dialog box, 49
Enable Live Preview check
box, 46
Encrypt Document dialog
box, 437, 439–440 Enter button on Formula
bar, 93 Enter key, 93, 95
EOMONTH function, 369 equal sign (=), 87, 300 Error Checking feature
default settings for, 50 general discussion, 353–355 options for, 355–356 overview, 348
Text to Speech feature,
228–230
Trace Error option, 356–358
error trapping. See also formula auditing
error values, 339–340 general discussion, 342–346 logical functions, 341–342 overview, 339
removing errors from
printouts, 360 whiting-out errors with
conditional formatting,
346–347
error values, 339–340, 354 errors in formulas, 301 Euro Currency tools
add-in, 69, 70 EUROCONVERT function, 70 European calculation
method, 368
European date system, 362 Evaluate Formula feature,
348, 354, 358–359
even and odd pages, alternating headers and footers for, 292
EVEN function, 393 Evolutionary method, 665 Excel 97-2003 Workbook file
format, 119, 121–122 Excel add-ins, 68, 70
Excel Binary Workbook file
format, 119
Excel Help window, 34–35 Excel Macro-Enabled
Template file
format, 120 Excel Macro-Enabled
Workbook file format,
119
Excel Mobile Viewer, 499 Excel Options dialog box.
See also Advanced tab, Excel Options dialog box
Add-Ins tab, 69–70 Customize Ribbon tab,
61–66
Formulas tab, 48–50,
355–356
General tab, 45–48, 251 overview, 45
Proofing tab, 50–52,
223–224
Quick Access Toolbar
tab, 42, 43–44 Save tab, 52–54
Excel program window Account screen, 20 Backstage view, 17–18 closing, 39
components, 16–17
File menu options, 19–20 Formula bar, 27–28
Help window, 34–35 Quick Access toolbar,
26–27