Datasheet

380
Excel 2010 For Dummies
formatting (continued)
Values & Number Formatting (A)
option, 163
Values & Source Formatting (E) option, 163
values behind, 118–120
Formatting (R) option (Paste Options
palette), 163
Formatting toolbar, 42–43
formula. See also function
accepted cell entry as, 62
addition, 65
array, 258, 261
AutoFill feature, 157
basic entry, 62–63
entering using cell name, 215–216
error, 66–67
inserting function into, 81–83
mathematical operator, 62
method of selecting cells used in, 64–65
multiplication, 65
parentheses in, 65
printing, 198
recalculation, 64
Formula bar
basic description of, 13
button, 22
cell content section, 22
cell editing versus, 70
Enter button, 52
name box, 22
Formulas & Number Formatting (O) option
(Paste Options palette), 163
Formulas and Number Formats option
(Paste Special dialog box), 166
Formulas button (Paste Special dialog
box), 166
Formulas (F) option (Paste Options
palette), 163
Formulas tab, 16
fraction, 57
Fraction number format, 121
Freeze Pane feature, 207–209
function. See also formula
argument of, 80–81
AutoSum feature, 85–87
Average, 279
AVERAGE, 85, 278
Count, 279
COUNT, 85, 278
Count Numbers, 279
editing, 84–85
entering as formula, 81
Insert Function button, 81–84
inserting into formula, 81–83
marking end of argument, 81
Max, 279
MAX, 85
Min, 279
MIN, 85
Product, 279
recently used, 82
selection, 82–83
StdDev, 279
StdDevp, 279
SUM, 83–85, 278
typing directly in cell, 81
value, 82
Var, 279
Varp, 279
Function Arguments dialog box, 83–84
• G •
General number format, 114
glow effect, 295
Go To feature, 23, 104
Goal Seek dialog box, 261–262
gradient effect, 136–137
grand total, 271
graphic
Clip art, 302–304
grouping object, 316
hiding graphic object, 316–317
informational, 298–299
picture, 304–307
reordering layering of, 315
shape, 307–308
SmartArt, 310, 312–314
sparkline, 298–299
types of, 297–298
WordArt, 308–310
greater than (>) operator, 328
greater than or equal to (>=) operator, 328
gridline, 134
grouping graphic object, 316
growth rate percentage, 258
25_489536-bindex.indd 38025_489536-bindex.indd 380 3/23/10 7:56 PM3/23/10 7:56 PM