Microsoft Office Professional 2010 Step by Step eBook

(Ben Green) #1
forwarding tasks, 733
framing pictures, 926
French dictionary, 412
freezing fields, 807
frequently misspelled words, correcting, 88
From button, 614
full name. See user name
Full Page View button (OneNote), 533-534
Full Screen Reading button, 56
Full Screen Reading view, 52, 56
Function Arguments dialog box (Excel), 296-297
functions
adding to formulas, 286
AGGREGATE, 357, 359
arguments, 296
arguments, defined, 288
and AutoCalculate, 355
automatic recalculation of, 354
AVERAGE, 287
AVERAGEIF, 297, 298, 300
AVERAGEIFS, 297, 299
conditional, 297
constructing, 158
COUNT, 287, 297
COUNTA, 297
COUNTBLANK, 297
COUNTIF, 297
COUNTIFS, 297, 299
defined, 286
IF, 296, 360
IFERROR, 297
MAX, 287
MIN, 287
multiple criteria in, 299
NOW(), 287
PMT(), 287
RAND, 354, 360
RANDBETWEEN, 354
SUBTOTAL, 355
SUM, 287, 295
SUMIF, 297
SUMIFS, 297, 299, 300
volatile, 354
funnel icon in filter arrow, 350

G
galleries
closing without making selection, 13
of thumbnails, 10
GIF file format, 455
Global Address List (GAL), 648
Go To Footer button (Word), 189

Gradient gallery, 435, 915
grammar checker, 91. See also spelling, checking
graphic placeholders, 920
graphics. See building blocks; clip art; drawing
objects; images (Excel); images (OneNote);
images (PowerPoint); images (Publisher);
images (Word); shapes; SmartArt graphics
graphics file formats
BMP, 455
GIF, 455
JPEG, 455
PNG, 455
TIFF, 455
grayed-out buttons, 11
grayscale
previewing before printing in, 492
printing in, 493
Grayscale button (PowerPoint), 492
greeting cards. See cards
Greeting Line button (Publisher), 971
greeting lines, inserting, 972
gridlines (OneNote), 571
Group button (PowerPoint), 476
Group button (Publisher), 938
grouping
calendar items, 701
images, 945
OneNote sections. See section groups (OneNote)
records, 846. See also sorting records
related data, 282
shapes, 476, 932, 937-938
groups, ribbon, 7
customizing, 27
removing, 30
Grow Font button (Word), 116

H
handles, 450
around shapes, 470
Handout masters, 495
handouts
creating in Word, 501
enhanced, 501
printing, 492
handwritten notes (OneNote), 520, 567, 577
hanging indent, 120,
adjusting, 126
in columns, adjusting, 145
Header And Footer dialog box (PowerPoint), 487,
488, 493, 499
Header button (Word), 188, 216
Header & Footer button (PowerPoint), 488, 499

Header & Footer button (PowerPoint) 1001

Free download pdf