Exercise Directions:

1. Set the paper size to A4 (210 x 297 mm) (File | Page setup | Paper size).
2. Use page orientation as Portrait.
3. Set the page margin as follow: Top: 1.5", Left: 1.2", Right: 1.2" Bottom: 1".
4. Type the letter appearing on the following page.
5. Insert the date from the Insert menu, six tabs away from the left margin.
6. Bold the name of the person Mrs. Vanessa Jackson
7. Select the address and increase the font size to 12.
8. Center aligns, underline and bold the word Reminder letter as shown.
9. Save the document as Letter 1 in your folder (C:\My Documents \ Your Folder).
10. Close the document (File | Close).
11. Create another letter with the same content addressing to Mr. Edward Weinberg by
modifying the above letter 1.
[Link] the letter as Letter 2 in your folder (File | Save as).
13. Close the application.
Styles used:
Font: Arial
Size: 11
Change to italics, use underline wherever required.
Insert today's date

Reminder Letter

Mrs. Vanessa Jackson

Ace Chemical Co.

Brooklyn

NY11221

Dear Mrs. Jackson:

Just a brief reminder your account is past due. As you can see the enclosed statement, you
still have an outstanding balance of $ 256.98, which was due on March 25th, 1999.

We need your cooperation so that we can continue to give you the service we have provided
you for many years.

Please mail your remittance for $ 256.98 today, so we are not forced to send your account to
our collection agency.

Cordially,

Brenda Nadia

Collection Manager
Results:
19 July 2024

Reminder Letter
Mrs. Vanessa Jackson
Ace Chemical Co.
Brooklyn
NY11221

Dear Mrs. Jackson:

Just a brief reminder your account is past due. As you can see the enclosed
statement, you still have an outstanding balance of $ 256.98, which was due on March
25th, 1999.

We need your cooperation so that we can continue to give you the service we have
provided you for many years.

Please mail your remittance for $ 256.98 today, so we are not forced to send your
account to our collection agency.
Cordially,
Brenda Nadia
Collection Manager
Exercise Directions:

1. Create an Auto correct entry under the "Replace text you type" check box, so that
the letters "cy" are replaced by "Cayman Islands" while you type.
2. Type the document as shown on the following page.
3. Follow the directions below to format as shown.
4. Set the page margins as follows: Top: 1.5", Left 1.2", Right 1.2" and Bottom 1".
5. Center the heading.
6. Indent the first line of each paragraph to 1 inch (use ruler).
7. Set the line spacing to 1.5 lines for the first and the second paragraph. (Format |
paragraph | line spacing).
8. Double underline the words "Christopher Columbus".
9. Format the title "Hotel/Diving Accommodation" to small caps (Format | Font).
10. For all the paragraphs that follow the heading above, set the Left indent to 0.5" and
right indent to 4.5".
11. Spell check and grammar check the document. (Tools | Spelling and
grammar).
12. For the words "located", "residents", and "visitors" find a suitable replacement from
the Thesaurus. (Tools | Language | Thesaurus).
13. Using the Find and Replace, replace the word PO with P.O. in the entire
document. (Edit | Replace).
14. Format the document further to the document as shown. The formatting required
here is mainly setting the indents of the paragraphs of the addresses of the
Accommodation's.
15. Save the file as DIVING in your folder.
Styles used:
Main Heading: Arial, 16 points, Bold.
First Paragraph: Times New Roman, 11 points.
Second Heading (Small Caps): Arial 14 points.
Remaining Paragraphs: Times New Roman, 11 points
DIVING IN THE CYMAN ISLANDS
Do you want to see sharks, barracudas, stingrays and angelfish?
Christopher Columbus discovered the Cayman Islands in 1503. And are located south
of Cuba. The Caymans are home to about 25,000 year-around residents. However,
they welcome 200,000 visitors each year. Most visitors come with masks and flippers
in their luggage.
Hotel/ Diving Accommodations:
Sunset House, PO Box 479, George Town, Grand Cayman; (800) 555-5764
Coconut Harbour, PO Box 2086, George Town, Grand Cayman; (809)555-5768
Red Sail Sports, PO Box 1588, George Town, Grand Cayman; (809)555-7867
Cayman Diving Lodge, PO Box 11, East End, Grand Cayman; (809)555-9090
Anchorage View, PO Box 2123, Grand Cayman; (809)555-4209.

Result
Exercise Directions:

1. Type the document as shown on the following page.

