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

Index
Symbols and
Numerics
- (dashes), in cell entries, 86 # symbol, 153, 339
##### (pound signs), 135 #DIV/0 error value, 340,
343–345
#N/A error value, 340
#NA error value, 347 #NAME! error value, 330 #NAME? error value, 340 #NULL! error value, 340 #NUM! error value, 340, 395 #REF! error value, 233, 340 #VALUE! error value,
340, 419
$ (dollar sign), 89, 153, 318 % (percent sign), 89, 153
* (asterisk) wildcard, 217,
263, 406, 614
. (periods), 89, 100 ? (question mark)
in number format codes, 153
wildcard, 217, 263, 406, 614
@ symbol, 87
@@ sign, 300
+ (plus sign), 88
= (equal sign), 87, 300
’ (apostrophes), in cell
entries, 86 , (commas), 89
0, in number format codes, 153
1900 date system, 89 1904 date system, 60, 89
A
abbreviations, replacing with full text, 98
ABS function, 395 absolute cell references,
315–318
Accept or Reject Changes
dialog box, 481–482 Access, Microsoft,
importing data from,
623, 624–626 accessibility, 18, 464 Account command, File
menu, 20
Account screen, 20 Accounting Number Format
button, 147
ACCRINT function, 385 ACCRINTM function, 385 Actions, 489
Actions option, 51
Activate dialog box, 33, 249 active cells, 127
Active Field option, 676 Add Constraint dialog
box, 662
Add option, Paste Special
dialog box, 214 Add Printer link, Print
screen, 272
Add Scenario dialog box,
652–653
Add to Dictionary button,
Spelling dialog box, 223 Add View dialog box, 247 adding worksheets, 251–252 add-ins. See also
PowerPivot add-in;
Solver add-in COM, 71
Excel, 70
general discussion, 68–70 overview, 41
Power View, 703–705 purchasing third-party, 71
Add-Ins dialog box, 69, 70, 743–744
Add-Ins tab, Excel Options dialog box, 69–70
Add-Ins.com website, 71 ADDRESS function, 417 advanced filtering
calculated criteria, setting up, 617–619
AND functions, using in calculated criteria, 619
general discussion, 612–614
logical AND conditions, setting up, 615–617 logical OR conditions, setting up, 615–617 OR functions, using in
calculated criteria, 619 overview, 603
specifying comparison
criteria, 614–615 Unique Records Only
option, 613 Advanced tab, Excel
Options dialog box Data options, 60–61 display options, 57–59 Formulas section, 59–60 general discussion, 54–55 General section, 59–60 Lotus compatibility, 61 When Calculating This
Workbook section,
59–60 worksheet editing
options, 56–57 Alert dialog box, 301