Download Wiley Excel 2003 Visual Encyclopedia

Transcript
Index
Format Picture dialog box, 134
format styles, 8
Formatting toolbar, 50
Formula Auditing toolbar, 4, 37, 84
Formula bar, 65
formulas
about, 392
absolute references, 212, 393
construct, 214–215
construct arguments, 394
copy, 216
functions, 394–395
operator precedence, 390
operators, 391, 392
problems, 393
reference cells, 393
reference cells from other worksheets, 217
relative references, 213, 393
structure, 392
freeze
cells, 218–219
panes, 218
Freeze command, 38
Freeze Panes, 38
Freeze Panes command, 73
Full Screen view, 83
full screen view, 350
functions
about, 39
build, 220–223
Data Analysis tools, 92–93
edit, 223
formulas, 394–395
G
GIF files, 59
go to
navigate cell or range, 224–225
ranges, 301
Go To box, 51
Go To command, 40
Go To dialog box, 40
Go To Special dialog box, 40
Goal Seek tool, 41, 94, 226–227
Greek symbols, 76
group objects, 258
toolbars, 341
worksheet gridlines, 384
worksheets, 379
Highlight Changes dialog box, 80
Horizontal alignment, 3
hostname, 383
HTML file format, 69
hyperlinks
about, 44
delete, 231
edit, 231
insert, 230–231
I
import data, 232
Import External Data command, 45
Increase Decimal command, 25
increase decimal points, 182–183
Increase Indent button, 46
Indent, 46
indents
data, 234–235
Format Cells dialog box, 235
Quick indent, 234
insert
cell comments, 144–145
diagrams, 186–187
hyperlinks, 230–231
organization charts, 264–265
page break, print, 286
picture files, 272–273
special characters, 330–331
symbols, 330–331
WordArt, 362–363
Insert Clip Art button, 16
Insert Diagram button, 26, 54
Insert dialog box, 13
Insert Function dialog box, 39
Insert Hyperlink command, 44
Insert menu
columns, 17
rows, 68
Insert Object dialog box, 48
Insert Picture dialog box, 59
install add-ins, 2, 90–91
Internet Options dialog box, 387–388
Italic command, 47
italic formatting, 206–207
H
Header/Footer tab, 56
headers, 42
Help files, 93
Help pane, 43
Help tool, 228–229
Help tools, 43
hide
columns, 17, 142
rows, 306
Taskbar, 380
406
J
JPEG files, 59
JPG files, 59
justify cell data, 97
K
keyboard shortcuts, 396–397