2. Follow the instructions below to format the document.
3. Move the paragraphs in alphabetical order. Use any desired move procedure (Cut
and Paste).
4. Use the numbering feature to number each item. (Click numbering
button on the Toolbar).
5. Set the left margin to 2" and the right margin to 1". (File | Page setup | Margins).
6. Press enter after each tip (After pressing enter, a new number will appear. To
remove the number, position the insertion point at any point in the sentence and click
the numbering icon the toolbar). Indent 1" from the left and right margin for the text
below each tip. (Use indents on the ruler).
7. Use format painter to copy the format of one heading to the rest of the headings.
Number 8. Change the format of the bullets to Font Impact, Size 12 points.
(Format | Bullets and Numbering | Customize | Font).
9. Change the format of the numbers so that instead of a dot the numbers are followed
by a dash (1- instead of 1.).
[Link] the numbers to bullets.
[Link] the file as TIPS in your folder.
Styles:
The main heading: Arial 20 points Bold
Tips: Arial 14 points, Bold Text below the tips: Times New Roman 12 points italics.
SIX TIPS FOR THE WORKAHOLICS

SLOW DOWN. Make a conscious effort to eat, talk, walk and drive more slowly. Give yourself
extra time to get to appointments so you are not always rushing.

DRAW THE LINE. When you are already overloaded and need more personal time, do not take
on any other projects. You will be just causing yourself more stress.

LEARN TO DELEGATE. Let others share the load you do not have to do everything yourself. You
will have more energy and the end result will be good for everyone.

TAKE BREAKS. Take frequent work breaks: short walks or meditating for a few minutes can
help you unwind and clear your head

CARE FOR YOURSELF. Eat properly, get enough sleep and exercise regularly. Do what you can
so that you are healthy, both mentally and physically.

CUT YOUR HOURS. Be organized, but do not let your schedule run your life. Also, try to limit
yourself to working eight hours a day - and not a minute more.

Results:
Exercise Directions:
1. Create a new document.

2. Type the document as shown.

3. The middle column is a text box that has to be inserted after the paragraph is running
across the text box and thus is not two columns as such.

4. Insert any appropriate clipart.

5. Give proper border and shading to the text box.

6. Insert a header "MS OFFICE COURSE" (View | header/footer)

7. Insert footer-Lab exercises, Page number.

Style:

Main heading: Impact 22 points

Paragraph Text: Arial, 11 points, paragraph spacing 1.5 lines justified

Text Box: Arial Narrow 10 points, Bulleted.

Header: Arial Narrow 9 points, Bold right aligned Footer: Lab exercises- Tahoma 9 points, left
aligned

Page number: Right aligned, same format

Send and Receive Computer Data and axes from Wherever You Happen to Be.

With phone. Data Link, you can leave behind the physical constraints of your office, but the
Phone/ Data Link is a new business tool from Coastal Electronics that gives you the freedom to
compute and communicate anytime or anywhere. Phone/ Data Link allows you to connect
your modem-equipped computer or fax machine to a portable cellular telephone and have
the ability to send data and faxes from virtually anywhere that cellular services is available.
Coastal Electronics 1-800-555-5555

To be typed in the text box

Phone/Data Link advantage

Connects any modem-equipped computer or fax machine to a portable cellular telephone.

Enables you to send computer data or faxes via your cellular phone. Compatible with your
existing software.

Compact design.

Features simple two-cable connection.

Result

Send and Receive Computer Data and axes

from Wherever You Happen to Be.
With phone. Data Link, Phone/Data Link advantage you can leave behind
the physical constraints of  Connects any modem-equipped your office, but the
Phone/ Data Link is a new computer or fax machine to a business tool from
portable cellular telephone.
Coastal Electronics that  Enables you to send computer gives you the freedom
data or faxes via your cellular
to compute and communicate anytime
phone. Compatible with your
or anywhere. Phone/ Data existing software. Link allows you to
 Compact design.
connect your modem-  Features simple two-cable equipped computer or
fax machine to a portable connection. cellular telephone and
have the ability to send data and faxes from
virtually anywhere that cellular services is available. Coastal Electronics 1-800-555 -5555
Exercise Direction:
1. Open a new document. Set the top margin to 1.5", bottom margin to 1" and left and right
margins to 1.2" each.

2. Type the document as shown on the next page. The entire text is typed in Time New
Roman, 11 points.

3. Follow the steps given below to format the document.

4. Select the entire document except the main heading and format it to two columns. (Column
button on the toolbar or Format | Column). Make sure that text up to the word enjoys must
be in one column and the names of the books must be in one column. Insert a column break
as required.

5. Format the headings as follows: bring the word GUIDEBOOKS in the next line. Set the main
heading and the second heading as indicated in styles below. Insert the symbol (&) from
Windings.

6. Next format the text as indicated below.

7. Change the width of the first column to 4", the width of the second column to 1.37" and the
spacing to 0.5". (Format | Column). Make sure that you have set the left and the right margins
to 1.2" each and the paper size to A4.

