C:\Core\Apache\Apache2\htdocs\uploadedFiles\v0R6ncfFKgeLiq265tuLzhtm

Microsoft Works 4.5

Spreadsheet

Ewing SeniorNet Computer Literacy Center

June, 2001

Prepared by: J. Joel May

Table of Contents

I. Introduction to Spreadsheets........................................................................................................I-1

A. What You’ll Learn ....................................................................................................................I-1

B. The Opening Screen (Task Launcher).....................................................................................I-1

C. Open a Spreadsheet File ........................................................................................................I-2

D. The Works Spreadsheet Screen .............................................................................................I-2

E. Learning About Rows, Columns and Cells ..............................................................................I-3

F. The Dialog Boxes.....................................................................................................................I-3

G. Moving Around in the Spreadsheet.........................................................................................I-4

H. Entering Text in a Spreadsheet ...............................................................................................I-5

I. Entering Numbers in a Spreadsheet.........................................................................................I-5

J. Entering Series in a Spreadsheet ............................................................................................I-5

K. Entering Formulas in a Spreadsheet .......................................................................................I-6

L. Entering Functions in a Spreadsheet.......................................................................................I-6

M. Saving the Results and Ending the Session ...........................................................................I-7

II. Editing, Moving, and Printing the Data .......................................................................................II-1

A. What You’ll Learn ...................................................................................................................II-1

B. Open the Spreadsheet File.....................................................................................................II-1

C. Replacing an Entry in a Cell ...................................................................................................II-1

D. Editing the Contents of a Cell in the Entry Bar .......................................................................II-1

E. Clearing Cell Entries...............................................................................................................II-1

F. Copying Cell Entries................................................................................................................II-2

G. Relative vs. Absolute Cell References ...................................................................................II-2

H. Finding and Replacing Cell Entries ........................................................................................II-3

I. Printing a Spreadsheet ............................................................................................................II-3

J. Saving the Results and Ending the Session ...........................................................................II-4

III. Formatting Spreadsheets .........................................................................................................III-1

A. What You’ll Learn ..................................................................................................................III-1

B. Open an Existing Spreadsheet..............................................................................................III-1

C. Changing Margins .................................................................................................................III-1

D. Changing Page Orientation...................................................................................................III-1

E. Inserting Rows and Columns.................................................................................................III-1

F. Change Column Widths.........................................................................................................III-2

G. Formatting Cells....................................................................................................................III-3

H. Formatting Numbers in a Spreadsheet..................................................................................III-3

I. Changing the Alignment of Cell Entries ..................................................................................III-3

J. Saving the Results and Ending the Session ..........................................................................III-4

IV. More Formatting, Headers and Footers, Hiding and Protecting Data...................................... IV-1

A. What You’ll Learn ................................................................................................................. IV-1

B. Open an Existing Spreadsheet............................................................................................. IV-1

C. Changing Font Size and Style.............................................................................................. IV-1

D. Adding Borders..................................................................................................................... IV-1

E. Adding Shading.................................................................................................................... IV-2

F. Adding Headers and Footers ................................................................................................ IV-2

G. Hiding and Displaying Gridlines ........................................................................................... IV-2

H. Hiding and Displaying Formulas........................................................................................... IV-3

I. Hiding and Displaying Columns and Rows ............................................................................ IV-3

J. Adding Cell Protection........................................................................................................... IV-4

K. Saving the Results and Ending the Session......................................................................... IV-4

V. Sorting Spreadsheet Data and Creating Charts........................................................................ V-1

A. What You’ll Learn .................................................................................................................. V-1

B. Sorting Spreadsheet Data ..................................................................................................... V-1

C. Creating Charts ..................................................................................................................... V-2

D. Adding a Series to a Chart .................................................................................................... V-3

E. Adding Chart Titles and Labels.............................................................................................. V-3

F. Formatting a Chart ................................................................................................................. V-4

G. Printing a Chart ..................................................................................................................... V-5

H. Naming and Saving a Chart .................................................................................................. V-5

I. Inserting a Chart into a Document .......................................................................................... V-5

J. Saving the Results and Ending the Session .......................................................................... V-5

VI. Class Practice Problem........................................................................................................... VI-1

A. What You’ll Review............................................................................................................... VI-1

