Transcript CTS130 Lesson 11 PPT

CTS130
Spreadsheet I
Lesson 11
Using Images,
Diagrams, and
Research
Inserting a Picture from File
Ways to insert a picture:

INSERT Menu > Picture > From File

“Insert Picture From File” button on the DRAW toolbar.

“Insert Picture From File” button on the PICTURE
toolbar.
Ways:
• Double-click
the image.
• Right-click
image and
select “Format
Picture”
• FORMAT Menu
> Picture
• Picture icon on
the Picture
toolbar.
Format Picture
dialog box
Picture Toolbar
- Toolbar displays when you click the picture; or
- View Menu > Toolbar > Picture
Automatic
Grayscale
Black/White
Washout
More
Brightness
and Less
Brightness
More
Contrast
and
Less
Contrast
Rotate
Tool
Crop
Tool
Compress
Tool
Line
Style
(border)
Reset
Tool
Set
Transparency
Insert a Clip Art Image

The Clipart Organizer organizes images from Microsoft
and other sources that are on your hard disk.

These images are installed on your computer or network
drive and have been cataloged so that they appear in the
Insert Clip Art task pane.

Click Install Clip Art button on Drawing toolbar. The Clip
Art task pane opens.
You can also open the task pane and then click the downpointing arrow to select the clip art option.
Clip Art
Task Pane
You may get this message
before the clip art task pane
displays.
To add the clipart to the document:
• Click the image, or
• Click and drag the image over to
document screen.
•You can also use some of the buttons on
the Picture toolbar to change the “look”
of the clipart image.
•You can change the border type, size,
and color.
•You can change the fill of a clipart if
there is white space behind it.
•You can add a shadow effect.
The term “computer”
was keyed in the
search window and
this is what displayed.
Adding an Image to a
Header or Footer
To add a header/footer image, click the Insert Picture icon.
You can click the “Format Picture” icon to change size, etc.
Saving a Web Page

You can save an Excel workbook as an HTML file so that it can be
viewed on the World Wide Web using most web browsers.

Web pages are saved with the .html file extension.

FILE MENU > Save a Web Page option

You can use the web page preview before or after you save a file
to see what your web page will look like in your browser.

When you choose web page preview, the browser on your
computer is launched and the browser displays the file.

To open it directly in your browser, go to File Menu > Open – click
the BROWSE button to locate the Excel web page.
Organization Charts


Insert Diagram or Organization Chart button
on the DRAW toolbar.
INSERT Menu > Diagram option
Once you have created an
organizational chart, you can
change the:
- font type, color, and size.
- fill type, color, and size
-border type, color, and size.
AutoFormat Tool
Use the [SHIFT] key to select multiple objects.
Click the organizational chart.
Right-click and select “Format Organizational chart”
option.
Building a Diagram



A diagram is an object that illustrates a concept.
INSERT Menu > Diagram
Insert Diagram or Organization Chart Button
Once you have created an
organizational chart, you
can change the:
- font type, color, and size.
- fill type, color, and size
-border type, color, and size.
Cycle – shows a process that has a continuous cycle.
Radial – shows the relationships of
parts to a core part or element
Pyramid – shows foundation-based relationships
Venn – shows areas of overlap between and among parts
Target – shows steps toward a goal
Using the Research Task Pane

The Research task pane helps you find and insert
data from an outside source into your worksheets.

You can use information from your in-house
network or from the Web.

Excel has a Research Library that includes:
(1) a Multilanguage thesaurus; (2) a Multilanguage
dictionary; (3) a Translation utility; and, (4) an
Internet dictionary
You open the Research task pane by:
- Clicking on the Research button on the Standard
toolbar
- Clicking a word while holding down the [ALT] key
- VIEW Menu > Task Pane; then select the Research
Note the Expand (+) and
Collapse (–) signs.
The term “computer” was
keyed in and then the ALT
key was held down while
clicking on the term.
Using a Special Symbol
INSERT MENU > Symbol option
Changing
the font will
change the
options
showing in
the display
window.
Use the same font as the
font in your document to
add accent marks such as
ÃÄÅÈËÖ