Page 358 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 341
Index 341
preventing errors in with data validation, 312 date number format, 28
in a protected worksheet, 227–228 DB function (declining balance), 121–123
restricting, 312 DDB function (double–declining balance),
shortcut keys for, 317 121–123
verifying with Text to Speech, 58–59 decimal buttons, 26
data form decimal places versus rounding functions, 125
constructing a new data list and adding records decision-making formulas
with the, 204–206 alternate calculations in, 153–155
criteria button on the, 206 alternate values in, 150–153
editing field entries on data lists with the, building, 150–156
205–206 types of, 150
finding and editing records with the, 206–207 default
data list. See also database table alignment in worksheets, 16
client, 203–204 of number formats, 28
constructing new and adding records with the print settings, 42
data form on the, 204–205 printing of charts, 45
creating a, 203–207 Default optional argument (InputBox), 297
creating a Web page with an interactive, 266–267 Define Name dialog box, 77–78, 311
editing field entries on (using the data form), Delete key, 60, 321
205–206 deleting
filtering a, 213–216 custom button, 281
filtering the records in a, 214–216 custom menu item, 281
sort order, 207 data and cells, 60–61
sorting, 207–211 a hyperlink, 279
sorting on the records in a data list on more dependents, 102
than three keys, 209 depreciation, 121–123
subtotaling the records in a, 211–212 desktop Microsoft Excel icon, 9
using AutoFilter in a, 213–216 dialog box. See also specific dialog box
data marker, 172 making a recorded macro interactive by adding
data series creation with AutoFill, 310–311 an input, 297–299
data table selections, 1
creating a one-variable, 233–235 digital photo insertion, 193
creating a two-variable, 236–237 direct precedents, 102
creating a Web page with an interactive, 265–266 display controlled by outlining data tables, 314
outlining to control display of data, 314 #DIV/0! error value, 73, 77, 156, 313
overview, 233 division operator (/)
placement of formulas in a two-variable, 236 precedence of, 82
querying an external, 216–220 used in formulas, 74, 76
data validation docking a floating toolbar, 65
for a cell, 312 dollar sign ($) used in formulas, 19
defined, 152 downloading templates from Microsoft Office
preventing data entry errors with, 312 Templates Home Page, 309
Data Validation dialog box, 312 drag-and-drop
database table. See also data list method, 315
querying an external, 216–220 to move/copy data, 61
selecting a driver for a, 216 Drawing toolbar
date formulas creating text boxes with the, 196–198
building, 107–109 drawing/adding graphic shapes with, 194–196
overview, 107 overview, 186, 189
date functions WordArt and the, 198–200
building formulas with in the Analysis ToolPak,
111–112
building formulas with, 109–110
working with, 109–111