Download Wiley Excel 2003 Visual Encyclopedia
Transcript
E e-mail about, 28 attachments, 28 worksheets, 192–193 edit database records, 176–177 functions, 223 hyperlinks, 231 Edit menu Copy, 20 Cut command, 24 paste, 57 Edit Web Query dialog box, 259 elements, chart, 389 Embed command, 29 embed objects in worksheet, 194–195 embedded Uniform Resource Locators (URLs), 44 encyclopedia, 66 equal sign, 39 Equal To option, 94 erase border lines, 117 Error Checking feature, 4, 196–197 errors checking, 98–101 checking tools, 4 fix, 196 messages, 99 Remove Precedents button, 100 trace, 197 Trace Error button, 101 Trace Precedents button, 100 Evaluate Formula button, 101 Evaluate Formula dialog box, 101 EVEN functions, 183 Expand button, 75 export about, 30 data, 233 F fields, 42 file formats about, 69 export, 30 pictures, 59 File menu, print, 63 files properties, 64 save to default location, 308–309 fill about, 31 Drawing toolbar, 27 Fill Color, 31 fill color, formatting, 208 Fill Color button, 31 filter data, 7 database data, AutoFilter, 106–107 database records, 178–179 find add-ins, 91 data, 198 Find and Replace dialog box, 32, 198–199 Find tool about, 32 find data, 198 replace data, 199 fix errors, 196 flip objects, 263 Font button, 33 Font Color command, 34 Font Size buttons, 34 Font tab, 11 fonts about, 33 sizes, 34 footers, 42 force-quit application, Task Manager, 379 format 3-D effects, 211 apply cell formatting, 200–203 apply conditional, 204–205 arrows, 208–211 bold, 11, 206–207 chart elements, 130–131 copy, 36 dash style, 209 fill color, 208 Format Cells dialog box, 200–203 Format dialog box, 211 italic, 206–207 line color, 208 line style, 209 lines, 208–211 objects, 257 Percent Style, 57 pictures, 270–271 shadow effect, 210 shapes, 208–211 Style dialog box, 74 underline, 206–207 Underline button, 81 Format Axis dialog box, 120 Format Cells dialog box about, 3 Bold, 11 Borders, 12 Currency Style, 21 decimals, 25 Fill Color, 31 Font Color command, 34 Font Size buttons, 34 fonts, 33 formatting, 200–203 indents, 46, 235 italics, 47 Merge and Center command, 50 Percent Style, 57 underlining, 81 Format dialog box, 211 Format menu columns, 17 rows, 68 Format Painter, 36 405