B. Building a Spreadsheet ........................................................................................................ VI-1

C. Adjust the Page Setup ......................................................................................................... VI-1

D. Enter the Column Headings and Format the Columns......................................................... VI-1

E. Enter the Initial Values.......................................................................................................... VI-2

F. Enter the Formulas................................................................................................................ VI-2

G. Formatting the Spreadsheet................................................................................................. VI-3

H. Adding Cell Protection.......................................................................................................... VI-3

I. Saving the Results and Ending the Session .......................................................................... VI-4

Microsoft Works v4.5 - Spreadsheet

I. Introduction to Spreadsheets

A. What You’ll Learn

1. How to open a spreadsheet

2. How to enter Data (Text, Numbers, a Series, Formulas and Functions)

3. How to copy information from one place to another on a spreadsheet

4. How to save a copy of the spreadsheet

B. The Opening Screen (Task Launcher)

1. When Works starts, the first screen displayed is the Task Launcher Screen

2. There are three tabs on this screen:

a) TASK WIZARDS (the default) displays a list of Tasks which Works will help you to

perform (we’ll cover these later in the course)

b) EXISTING DOCUMENTS displays a list of documents previously created in Works.

This makes it easy to reload a document you previously worked on for additions or

improvements. As you create more and more documents, you may wish to make

this tab your default.

c) WORKS TOOLS displays four buttons which create new documents for you. There

are four type of documents which can be created in Works:

Works 4.5 Spreadsheet

Prepared for: Ewing SeniorNet Computer Literacy Center

Page I-1

Prepared by: J. Joel May 6/19/01

C. Open a Spreadsheet File

1. Let’s start by working with a spreadsheet that has already been partially created

for you.

a) Click on the Existing Documents Tab

b) The document we want to use is not (yet) listed here (take my word for it), so click on

the Open A Document Not Listed Here Button

c) Since the file you want to use is on the floppy disk in your Drive A: (if the disk is not

in place, insert it now), you must change the Look In choice to 3 ½ inch Floppy (A:)

d) Highlight ESNSL1.WKS and click on the OPEN Button

2. You just opened a spreadsheet file called ESNSL1.WKS. A spreadsheet is a

versatile tool you can use for many personal and business tasks. For example: maintain

your check register, manage club or team records, create a home budget, or track your

financial transactions. You can use a spreadsheet to make simple or complex

calculations. The editing, formatting and charting features allow for the creation of

professional-looking and easy to read documents.

D. The Works Spreadsheet Screen

Title

Tool

Entry

Work

Resize, Minimize

Bar

File Name

Area

Help Menu

and Close Buttons

Columns

Cursor

Rows

Vertical

Cell (D29)

Scroll

Bar

View Controls

Task Bar

Status Bar

Horizontal

Help Menu

Scroll Bar

Controls

Works 4.5 Spreadsheet

Prepared for: Ewing SeniorNet Computer Literacy Center

Page I-2

Prepared by: J. Joel May 6/19/01

E. Learning About Rows, Columns and Cells

1. A spreadsheet is made up of horizontal Rows and vertical Columns that intersect

to form individual Cells. The information contained in the cells can be text,

numbers, dates, times, formulas, or functions

2. Each Column in a spreadsheet is identified by a letter or group of letters. A Works

spreadsheet has 256 columns labeled A through IV.

3. Each Row in a spreadsheet is identified by a number. The rows in a Works

spreadsheet are numbered from 1 to 16,384.

4. Each Cell in a spreadsheet is identified by the Column and Row whose intersection

it is. For example, the Cell known as E8 is the one at the intersection of Column E

and Row 8. In our example it is Total Expenses

F. The Dialog Boxes

1. As you use the Works spreadsheet (and all other Windows 95 and Windows 98

programs as well), you will encounter Dialog Boxes

2. Dialog boxes are used to provide information to the program regarding the

appearance of your document, the options you want to have in effect, etc.

3. They can contain one or more of the following components:

Text Box

Scrolling

Drop Down

Help

List Box

Action Buttons

Radio Buttons

Preview Box

Check Boxes

Works 4.5 Spreadsheet

Prepared for: Ewing SeniorNet Computer Literacy Center

Page I-3

Prepared by: J. Joel May 6/19/01

G. Moving Around in the Spreadsheet