8. Format of the text of the first column to Arial 10 points, and paragraph spacing to 1.5 lines
(Format | Paragraph | Line Spacing). Make sure that the contents of the first column are the
same as what is shown.

9. Format the text of the second column to Arial 10 points Bold.

[Link] the first letter of the first column and Drop it by three lines. (Format | Drop сар).

11. After the formatting is over, save the file as VACATION in your folder.

Styles: The Main Heading: Left Aligned, Arial 24 points Bold, First letter: 56 points, Symbol: 72
points. Second level heading (GIUDEBOOKS): Right Aligned, 24 points. Body Text: Left Aligned,
Times New Roman, 11 points.
VACATION PLANNING AND GUIDEBOOKS

It can be very exciting to plan a vacation. There are a number of ways to go about it. Of
course, you can have a travel agent to make all the arrangements. But it is more exciting to
investigate all the possibilities of travel.

First, you can check the hundreds of guidebooks that can be purchased at: bookstores. Then,
you can send away to the government tourist offices in the country you are planning to visit.
They will send you free literature about the country - places to visit and a list of
accommodations. The travel advertisement in your newspaper will tell you where the
bargains are. After you have planned your trip by looking through the guidebooks listed to the
right, ask your travel agent to do the actual booking.

Enjoy!

OFFICIAL AIRLINE GUIDE

RUSSELL'S NATIONAL MOTOR COACH GUIDE

STEAMSHIP GUIDE

HOTEL AND RESORT GUIDE

RESTAURANT INN AND MUSEUM GUIDE

SIGHTSEEING GUIDE

FARM VACATIONS AND ADVENTURE TRAVEL GUIDE

Results

VACATION PLANNING 
GUIDEBOOKS

I
t can be very exciting to plan a vacation. There are a OFFICIAL AIRLINE

number of ways to go about it. Of course, you can have GUIDE

a travel agent to make all the arrangements. But it is RUSSELL'S NATIONAL

more exciting to investigate all the possibilities of travel. MOTOR COACH GUIDE

First, you can check the hundreds of guidebooks that can STEAMSHIP GUIDE
be purchased at: bookstores. Then, you can send away to
HOTEL AND RESORT
the government tourist offices in the country you are GUIDE
planning to visit. They will send you free literature about the
RESTAURANT INN AND
country - places to visit and a list of accommodations. The
MUSEUM GUIDE
travel advertisement in your newspaper will tell you where
the bargains are. After you have planned your trip by looking SIGHTSEEING GUIDE

through the guidebooks listed to the right, ask your travel FARM VACATIONS AND
agent to do the actual booking. ADVENTURE TRAVEL
GUIDE
Enjoy!
Exercise directions:
1. Type the document according to the following steps:

2. Create a table of 5 columns and 4 rows. (Table | Insert table).

3. Type the data as shown

4. Then format the table as shown next.

5. Set the first column width to 1.5", set the second column width to 1.31", and leave 0.25"
between the columns. (Table | Table properties)

6. Use the auto fit feature to size the third, fourth and fifth column. (Table | Table properties)

7. Center the headings and the data in the fourth and the fifth column.

8. Insert a row after the heading and each destination. (Insert Row tool on the Standard
Toolbar or Insert | Rows)

9. Insert a column after the destination column. (Insert Column tool on the Standard Toolbar
or Insert | Rows)

10. Remove the borders (No border button on Standard tool bar)

11. Remove the gridlines (Table | hide gridlines).

[Link] a suitable auto format to the table.

[Link] the file as FESTIVAL in your folder.

Styles:

The main Heading: Arial 14 points, Bold Second Heading: Arial 12 points Third Heading: Ariel
12 points, Italics Column Heading Times New Roman, 11 points Bold Table Text: Times New
Roman 11 points
FESTIVAL TRAVEL ASSOCIATES

WORLD CRUISE SEGMENTS

SPRING 1995

DESTINATION PORTS DEPARTS NO. OF DAYS COST

Panama New York, March 6 13 $. 2,529
canal Cartagena,
Panama
Cannel,
Acapulco
Trans Pacific Los Angeles, March 19 11 $4,399
Ensenada,
Kona,
Honolulu,
Fiji, Auckland
Israel to New Haifa, March 19 18 $5,299
York Kusadasi,
Istanbul,
Athens,
Naples,
Cannes, New
York
Results:

FESTIVAL TRAVEL ASSOCIATES

WORLD CRUISE SEGMENTS
SPRING 1995

NO. OF
DESTINATION PORTS DEPARTS COST
DAYS

