Page 355 - Excel Workbook for Dummies

43_798452 bindex.qxp 3/13/06 7:42 PM Page 338
338 Excel Workbook For Dummies
alternate values, 151–153 AVERAGE function
ampersand (&), 280, 291 building formulas with the, 136
Analysis ToolPak types of number values and the, 136
date functions added with the, 110–111 used to compute averages, 135–136
financial functions in the, 115–116 used when subtotaling in data lists, 211–212
overview, 109–111 versus SUM/COUNT function, 135
using statistical functions in the, 139–140 averages calculations, 135–136
AND function, 149 axis (horizontal/vertical), 173
Apply Names dialog box, 98, 311
arithmetic formulas, 76 • B •
arithmetic operators, 74
array constant, 99 Backspace key, 321
array formulas Basic tab on the File Search dialog box, 51
advantages of, 100 bold button, 26
building, 99–101 BONUS icon, 5
defined, 313 book
key combination for, 101 how to use this, 1–2
versus normal formulas, 313–314 organization of this, 3–4
array range, 99 borders
arrays (one-/two-dimensional), 99 button, 26
arrow keys cell, 27
as data entry shortcut keys, 317 of text boxes, 197
moving the cell cursor with the, 12 built-in functions combined with handmade
used to enter data, 16 formulas, 80
Assign Macro dialog box, 291
asterisk (*)
precedence of, 82 • C •
used in AutoFilter, 214
used with Find and Replace, 67 calculated field added to a pivot table, 253–254
used in formulas, 74, 76 calculations (alternate), 153–155
attached text, 173 callouts
attributes modification on custom headers/ and AutoShape, 195
footers, 41 inserting, 195
Auto Outline, 181 capitalization, 164–167
AutoFill CD
copying data with, 19 copying Excel Workbook folder from the, 5
copying a formula with, 20 customer care information for, 328
creating a data series with, 310–311 Excel Workbook folder on the, 4–5
feature, 18–19 installing, 325–326
AutoFilter, 213–216 license agreement for the, 326
AutoFit practice files on the, 327–328
modifying row height with, 25–26 system requirements, 325
overview, 25 third-party add-ins on, 326. See also installing
resizing columns with, 24 CD files
AutoFormat third-party software on, 326–327. See also
formatting a table with, 32–33 installing CD files
overview, 31 troubleshooting, 328
AutoFormat dialog box, 32–33, 246–247 using the practice material on the, 4–5
automatic launch (Excel), 10 cell cursor
AutoSelect, 56–57 manipulation of the, 16
AutoShapes, 195 moving to a new area of the worksheet, 12–13
AutoSum moving within the displayed area, 12
building formulas with, 80–81 saving the position of the, 20
button on Standard toolbar, 128