rows/columns, 86
worksheets
conditional formatting, 91-94
freezing rows/columns, 78-80
page setup options, 87-89
formulas, 29. See also functions
copying/pasting, 31-36
defined, 27
editing, 24
error-checking, 14
functions in, 20, 27-29, 62
ranges in, 53-54
setting options, 14
typing, 24
freezing rows/columns, 78-80
ftp programs, 128
Function Wizard, 67-68
functions, 29. See also formulas
for dates/times, 71-74
Function Wizard, 60-62, 67-68
list of, 63
in formulas, 62
Sum, 29-30
typing, 63-65
G
Go To dialog box, 25
grand totals. See totals
graphics
background images, changing, 89
inserting in worksheets, 113-114, 117
graphs. See charts
gridlines, printing, 89, 130
H
headers, 87
headings, centering, 84-86
hidden cell ranges, 145
Hour() function, 73
I
images. See graphics
importing
database data, 138-141
defined, 126
worksheet data, 126-128
Insert dialog box, 37
Insert Function dialog box, 67-68
Insert Picture dialog box, 113
inserting
cells, 37
clip art, 114, 117
columns, 36-37
comments in cells, 89-91
graphics, 113-114, 117
rows, 37
SmartArt, 10, 117
insertion point, 25
integers, 60
integrity of data. See data integrity
Internet-based worksheets, referencing, 70
J-K-L
justification, 24
keyboard shortcuts, 26
154
formatting

Get Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.