968
Index
data validation examples.xlsx sample file, 939
data validation feature
adding comments to cells, 98
cell references, 574–575
creating drop-down lists, 573
criteria types, 571–572
formula examples
accepting dates by day of week, 577
accepting larger values than previous cell, 576
accepting nonduplicate entries only, 576–577
accepting only values that don’t exceed total, 578
accepting text only, 576
accepting text that begins with specific characters, 577
creating dependent lists, 578–579
overview, 575
overview, 569–570
specifying criteria, 570–571
using formulas, 574
Data Validation option, Go to Special dialog box, 76
data views, charts, 411
Database Category Functions, 920
database files, Query application, 681
Databases tab, Choose Data Source dialog box, 682
data-entry techniques
AutoComplete feature, 39
AutoCorrect feature, 40
AutoFill feature, 38–39
automatically moving the cell pointer, 37
current date or time, 42
decimal points, 38
forcing text to appear, 40
forms, 40–42
navigation keys, 37
numbers with fractions, 40
selecting a range of input cells, 38
using Ctrl+Enter, 38
Date & Time Category Functions, 920–921
date axis, Sparkline graphics, 512–513
Date category, 254
Date data type, 901
Date format category, 554
Date format, Format Cells dialog box, 46–47
DATE function
calculating holiday dates, 268
function of, 920
overview, 258
summing values based on date comparison, 305
TIME function and, 273
date functions
age calculation, 265–266
converting nondate string to date, 261–262Data Analysis dialog box, 783
Data bar conditional formatting, 4, 485
data bars
in pivot tables, 299
simple, 486–487
using instead of chart, 487
Data Bars command, Conditional Formatting drop-down list,
483
Data Bars conditional formatting feature, 237
Data bars conditional formatting rule, 482
data bars examples.xlsx sample file, 939
Data Consolidate feature, 600
Data field, database table, 698
data label
adding to chart, 415
selecting, 439
Data pane, Microsoft Query, 691, 693
data points, 407, 509
data relationships, comparing, 417
data series
3-D charts, 464–465
adding, 456–457
changing
by dragging range outline, 457–458
by editing Series formulas, 459–460
using Edit Series dialog box, 458
combination chart, 407, 465–468
data labels, 460–461
deleting, 456
displaying data tables, 468–469
doughnut chart, 429
error bars, 461–463
line chart, 423
missing data, 461
overview, 455–456
pie chart, 424
trendlines, 463–464
data source, Query applications, 682–684
Data tab
Analysis ToolPak add-in, 782
Ribbon, 11
Data Table dialog box, 339, 749
Data Table feature, 338, 437
data tables
one-input, 748–750
one-way, 338–340
overview, 747–748
two-input, 750–753
two-way, 340–341
Data Validation dialog box, 570–571, 574–57560_474877-bindex.indd 96860_474877-bindex.indd 968 3/29/10 11:48 PM3/29/10 11:48 PM