Integration - Word & Excel

COMPUTER APPLICATIONS

INTEGRATION EXERCISE – MICROSOFT WORD AND EXCEL

Part A

1. Launch your Word Processing and Spreadsheet Software.

2. Create the Spreadsheet document as shown below. Save it as PROPERTY.

3. Using a function, insert today’s date in cell A1.

4. Calculate the amount for each property type.

5. The commission rate is 6% of the amount figure. Calculate the commission for each property type.

6. Calculate the total amount for each property including the commission.

7. Use appropriate functions to calculate the TOTAL, AVERAGE, HIGHEST, LOWEST and

PERCENTAGE.

8. Define the range A2:H11 and name it GUIDE.

9. Format the spreadsheet as follows:

i) Format all numbers for currency and zero decimal places

ii) Center the headings across the columns using appropriate font size and type

10. Create a Pie Chart illustrating the total amount for each type of property by description. Label the

chart appropriately.

11. Create a footer with your name left aligned and your class right aligned.

12. Save your work.

Part B

1. Create the following word processing document below:

PARADISE PROPERTIES

81 Flemming Street

Tortola, B.V.I.

(284) WEL-COME

__________________________________________________________________________________________

(Insert today’s date)

Mr. Chris Hyson

7610 Cotton Road

Boston, MA 52412

Dear Mr. Hyson:

We are happy to inform you about our different properties that we have listed in our Virgin Islands Real Estate Guide. Our company is very delighted that you have an interest in investing with us. Please note the properties available within the market below:

<Insert the range A2:H11 from your spreadsheet here>

The chart below illustrates a clearer picture of the overall sales our company receives.

<Insert the chart from your spreadsheet here>

Please take the time to look at the enclosed brochure and contact us concerning any questions which you may have. Come and enjoy a bit of paradise with us, we await your response.

Yours truly,

Anthony Gates

Chief Executive Manager

Enc.

__________________________________________________________________________________________

2. Save document as INVEST.

3. Change the heading to any appropriate font type and size.

4. Fully justify the body of the letter.

5. Insert the Range and Chart in the appropriate location.

6. Spell check the document.

7. Save all changes.