Background button, 333
background refreshing, 748
backing up data. See also recovering data
automatically, 58
AutoRecover, 79–80
Dr. Office, 80–81
restoring data, 79–82
backslash (\), 142–143
Backspace key, 930
bad news cell styles, 279
BAHTTEXT function, 949
balloon callouts, 355–356
banding in tables, 668, 706, 708
bars
charts, 637
Shape Styles feature, 630
base units for chart scales, 649–651
basis in securities functions, 544
batch printing, 418
BEATINV function, 950
Begins With filtering, 688
behaviors as methods, 836
Bernoulli distribution, 575, 577
BESSELI function, 950
BESSELJ function, 950
BESSELK function, 950
BESSELY function, 950
BETADIST function, 950
Between filtering, 687–688
beveled edges, 378–380, 631
billing statements, 313
BIN2DEC function, 950
BIN2HEX function, 950
BIN2OCT function, 950
Binary Workbooks (XLSB), 830
BINOMDIST function, 951
Binomial distribution, 575, 577
bins, 570, 571, 572
bitmap images
Bitmap format, 894, 895–896
capturing portions of worksheets as, 398
compressing, 373–374
as fills, 640
inserting, 366, 886
pasting, 885
black and white printing, 416
blank cells
charting, 658
#DIV/0! errors, 587
dividing by, 696
filtering functions and, 686–687, 691
functions and, 559
in PivotTables, 723
as placeholders in formulas, 584
sorting and, 682
blank workbooks, 46
creating with hyperlinks, 873, 877–878
New Workbook dialog box, 46
blank worksheets, inserting into Word, 897–899
bold formatting, 940
bond coupons, 548
Bookmark feature, 877
Books.xlsx file, 711
Boolean logic, 507
borders
applying, 325
charts, 635–637
dotted selections, 387
embedded objects, 384, 882
formatting, 325–329, 635–637
keyboard shortcuts, 939, 940
pictures, 370
shape outlines, 369, 371
Shape Styles feature, 631
SmartArt, 360
bottom alignment, 320
bottom n items, 686
braces ({}), 458, 469, 471
brackets ([ ])
Query, 777–778
structured references, 457, 458, 704–705
time and date notations, 529
time codes, 528
[break] error, 860
break mode, 860, 862, 865, 866
breaking links to workbooks, 476
breakpoints in code, 863–864, 865
brightness of images, 369, 381
bringing shapes forward, 387–388
broken lines, 636
broken links to objects, 889
Browsed Pages list, 875–876
browsers
Excel Web Access, 820–821
launching, 876
opening files in, 65
specialized Query forms, 781
XPS-enabled, 423–424
bubbles in charts, 637
bullets in SmartArt, 360, 361
buttons
creating, 91
deleting, 94
hyperlinks and, 879
keyboard shortcuts, 942
by-name syntax, 840
by-position syntax, 841