Datasheet
238
Index
converting
back to range, 179
range to, 178–179
defined, 178
formatting tabular data, 101
in spreadsheet, described, 5
Microsoft Windows Live
collaborating on workbooks online, 230–231
saving Excel workbooks to SkyDrive, 227
MIN function, 117
minus sign (-), 113
MODE function, 117
moving
formula, 128
range, 46, 47
worksheet, 136–137
multiplication operator (*), 113
N
Name Manager dialog box
changing range name, 72–73
deleting range name, 74–75
naming
range, 64–69
renaming
range, 72–73
worksheet, 133
worksheet, 133
navigating
between workbooks, using range name, 71
within worksheet
keyboard shortcuts and techniques, 132
range name, 70–71
between worksheets, using keyboard shortcuts and
techniques, 135
negation operator (-), 113
new worksheet, creating, 134–135
nonadjacent cells
selecting, 40
totaling, 121
Normal view, 18, 19
NPER function, 117
numbers
adding up row or column using SUM function, 120–121
decimal place in, 94–95
description of data type, 25
entering into cell, 28–29
filtering, 175
formatting in cell, 92–95
including symbol in, 29
repeating, 29
O
online workbook collaboration, 230–231
opening
cell for editing, 34, 35
Excel Options dialog box, 21
benefits, 64–65
changing, 72–73
creating, 66–67, 68–69
defined, 64
defining, 66–67
deleting, 74–75
ease of use, 64
navigating between workbooks, 71
navigating within worksheet, 70–71
row
creating range names based on, 68–69
freezing, 58–59
unfreezing, 59
text label
adding to chart, 191
creating range name based on, 68–69
worksheet, merging cells to create, 60–61
legend, chart
defined, 186
formatting, 200–203
positioning, 192
less-than operator (<), 113
less-than or equal-to operator (<=), 113
line
page break, previewing, 18, 19
wrapping text within cell, 106–107
line chart
description, 187
vertical gridlines for, 193
Live Preview feature, 11
locking and unlocking cells, 214–215
M
marker, data
defined, 186
label for, 191
mathematical symbol, inserting, 32–33
MAX function, 117
maximizing window, 155
MEDIAN function, 117
merging cells, 60–61
message, error, 177
Microsfot Windows 7
adding Excel icon to taskbar, 7
starting Microsoft Excel, 6–7
Microsoft Excel
adding icon to Windows 7 taskbar, 7
commands, 12–13, 15
description, 4–5
quitting, 7
starting, 6–7
version file format compatibility, 228–229
window, 7, 8–9
Microsoft Excel table. See also data table
adding record to, 179
assigning name to table data, 69
comparison with data table, 180
16_577639-bindex.indd 23816_577639-bindex.indd 238 3/15/10 2:49 PM3/15/10 2:49 PM