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