1. In order to enter data (or change data) in a Cell, the Cursor (the heavy black

rectangle or the solid black highlight) must be located in that Cell.

2. To move the cursor directly to a Cell, you can

a) Move the mouse pointer to the Cell and click, or

b) Open the Edit Menu and choose GoTo. Then, in the GoTo Text Box type the

address of the Cell you want to move to. (If you have assigned ranges to your

spreadsheet, you can highlight the range name in the scrolling list box by clicking on

it – we’ll discuss ranges later in the course). Then click the OK Button (or press

ENTER), or

c) Press the F5 Key and follow the directions in b) above

3. You can use the Arrow Keys to move the cursor around in the spreadsheet.

a) The Up-Arrow Key moves the cursor to the Cell immediately above the current one

b) The Down-Arrow Key moves the cursor to the Cell immediately below the current

one

c) The Right-Arrow Key moves the cursor to the Cell immediately to the right of the

current one

d) The Left-Arrow Key moves the cursor completely off the spreadsheet (just kidding!).

It moves the cursor to the Cell immediately to the left of the current one

4. You can use the “Enhanced” Arrow Keys to move the cursor around in the

spreadsheet

a) CTRL Up-Arrow moves the cursor to the next non-blank cell above the current one

(or to the top of the Column if there are no non-blank cells)

b) CTRL Down-Arrow moves the cursor to the next non-blank cell below the current

one (or to the bottom of the Column if there are no non-blank cells)

c) CTRL Right-Arrow moves the cursor to the next non-blank cell to the right of the

current one (or to the right end of the Row there are no non-blank cells)

d) CTRL-Left Arrow moves the cursor to the next non-blank cell to the left of the current

one (or to the left end of the Row if there are no non-blank cells)

5. You can use the Home and End Keys and the “Enhanced” Home and End Keys to

move the cursor around in the spreadsheet

a) The Home Key moves the cursor to the left end of the current Row

b) The End Key moves the cursor to the right-most cell in the currently active area of

the spreadsheet

c) CTRL-Home moves the cursor to the upper left corner of the spreadsheet (Cell A1)

d) CTRL-End move the cursor to the lower right corner of the currently active area of

the spreadsheet

6. You can use the Page Up and Page Down Keys and the “Enhanced” Page Up and

Page Down Keys to move the cursor around in the spreadsheet

a) The Page Up Key moves the cursor up one screen

b) The Page Down Key moves the cursor down one screen

c) CTRL-Page Up moves the cursor right one screen

d) CTRL-Page Down moves the cursor left one screen

Works 4.5 Spreadsheet

Prepared for: Ewing SeniorNet Computer Literacy Center

Page I-4

Prepared by: J. Joel May 6/19/01

H. Entering Text in a Spreadsheet

1. The spreadsheet we are using (ESNSL1.WKS) is a partially completed revenue

analysis for the Ewing SeniorNet Education Company’s first quarter sales. Our job

is to turn it into a professional-looking report for management.

2. You use text in a spreadsheet to provide descriptive labels for Rows or Columns or

to give instructions

3. Move the cursor to Cell A2 using one or more of the techniques described above

and type “Revenue Analysis” (no quotes) and press ENTER

4. NOTICE:

a) The text you typed appears in the Entry Bar Text Box preceded by a quotation mark.

This simply means (to Works) that the entry is a text entry.

b) Text is always left-justified in the cell

c) IMPORTANT: If you ever want to go back and change any of this text, you will make

the changes IN THE ENTRY BAR TEXT BOX , not in the cell itself. We will cover

this point several more times during the course.

d) It looks as if the text we have entered is not only in Cell A2, but also spills over into

Cell A3. That, however, is not the case. The Entry Bar Text Box always displays the

text in the highlighted cell (the one the cursor is located in). If you move the cursor

to Cell A3, you’ll see by watching the Entry Bar Text Box that it still empty.

5. Now move the cursor to Cell A4 and type “Sales” (no quotes). If you press the

Down-Arrow Key (rather than the ENTER key), the entry will still be made, but the

cursor will move down to Cell A5. This is often a convenient way of entering

several pieces of information in contiguous cells

6. In Cell A5, type “Cost” (no quotes) and press ENTER

I. Entering Numbers in a Spreadsheet

