Page 207 - Excel Workbook for Dummies
P. 207

21_798452 ch15.qxp  3/13/06  7:41 PM  Page 190
                190       Part III: Working with Graphics
                                    for the type of clips you want to use. The first time that you use the Clip Art button,
                                    Excel opens the Add Clips to Gallery dialog box that prompts you to collect and cata-
                                    log all the media files on your computer system (including sound, pictures, digital
                                    movies, and Clip Art). Click the Now button to have Excel catalog your media files.
                                    When you do so, the program opens an Auto Import Settings dialog box, where you
                                    can indicate which folders to search for the media files on your computer. Once you
                                    finish indicating which folders to search, click the Catalog button to have the Microsoft
                                    Media Gallery catalog the media clips on your system.

                          Try It


                                    Exercise 15-2: Adding Clip Art to a Spreadsheet
                                    Open the Exercise15-2.xls workbook file in your Chapter 15 folder in the My Practice
                                    Spreadsheets folder on your hard disk or in the Excel Workbook folder on the work-
                                    book CD-ROM. This workbook contains the ITB Invoice worksheet with a copy of an
                                    invoice template for a store called Into the Blue that sells kites and accessories. In this
                                    exercise, you get to practice finding and adding clip art by sprucing up the otherwise
                                    dull invoice heading with an image of a kite:

                                     1. Display the Drawing toolbar by choosing View➪Toolbars➪Drawing.
                                         Excel docks the Drawing toolbar at the bottom of the Excel program window.
                                     2. Click the Insert Clip Art button on the Drawing toolbar.
                                         Excel displays the Clip Art task pane. If this is the first time you opened this task
                                         pane, the program displays the Add Clips to Gallery dialog box, which prompts
                                         you to collect and catalog all the media files on your computer system (including
                                         sound, pictures, digital movies, and Clip Art). Go ahead and have the program
                                         catalog the media files on your computer by clicking the Now button.
                                     3. Enter kites as the search text in the Search For text box at the top of the Clip Art
                                         task pane and then select the Go button.
                                         Depending upon your version of Excel, the program may locate several kite
                                         images including a single clip art image of a pink kite (which does not go very
                                         well with the blue background of the invoice header). If you have access to
                                         the Internet, go ahead and follow steps 4 to 9 to find and download other, better-
                                         suited kite images from Microsoft’s Clip Art Web site. If you don’t have Internet
                                         access, go ahead and use the pink kite image and skip ahead to step 10.
                                     4. Click the Clip Art on Office Online hyperlink near the bottom of the Clip Art task
                                         pane.
                                         Excel launches your Web browser, which goes online and opens the Microsoft
                                         Office Clip Art and Media Home Page.
                                     5. At the top of Microsoft Office Clip Art and Media Home Page, select Clip Art on
                                         the Search drop-down list and then type kite in the Search text box before select-
                                         ing its Go button.
                                         The first of eight Web pages of kite images appears.
                                     6. Search through the first few pages of kite images, selecting the check boxes for
                                         a few clip art images whose colors and kite drawing seem best suited to the
                                         background color and type style in the Into the Blue invoice header.
                                         Note that the Download link in the pane on the left of the Web page keeps tabs
                                         on the number of images you select.
                                     7. Click the Download link to open the Download page and then click the Download
                                         Now button (also, if a File Download security alert dialog box appears, click its
                                         Open button to proceed with the image downloading).
   202   203   204   205   206   207   208   209   210   211   212