Datasheet

377377
Index
Current Data button, 192
Current Time button, 192
cursor, cell, 23–25, 103
custom  ltering, 336–340
custom series, AutoFill feature, 76–77
Cut command, 161
• D •
data bar, 141–142
data entry. See entry
data list
about this book, 4
adding records to, 321–325
calculated  eld entry, 321
clearing  elds in, 325
creating new, 319–320
data form, 322–323
date  eld, 324
date  lter, 336
deleting  elds in, 325
editing records in, 324–325
external data query, 340
 ltering record in, 333–340
 nding records in, 326–329
moving through the records in, 325–326
number  lter, 335–336
sorting records in, 329–332
zip code  eld, 324
Data menu command, Excel 2003 and 2010
equivalent, 38–39
data table
adding to chart, 292
adding worksheet data to, 292
description of, 255
one-variable, 256–258
positioning, 292
two-variable, 259–261
What-If-Analysis feature, 255–258, 260–261
database. See data list
date
built-in format, 60
date system, 61
elapsed days between, 120–121
entered as text, 59
entered as value, 59
footer, 192
header, 192
month abbreviation, 60
number format, 120–121
21st Century, 61
date  eld, 324
date  lter, 336
Date number format, 120–121
decimal place
converting to percentage, 117
entering numeric value with, 56–57
Fixed Decimal feature, 57–59
ten-key method to, 58–59
Decrease Decimal button, 111
Decrease Font Size button, 42, 109
Decrease Indent button, 110, 128
degrees, 133
Delete dialog box, 168
Delete keystroke, 70
deleting
column, 168–169
comment, 213
data list  eld, 325
print title, 187
range of cells, 167–168
row, 168–169
text box, 301
worksheet, 233–235
descending sort order, 330
Developer tab, 16
dictionary, 170
dictionary language, 171
directional icon, 142
Divide option (Paste Special dialog
box), 166
division (/) operator, 62
#DIV/0! error value, 67
Document Recovery task pane, 93
does not end with operator, 338
does not equal operator, 337
dollar sign ($), 56
down sort order, 330
drag-and-drop technique
copying cell range with, 155
inserting cell range with, 156
moving cell range with, 153–154
moving worksheet between workbook,
246–247
moving worksheet location, 236–238
25_489536-bindex.indd 37725_489536-bindex.indd 377 3/23/10 7:56 PM3/23/10 7:56 PM