B


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

image from book 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




Microsoft Office Excel 2007 Inside Out
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net