1. You use numbers in a spreadsheet to make calculations. Numbers can be whole

numbers, decimal numbers, fractions, dates or times. Furthermore, as we shall

see, they can be formatted in a number of ways

2. The data for January and February have already been entered in Columns B and C.

We will enter the data for March in Column D

3. Move the cursor to Cell D4 and type “25120” (no quotes). Then press the Down-

Arrow Key

4. In Cell D5, type “10920” (no quotes) and press ENTER

5. In Cell D8, type “5966” (no quotes) and press ENTER

6. NOTICE:

a) Numbers are always right-justified

b) They ARE NOT preceded by a single quotation mark as are text entries

J. Entering Series in a Spreadsheet

1. Move the cursor to Cell B3, type “Jan” (no quotes) and press ENTER

2. NOTICE that it is automatically expanded to “January” and right-justified. Glance

up at the Entry Bar Text Box. What does Cell B3 actually contain? If you wanted

to enter the short month name “Jan” how would you do it?

3. We could now move to Cell C3 and type “Feb” then press the left arrow and, in Cell

D3 type “Mar,” but that is too much work. Instead

Works 4.5 Spreadsheet

Prepared for: Ewing SeniorNet Computer Literacy Center

Page I-5

Prepared by: J. Joel May 6/19/01

4. Place the mouse pointer on the small black box at the lower right corner of the

cursor (this is called a “handle”). The pointer will change to a black cross and the

word “Fill”

5. Press down the left mouse button and drag the handle to the right to include Cells

C3 and D3, then release the mouse button.

6. Voila! You have entered a series (of month names from January to March)

7. NOTICE:

a) Other series that Works makes available to you include days of the week (either

Mon - Sun or Monday - Sunday)

b) If you wanted to enter a series such as 5, 10, 15, 20, … or 1,3,5,7,9,11, … you

could enter the first two numbers (5 and 10 or 1 and 3) in adjacent cells, highlight

both cells and drag the fill handle to create the desired series

c) Series can be entered either horizontally (as we have just done) or vertically, labeling

either columns or rows

K. Entering Formulas in a Spreadsheet

1. Formulas perform calculations on numbers that already exist in a spreadsheet.

Formulas MUST begin with an equal sign ( = ) and can contain numbers, cell

references, other formulas, and mathematical operators ( +, -, *, /, or ^ )

2. Let’s start by entering a formula for Gross Profit into our spreadsheet. Gross

Profit is equal to Sales minus Cost so, for the month of January, Cell B7 should

display a number that is equal to the number if B4 minus the one in B5.

a) The formula for this is “=B4-B5” (no quotes), so type this into Cell B7

b) NOTICE : Cell B7 now displays 15050 which is 24080 - 9030 (or Gross Profit =

Sales - Cost), which is correct. But what are the CONTENTS of Cell B7?

3. Revenue is equal to Gross Profit minus Expenses, so Cell B10 should contain the

formula “=B7-B8.” Let’s enter this in a slightly different way. (Watch the Entry Bar

Text Box as you perform the following actions)

a) In Cell B10 type an equal sign “=” (no quotes)

b) Click on Cell B7

c) Type a minus sign “-“ (no quotes)

d) Click on Cell B8

e) Press ENTER

L. Entering Functions in a Spreadsheet

1. Functions are predefined formulas that perform special calculations or

comparisons. A function is a built-in equation that you can use in a spreadsheet.

2. Works makes available 76 functions: 9 Data and Time functions, 11 Financial

functions, 6 Logical functions, 17 Math and Trigonometry functions, 10 Information

and Reference functions, 7 Statistical Functions, and 16 Text functions.

3. Don’t Panic! We’ll cover SOME of these as we proceed through the course and, if

you want more information, click on the Contents Tab in Help Index, then choose

Spreadsheet and Spreadsheet Functions. Here you will find a list of all the

functions and instructions on how (and when) to use each of them

4. First, let’s put a Math function into Cell E4 that will display the total sales for the

months of January through March. Here, the Function we want to use is SUM

a) In Cell E4, type “=SUM(B4:D4)” (no quotes)

(1) All functions start with an equal sign “=” just like formulas

Works 4.5 Spreadsheet

Prepared for: Ewing SeniorNet Computer Literacy Center

