Datasheet

241
template
creating
new workbook from, 150–151
new worksheet from, 135
new, creating, 151
saving chart as, 197
text
aligning within cell, 84–85
centering across multiple columns, 61, 86–87
description of data type, 25
entering into cell, 26–27
filtering, 175
formatting within cell, 84–85
label
adding to chart, 191
columns (See title, column)
creating range name based on, 68–69
rows (See title, row)
replacing in worksheet, 158–159
rotating within cell, 88–89
searching worksheet for, 156–157
ways to view without wrapping, 107
wrapping within cell, 106–107
theme, workbook, 79, 82, 90, 168–169
Tiled workbook view mode, 154, 155
time and date
description of data type, 25
entering into cell, 30–31
filtering, 175
formatting options, 30, 31
title
chart
adding to axis, 190
adding to chart, 190
defined, 186
formatting, 200–203
column
creating range names based on, 68–69
freezing, 58–59
unfreezing, 59
data label, 191
range name
adding to formula, 64, 124–125
Apply Names feature, 125
basing on text label, 68–69
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
spreadsheet overview, 2, 4–5. See also worksheet
Start menu, Windows, 6–7
starting
cell for editing, 34, 35
Excel Options dialog box, 21
Excel program, 6–7
new worksheet, 134–135
workbook, 153
statistical function, 117
status bar
defined, 8
displaying sum of selected range, 5, 123
Edit indicator, 34
STDEV function, 117
STDEVP function, 117
stock chart, defined, 187
strikethrough, applying font effect, 80–81
style
customizing for worksheet data, 101
deleting style effect from chart, 209
for formatting tabular data, 101
predefined
applying to chart, 195, 208–209
applying to worksheet, 100–101
removing effect from chart, 209
subgalleries, 11
subscript, applying font effect, 80–81
subtotal, summarizing data by using, 182–183
subtraction operator (-), 4, 113
Sum button, 5, 122–123
SUM function, 120–121, 122, 123. See also AutoSum feature
summarizing data, 182–183
superscript, applying font effect, 80–81
surface chart, defined, 187
symbol, nonkeyboard, inserting, 32–33
T
tab, Ribbon, 14–15
tab, worksheet
defined, 24
renaming, 133
table, data
comparison with Excel table, 180
creating for use with formula, 180–181
defined, 180
displaying in chart, 194
table, Excel
adding record to, 179
assigning name to table data, 69
comparison with data table, 180
converting
back to range, 179
range to, 178–179
defined, 178
formatting tabular data, 101
in spreadsheet, described, 5
tabular data, formatting, 96, 101
taskbar, Windows 7, adding Excel icon to, 7
16_577639-bindex.indd 24116_577639-bindex.indd 241 3/15/10 2:49 PM3/15/10 2:49 PM