Page 354 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:41 PM Page 337

Index

• Symbols • <> (not equal to)
precedence of, 82
& (ampersand), 280, 291 used on data forms, 206
* (asterisk) used in formulas, 74
precedence of, 82 % (percent)
used in AutoFilter, 214 precedence of, 82
used with Find and Replace, 67 used in formulas, 74
used in formulas, 74, 76 + (plus sign)
: (colon) precedence of, 82
used in cell ranges, 15 used in formulas, 74
used in formulas, 74 ### (pound sign) displayed in cells, 24
, (comma) used in formulas, 75 ? (question mark)
& (concatenation) used in AutoFilter, 214
precedence of, 82 used with Find and Replace, 67
as a text operator, 138
used in formulas, 74 • A •
/ (division)
ABS function, 127–128
precedence of, 82
absolute cell references for copying formulas,
used in formulas, 76
91–92
$ (dollar sign) used in formulas, 19
accounting number format, 28
= (equal to)
active worksheet printing, 44
used on data forms, 206
Add Constraint dialog box (Solver), 243
used in formulas, 73–74
add-in
^ (exponentiation)
programs, 110, 241–243
precedence of, 82
saving a custom function as an Excel, 303–305
used in formulas, 74, 76
Solver program, 241–243
> (greater than)
Add-Ins dialog box
precedence of, 82
activating add-in programs with the, 110–112
used on data forms, 206
activating Analysis ToolPak on the, 139
used in formulas, 74
using to add Solver, 242
>= (greater than or equal to)
Add Scenario dialog box, 238
precedence of, 82
addition operator (+)
used on data forms, 206
in formulas, 74
used in formulas, 74
precedence of, 82
< (less than)
Adjust To option, 43
precedence of, 82
Advanced tab on the File Search dialog box, 51
used on data forms, 206
alignment
used in formulas, 74
button, 26
<= (less than or equal to)
default, 16
precedence of, 82
tab on the Format Cells dialog box, 28, 30–31
used on data forms, 206
Alt key. See also key combinations
used in formulas, 74
shortcut key combinations using the, 317, 319,
- (minus sign/negation)
323
precedence of, 82
alternate calculations
used in formulas, 74, 76
building formulas that perform, 154–155
IF function and, 153–155