New York,
Cartagena,
Panama canal March 6 13 $. 2,529
Panama Cannel,
Acapulco
Los Angeles, Ensenada, Kona,
Trans Pacific March 19 11 $4,399
Honolulu, Fiji, Auckland
Haifa, Kusadasi, Istanbul,
Israel to New
Athens, Naples, Cannes, New March 19 18 $5,299
York
York
AMERICAN

TRAVELER
Volume 3, Number 3 A publication of Carl’s Travel Network Summer 1995

SMOKERS MEET passed in Los Angeles and sees on the train ride
New York, which makes along the riverbank from
NEW RESTRICTIONS
cigarette smoking illegal in Cologne to Frankfurt. For
DURING TRAVEL restaurants. Violators face further information
aware of the increased a $50 fine for the first contact your local travel
constraints on the ability offence, $100 fine. for the agent and request the
to smoke in the public second offence within a 'RIVER CRUISES TO
places. About five years year and $250 fine for EUROPE PACKAGE or the
smoking prohibited ago, every offence after that. "SILLA TOURS PACKAGE
Was all on domestic Be cautious when
traveling not to violate
TRAVEL HIGHLIGHT OF
airline fights. THE SEASON
unexpected smoking laws.

TRAVEL TRIVIA: CRUISING ON THE RHINE Lorem ipsum dolor sit

amet, consectetuer
Q: What city is said to Strasbourg, the capital of adipiscing elit. Maecenas
take its name from a the French Alsace, is a porttitor congue massa.
Huron word meaning wonderful elty to begin or Fusce posuere, magna sed
"Meeting Place of the end a cruise. Its pink pulvinar ultricies, purus
Waters?" sandstone Cathedral and lectus malesuada libero,
a well preserved old town sit amet commodo magna
A: Toronto
are enchanting attractions eros quis urna. Nunc
for vacationing tourists. viverra imperdiet enim.
Now the Dallas-Fort The cost of a three-day Fusce est. Vivamus a
Worth Airport recently. cruise including two tellus. Pellentesque
declared the entire evening meals, two habitant morbi tristique
passenger terminal off breakfasts, two luncheons senectus et netus et
limits to smokers. Those and coffee and cakes will malesuada fames ac turpis
wishing to smoke will now cost approximately $507 a egestas. Proin pharetra
have to leave the airport erson. The view from nonummy pede. Mauris et
premises to do so. person the middle of the orci. Aenean nec lorem. In
Perhaps more far reaching river is more dramatic that porttitor. Donec laoreet
is the law
the glimpses of the same nonummy augue.
scenery that a passenger Suspendisse dui purus,
scelerisque at, vulputate at sem venenatis eleifend.
vitae, pretium mattis, Ut nonummy.
nunc. Mauris eget neque

Exercise Directions:
1. Create a new document.

2. Type the document as shown.

3. Insert a relative clip art in the heading.

4. Format the entire text to three columns.

5. The last paragraph (Travel Highlight of the season) is shaded.

Style

Main heading: American: Arial 30 points; Traveler: Arial 48 points.

Heading of the paragraphs: Arial 14 points.

Paragraph text: times new Roman 11 points.

The paragraph TRAVEL TRIVIA: Arial 11, double border around the text.

Text below the sail boat: Arial 6 points.

The paragraph TRAVEL HIGHLTIGHT OF THE SEASON: Heading: Arial 11 points.

Text: Arial 8 points.

Processing a customer order

Open Envelope

Type custom’s name,

address,

Phone number

Yes Type custom’s name,

Check in address,
Envelope Phone number

No

Type amount due

Statement showing balance

Enter payment code

Overnight

How to ship Add $.18.00 to charges

US Postal service

Add $.6.00 to charges

Save and close file

Mail Merge

Main Document

<Title First> <Name Last name>

<Company>

<Address 1>, <City>

<State>, <Postal Code>

Dear <Title> <Last Name>:

Just a brief reminder your account is past due. As you can see the enclosed statement, you
still have an outstanding balance of <Amount>, which was due on <Date>.

We need your cooperation so that we can continue to give you the service we have provided
you for many years.

Please mail your remittance for <Amount> today, so we are not forced to send your account
to our collection agency.

Cordially,

Brenda Nadia Collection Manager XYZ Bank, North Avenue USA

Title First Last Company Address1 City State Postal Amount Date
Name Name code

Mrs. Mrs Jackson Ace 48 Endor Brooklyn NY 12145 4567.89 March

Vanessa Chemical Avenue 1
co.
Mr. Kenneth Hall Microsoft 5 Long NJ 87666 1900.76 April 5
Windsor Branch
West
Mr Bill Gates Google 187 Queens NY 35521 759.05 Jun 10
Beach
147
Street

Ms. Stefanie Eaton XYZ Broad 137 Perth NJ 86231 7609.04 Nov 8
Casting Brighton Amboy
Corp. Avenue