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

Index 747
Top Ten option, 608–609 for values with conditional
formatting, 609 AutoFit Selection
command, 136 AutoFormat As You Type
option, 51
Automatic calculation, 48,
335, 336 Automatic except Data
Tables calculation, 48,
335, 336
automatic scaling, 664 Automatic Styles check
box, Settings dialog
box, 240, 241 AutoRecover feature
default settings for, 53 general discussion,
122–123
opening versions of
files, 190
overview, 19
unsaved versions, options
for, 464–465
AutoSelect feature, 130–132 AutoSum feature, 302–304 AVERAGE function, 400 Avoco secure2trust, 466 axis, 516, 538–541
axis labels, modifying,
540–541
Axis Position option for
chart axes, 540
Axis Type option for chart
axes, 540
B
Back button, 18 background, removing from
pictures, 559, 560 Background button, 278
background error checking, 50, 355
background images, adding, 250–251
background of title bar, changing, 20, 47
Backspace key, Touch keyboard, 95
Backstage view. See also Info screen; Print screen; Share screen
accessing, 17–18 Account screen, 20 exiting, 18
File menu options, 19–20 Open screen in, 184–187 overview, 13
Banded Columns option, 678
Banded Rows option, 678 bar charts, inserting, 519 Bing search engine,
downloading images
with, 556–557
black and white, printing
charts in, 544
blank cells, flagging, 356 Blank Rows option, 677 Blank Workbook template,
75, 76
Blank Workbook thumbnail,
Start Screen, 15
blank workbooks, opening,
84–85
bold formatting, 144, 563 Border tab, Format Cells
dialog box, 166 borders, 145, 164–166 Bottom alignment option,
145, 158
Bounds option for chart
axes, 538 Breaks button, 278
Bring Forward option, 531, 549, 550
Bring to Front option, 550 Browser View Options
button, Info screen,
19, 465
browsers, web. See web
browsers
browsing for workbook
files, 184
bubble charts, inserting, 520
C
calculated columns, adding with DAX, 701–703 calculated criteria, setting
up, 617–619 calculated fields, creating,
579–580, 690–691 calculating values for cells
used in formulas, 302 Calculation options, Excel
Options dialog box, 48,
335–336 canceling print jobs,
276–277 capitalization functions,
425–427 Cascade window
arrangements, 257 Categories in Reverse
Order option for chart
axes, 540
category, consolidation by,
266–267
CEILING function, 394 CEILING.MATH function,
393–394
cell addresses, 27, 28, 300 Cell contents section,
Formula bar, 27, 28 cell cursors, 29–30, 57