Page 294 - Excel Data Analysis

18 537547 Index.qxd 3/4/03 11:54 AM Page 280

INDEX

Numbers & Symbols A

& (ampersand) absolute cell references, 164, 273
concatenation operator, 162, 270 accessories. See add-ins
menu shortcuts, 189 Acrobat Reader (on the CD), 274, 277
* (asterisk), wildcard character Add Scenario dialog box, 54–55
in data list filters, 50 Add Trendline dialog box, 115
in value searches, 6, 77 add-ins, 214–215
= (equal sign) Advanced Filter dialog box, 52–53
comparison operator, data list filters, 53 advanced filters, 52–53
comparison operator, Solver constraints, 67 alignment, cell data, 4
in formulas, 5 amortization tables, 82–83
! (exclamation mark), in worksheet names, 38 ampersand (&)
> (greater than), comparison operator concatenation operator, 162, 270
data list filters, 53 menu shortcuts, 189
Solver constraints, 67 AM/PM indicator, 17
< (less than), comparison operator Analyse-It (on the CD), 275
data list filters, 53 analysis of variance (ANOVA), 220–221
Solver constraints, 67 Analysis ToolPak, 214
- (minus sign), hidden record indicator, 40–41 ANOVA, 220–221
+ (plus sign) apostrophe. See single quote
hidden record indicator, 40–41 application events, 266–267
VBA concatenation operator, 162 Apply Names dialog box, 9
? (question mark), wildcard character area charts, 108
in data list filters, 50 arithmetic operators, 161, 270
in value searches, 6, 77 array form, 75, 78
' (single quote) array functions (VBA), quick reference, 259
fraction indicator, 4 arrays, VBA, 160
numeric text indicator, 4 Arrow button, 196–197
VBA comment indicator, 173 arrows, formula evaluation, 65, 72
in worksheet locations, 122 asterisk (*), wildcard character
in worksheet names, 38 in data list filters, 50
[ ] (square brackets), specify worksheet locations, 122 in value searches, 6, 77
% Difference From option, 131 Auto Outline command, 40–41
##### message, 273 autoformat, 18–19. See also formats; named styles
% of column option, 131 AutoFormat dialog box, 18–19
% Of option, 131 AutoSum button, 58–59
% of row option, 131 AVERAGE function, 231
% of Total option, 131 Average function, 37, 59
0 (zero), fraction indicator, 4 averages
3D charts, 109, 118 AutoSum function, 59
4TOPS Data Analysis (on the CD), 275 consolidated data, 37
24-hour clock, 5 DAVERAGE function, 102–103
1900 date system, 5 imported values, 102–103
1904 date system, 5 means, 227, 229
MEDIAN function, 81

280