Datasheet

239
protecting
workbook structure, 216–217
worksheet data, 214–215
PV function, 117
Q
Quick Access Toolbar
adding command to, 12–13
customizing, 12–13
default buttons, 12
defined, 8
increasing available space on, 13
moving below Ribbon, 13
Redo button, 12
removing command from, 13
Undo button, 12, 35
quick filter, 175
quitting Microsoft Excel, 7
R
radar chart, defined, 187
range
adding
background color, 90–91
border, 108–109
adding up row or column using SUM function, 121
aligning text within cells, 84–85
applying style, 100–101
changing
column width, 102–103
font and font characteristics, 78–83
name, 72–73
row height, 104–105
converting to table, 178–179
copying, 46, 47
defined, 24, 38
deleting, 54–55
data and formatting from range, 52, 53
data in range but not formatting, 52–53
range name, 74–75
existing, inserting new cell into, 50–51
filling
AutoFill feature, 44
by creating custom AutoFill list, 45
customized series of values, 45
same data, 42–43
series of data values, 44–45
standard series of values, 5, 44–45
without copying original cell’s formatting, 43
filtering, 174–175
formatting, 76–109
locking and unlocking, 214–215
moving, 46, 47
naming, 64–69
protecting data, 214–215
rectangular, 40
referencing
in another workbook, 127
in another worksheet, 126–127
Excel program, 6–7
new worksheet, 134–135
workbook, 153
operand
in Excel formula, 112
function as, 116–117
operators
arithmetic, 113
in comparison formula, 113
defined, 112
order of precedence, 113
symbol, nonkeyboard, inserting, 32–33
orientation, rotating text within cell, 88–89
outline (border)
adding to cells and ranges, 108–109
custom, creating, 109
selecting line style, 109
P
page break, previewing, 18, 19
Page Layout view, 18
parentheses, and operator precedence, 113
password-protecting worksheet, 214–215
pasting
copying
cell, using smart tag, 16–17
formula, 128, 129
range, 46, 47
worksheet, 138–139
moving
formula, 128
range, 46, 47
worksheet, 136–137
PDF file, creating from workbook, 225
percentage
applying number format, 93
entering directly into cell, 29
percentage operator (%), 113
picture, as chart element background, 203
pie chart, defined, 187
pinning Excel icon to Windows 7 taskbar, 7
plot area
defined, 186
formatting, 200–203
plus sign (+), 113
PMT function, 4, 116, 117, 119
point, data
in chart data table, 194
defined, 186
labeling, 191
pop-up help, 21
positioning chart legend, 192
PPMT function, 117
preview
enabling Live Preview feature, 11
page break, 18, 19
turning Live Preview feature off, 11
16_577639-bindex.indd 23916_577639-bindex.indd 239 3/15/10 2:49 PM3/15/10 2:49 PM