Excel 2010 Made Simple

Index

A

absolute cell addressing

keeping cell reference constant, 90–93

Accounting Number Format option

turning values into currency, 129

adding worksheets, 263–264

addressing cells, 2

relative cell addressing, formulas, 88

alignment

data in cells, 39–40, 114–121

data orientation, 116–118

Format Cell Alignment option, 117

horizontal alignment, 114–115

indenting data, 119

Merge and Center options, 120–121

vertical alignment, 115–116

wrapping text, 119

Alignment button group, fonts, 114

Alignment tab, Format Cells dialog, 117

Alt key

additional shortcut keys, 24–25

function key shortcuts, 21–22

key tips, 5

Analyze tab, Chart Tools

filtering data ...