Page I-6

Prepared by: J. Joel May 6/19/01

(2) SUM is the Math function to compute an sum (or total) of the specified range of

cells

(3) (B4:D4) specifies the range of cells over which we want to compute the average.

We want to use the contiguous cells beginning with B4 and continuing across

through D4. The cell references MUST be separated by a colon.

b) Press Enter

c) The number displayed in Cell E4 is 76960, which is the total sales for the months of

January through March, but the CONTENTS of Cell E4 is the function we just

entered

5. NOTE: There is a quicker way of doing this.

a) Place the cursor in Cell F4, click on the AutoSum Button on the Toolbar (the one with

the summation sign - Σ )

b) The cells immediately to the left are highlighted and the Sum Function is

automatically inserted

c) Press ENTER to see the results

6. Now, let’s compute the average sales for the months of January through March.

The Function we want to use is (not surprisingly) AVG.

a) In Cell F4 type “=AVG(B4:D4)” (no quotes)

b) Press Enter

c) Once again, note that the number displayed in the cell, 25653.333, is the result of

the function which is the actual contents on the cell as which is displayed in the

Entry Bar Text Box. (We’ll take care of the extra decimal places in Lesson Three)

M. Saving the Results and Ending the Session

1. Let’s now save our work so that we can pick up next time where we left off today

a) Open the File Menu and choose Save As

(1) We use Save As because it allows us to give our work a new name and save it

as a new file.

(2) If we were to use Save, our work would be saved, but the previous version of the

spreadsheet (the one we began with today) would be over-written and erased.

b) The Save As Dialog Box appears with the current file name highlighted in the File

Name Text Box

c) Type “ESNSL1xx,” (no quotes) where xx is your two initials as the new file name and

press ENTER. Works will add the .WKS file extension automatically

d) You now have two versions of the spreadsheet: the original named ESNSL1.WKS

and the changed version named ESNSL1xx.WKS. Note that Works displays the

new name for your file in the Title Bar.

2. Exit Works and Windows

Works 4.5 Spreadsheet

Prepared for: Ewing SeniorNet Computer Literacy Center

Page I-7

Prepared by: J. Joel May 6/19/01

II. Editing, Moving, and Printing the Data

A. What You’ll Learn

1. Replacing Cell Entries

2. Editing Cell Entries in the Entry Bar

3. Clearing Cell Entries

4. Copying and Moving Cell Entries

5. Absolute and Relative Cell References

6. Finding and Replacing Cell Entries

7. Printing a Spreadsheet

B. Open the Spreadsheet File

1. Let’s start by opening the same spreadsheet we worked on last time.

a) Click on the Existing Documents Tab

b) Any document we have worked on lately is listed here

c) Highlight ESNSL1xx.WKS (where xx represents your initials – this is the file we

worked on last time) and click on the OPEN Button

C. Replacing an Entry in a Cell

1. Let’s assume we have entered an incorrect Sales figure for January

a) Move the cursor to Cell B4

b) Type the correct value for January Sales which is “23885” (no quotes)

2. the new entry replaces the previous one AND the formulas you created in Cells B7

and B10 are automatically recalculated.

D. Editing the Contents of a Cell in the Entry Bar

1. Let’s further assume that the Expenses figure for February is incorrect. But we

want to change only one digit in the number (not the entire number).

2. To do this we will use the EDIT mode

a) Move the cursor to Cell C8. Note that the contents of the cell appears in the Entry

Bar

b) Click to the right of the number in the Entry Bar (or press F2). An insertion point

appears and you have entered the EDIT mode.

c) We want to change the Cell entry from 9022 to 9122, so position the insertion point

just after the character to be changed (in this case, between the 0 and the first 2),

press the backspace key to delete the incorrect character, and then type “1” (no

quotes).

d) When you press ENTER, the corrected entry will appear in Cell C8 and you will

leave the EDIT mode.

E. Clearing Cell Entries

1. Assume that we have decided that we don’t need to show the averaged for each

row of data.

2. We can delete this information by clearing the unneeded entries from the cells

a) Move the cursor to Cell F3, then drag down across F3 and F4 to highlight those

cells.

b) Press the DELETE Key to clear the entries from the cells

Works 4.5 Database

