G

galleries

chart templates, 632

chart types, 617–618, 620

gradient fill colors, 640

PivotTable styles, 723

Shape Styles, 629–631

table styles, 709

WordArt, 629–631

GAMMADIST function, 964

GAMMAINV function, 964

GAMMALN function, 964

GCD function, 964

General format, 298

GEOMEAN function, 964

GESTEP function, 964

GETPIVOTDATA function, 964

getting around. See navigating

glowing effects, 370, 371, 631

Go To commands, 132–136, 294, 452

Goal Seek feature, 599–601, 821

 Goal Seek.xlsx file, 583

good news cell styles, 279

government compliance, 821

gradient fills

applying, 376–377

chart styles, 620

in charts, 636, 638–640

gradient stops, 377, 640

Shape Styles feature, 631

gradient lines in charts, 636

gradient stops, 377, 640

grand totals, 724–725

Graph application, 900

graphics. See also shapes; SmartArt feature

3-D effects, 378–381

aligning and snapping into place, 391–393

alt text tags, 391

assigning macros to, 394–395

backgrounds, formatting, 333–334

borders, 370

capturing worksheet images, 395–398

in charts, 640–641

clip art, 362–364

compressing, 373–374

copying worksheet portions as, 397–398

cropping, 370

displaying, 388, 393

dpi resolution, 373

dragging into Excel, 641

editing, 210

embedding, 366–368, 895

examples of, 398–401

filling shapes with, 377

formatting, 333–334, 368–386

formatting text in, 371–373

grouping, 386–387

in headers or footers, 410, 411–412

hiding, 388, 393

hyperlinks in, 879

hyperlinks to, 873–874

importing, 365–366

inserting, 362–368

media files, 362–364

moving and positioning, 387–393

new and changed features, 5–6

nonprinting, 390

pasted charts in Word, 900–901

pasted tables in Word, 892, 895

&[Picture] code, 411

Picture format, 894, 895–896

Picture Tools tab commands and options, 911

protecting and locking, 393–394

reshaping, 369

responding to worksheet changes, 388–390

rotating, 380

selecting, 349, 386–387

selecting text in, 384

shadows, 377–378

Shapes tools, 345–356

SmartArt, 358–362

switching, 369

text in, 353, 382–384

tiling, 640, 641

WordArt, 356–358

 Graphics Gallery.xlsx file, 398

Greater Than filtering, 687–688

greater than operator (>), 458, 478

greater than or equal to operator (> =), 478

green triangles in formulas, 201

gridlines

accessibility, 96, 98, 100

charts, 619, 628, 646

color, 100

drawing shapes to match, 348

printing, 414–415

snapping objects to, 392

grids, snapping objects to, 392

group editing. See collaboration

grouping

columns and rows, 257–258

filling grouped objects, 241

graphics, 386–387

keyboard shortcuts, 931, 944

macros and, 395

PivotTable data, 737–741

records in Query, 776

worksheets for editing, 237–239

GROWTH function, 567, 964

growth in AutoFill feature, 216

guess argument, 536, 541

guess functionality, 604