Prepared for: Ewing SeniorNet Computer Literacy Center

Page II-1

Prepared by: J. Joel May 4/5/1999

F. Copying Cell Entries

1. Last time, we entered formulas for Gross Profit and Revenue for the month of

January (in Cells B7 and B10, respectively). We now must enter the appropriate

formulas to compute the equivalent figures for the months of February and March.

2. We could re-enter the complete formulas in each cell, but it is much easier to copy

the formulas we have already entered. One of the neater tricks Works can perform

is to change all the necessary cell references when a formula is copied to a new

location.

a) Move the cursor to Cell B7 and copy the contents. There are at least four ways to

do this

(1) Open the Edit Menu and choose Copy, or

(2) Click on the Copy Button on the Tool Bar, or

(3) Press CTRL-C

(4) Right Click to open the Context Menu and choose Copy

b) The contents of the cell will be copied to the Windows Clipboard

c) Now highlight Cells C7 and D7

d) Paste the formula from the Windows Clipboard into the highlighted cells. There are

at least three ways to do this, as well

(1) Open the Edit Menu and choose Paste, or

(2) Click on the Paste Button on the Tool Bar, or

(3) Press CTRL-V

(4) Right Click to open the Context Menu and choose Paste

e) The formula stored in the Windows Clipboard will be pasted into the highlight cells

AND all cell references will be adjusted to that they apply to the new location. This

process is called Creating Relative Cell References. Check out the new formulas by

moving the cursor to the appropriate cell and viewing the formula in the Entry Bar

3. We’ll use a different technique to copy the formula in Cell B10 (January Revenue)

to Cells C10 and E10 (February and March Revenue as well as Total Revenue for

the Quarter)

a) Either

(1) Highlight Cells B10 through E10

(2) Open the Edit Menu and choose Fill Right, or

b) Or

(1) Highlight Cell B10

(2) Drag the Fill Handle (see Section I.J. above) to the right, highlighting Cells B10

through E10

c) The formula in Cell B10 (the first highlighted cell) is copied to the others and all cell

references are adjusted so that they apply to the new location, creating Relative Cell

References

G. Relative vs. Absolute Cell References

1. Most cell and range references in a spreadsheet are relative references such as

the ones we created above. A relative reference is Works is like referring saying

“two rows up and one column over”

a) In our example, the formula we typed into Cell B10 was “=B7-B8” or “three rows up

minus two rows up”

b) When we copied it to Cells C10 through E10, the relative reference to “three rows up

minus two rows up” remained the same, only the column references changed.

Works 4.5 Database

Prepared for: Ewing SeniorNet Computer Literacy Center

Page II-2

Prepared by: J. Joel May 4/5/1999

2. An absolute reference always points to the same cell, even if the formula

containing the reference is copied or moved to another location in the spreadsheet

a) To make a reference absolute, place a dollar sign ($) in front of the row and/or

column reference which you want to make absolute. Some examples are

(1) $B$10

Absolute column, absolute row

(2) B$10

Relative column, absolute row

(3) $B10

Absolute column, relative row

(4) B10

Relative column, relative row

b) As an example

(1) Type a “2” (no quotes) in Cell A17 and type a “3” (no quotes) in Cell B17

(2) In Cell A18 type “=2*A17” (no quotes). The result is 4 (which is 2 times the

contents of Cell A17). No surprises so far.

(3) Now copy the formula in Cell A18 to Cell B18. We used a relative reference, so

the result is 6 (which is 2 times the contents of Cell B17)

(4) Clear the contents of Cells A18 and B18

(5) In Cell A18 type “=2*$A$17” (no quotes). The result is as before.

(6) Now copy the formula in Cell A18 to Cell B18 and watch what happens

3. Can you think of some examples in which we would want to use relative

references? Some in which we would want to use absolute references?

H. Finding and Replacing Cell Entries

1. Let’s assume that we want to replace the word “Revenue” with the word “Income”

in our spreadsheet. This is, in our case, an easy task which we learned how to do

in Section II.C. above. But suppose we were working with a large spreadsheet in

which the word “Revenue” appeared many time and we wanted to replace all

occurrences of the word.

2. We would use the Find and Replace Feature

a) Open the Edit Menu and choose Replace

b) In the Find What Text Box enter “Revenue” (no quotes)

c) In the Replace With Text Box enter “Income” (no quotes)

d) Click the Replace All Button and Works replaces all occurrences of “Revenue” with

“Income”

3. WARNING: Indiscriminate use of the Replace All Button may be dangerous to your

spreadsheet’s health.

a) Suppose you wanted to replace all occurrences of the word “his” with the word

“hers” and you followed the steps outlined above.

b) Not only would you get all the replacements you had hoped for, you would also

change “this” to “thers,” “history” to “herstory,” “whistle” to “wherstle”, etc.

c) To avoid this sort of disaster, when in doubt, use the Replace Button instead. This

will allow you to choose to replace (or not replace) each occurrence of the word one

at a time.

I. Printing a Spreadsheet

1. To see how a spreadsheet will look when it is printed, use the Print Preview

function

a) Open the File Menu and choose Print Preview or click on the Print Preview Button

on the Tool Bar

b) Now you can Zoom in and out of the view, move from page to page using the Next

and Previous Buttons, and Print the spreadsheet directly

Works 4.5 Database

Prepared for: Ewing SeniorNet Computer Literacy Center

Page II-3

Prepared by: J. Joel May 4/5/1999

c) When you are finished examining the spreadsheet, click on the Cancel Button

2. To print a spreadsheet

a) Open the File Menu and choose Print or press CTRL-P

b) Make the appropriate choices in the Print Dialog Box

(1) Change printers, if you want, in the Printer Drop Down List Box

(2) In the Print Range Box you can choose to print the entire document or a range of

pages

(3) Click the Draft Quality Printing Check Box if you want to save ink or toner

(4) Choose the number of copies to print (and the order in which to print them) in the

Copies Box

c) NOTE: If you want to accept all the defaults in the Print Dialog Box and save a step

or two, you can simply click on the Print Button on the Tool Bar to print your

spreadsheet immediately

J. Saving the Results and Ending the Session

1. Let’s now save our work so that we can pick up next time where we left off today

a) Open the File Menu and choose Save

(1) We use Save because this time we are not concerned with overwriting the

previous version of our spreadsheet. We will Save it with the same name and

the new version will replace the previous one.

(2) If we were to use Save As, we would be asked for a new name and our work

would be saved with that new name, preserving the original version as well.

2. Exit Works and Windows

Works 4.5 Database

Prepared for: Ewing SeniorNet Computer Literacy Center

Page II-4

Prepared by: J. Joel May 4/5/1999

III. Formatting Spreadsheets

A. What You’ll Learn

1. Changing the page setup and page orientation

2. Formatting Rows and Columns

3. Inserting Rows and Columns

4. Changing Column Widths

5. Formatting Cells

6. Changing Number Formats

7. Changing Alignment of Cell Entries

B. Open an Existing Spreadsheet

1. Click on the Existing Documents Tab

2. The document we want to use is not (yet) listed here (take my word for it), so click

on the Open A Document Not Listed Here Button

3. Since the file you want to use is on the floppy disk in your Drive A: (if the disk is

not in place, insert it now), you must change the Look In choice to 3 ½ inch Floppy

(A:)

4. Highlight ESNSL2.WKS and click on the OPEN Button

C. Changing Margins

1. Open the File Menu and choose Page Setup

2. The Page Setup Dialog Box has three Tabs (Margins; Source, Size & Orientation;

and Other Options) as well as a Preview Box

a) Click on the Margins Tab

b) Set the Left Margin to 1.75”

c) Watch the changes in the Preview Box

d) Note that you can also set the Top, Bottom and Right Margins as well as the Header

and Footer Margins (we don’t know what these are yet, but we’ll come to it next time)

e) Note also that you can click on the Reset Button to change everything back to its

original setting

D. Changing Page Orientation

1. Our spreadsheet might look better if the page were turned horizontally (this is

called “Landscape Mode”)

a) Click on the Source, Size & Orientation Tab

b) Click on the Landscape Radio Button in the Orientation Box

c) Watch the changes in the Preview Box

d) Note that you can also set the paper size and the printer tray from which the paper

is to be selected (these settings, however, usually make sense only in a situation in

which a very powerful (and expensive) printer is in use).

e) Click the OK Button

2. Check out your changes so far by using Print Preview (either Open the File Menu