Computer Applications Integration (Microsoft Word, Spreadsheet and Database)

Daley’s Fruit Farm produces various fruits, which are sold to supermarkets, restaurants, etc. Mr. Daley has been communicating with his customers, as well as observing sales, to determine whether certain fruits should be discontinued, or additional fruits should be offered.

A spreadsheet is to be prepared to record sales over a 6-month period (January – June 2003), and also to keep records of customers. A database is to be prepared to give a breakdown of sales for the month of June. A letter will be prepared using a word processing application, to be sent to all customers who are shareholders.

Part A

You are required to create a spreadsheet to keep track of sales over the 6-month period (January – June 2003)

1. Reproduce the following spreadsheet and save it as FRUIT RECORDS.

2. Add a column for TOTALS to the left of June to display the total sales for each fruit. Enter formulas to calculate these totals, as well as the total sales for each month.

3. Sales for the month of April were accidentally omitted from the Accounts. Insert a column at the relevant position and enter the following sales figures for the month of April:

Bananas 1100 Lemons 1105

Pineapples 1000 Papayas 950

Watermelons 1620 Oranges 1400

4. Format all numeric columns as currency with zero decimal place.

5. Add a column at the end of the spreadsheet with the title % SALES, to calculate the percentage of total sales for each fruit. Format the percentage to 2 decimal places.

6. Center the heading across the spreadsheet. Save as FRUIT RECORDS 2.

7. Sort the spreadsheet in ascending order on fruits. Save as FRUIT RECORDS SORT.

8. Construct a column chart to compare the sales for each fruit for each month. Give the chart the title “MONTHLY SALES BY FRUIT.” Label the X and Y axes.

9. Create a pie chart to compare the percentage sales for each fruit. Give the chart the title “SALES.” Label each slice of the pie chart with the fruit and the percentage.

10. Create the following spreadsheet on a new sheet in the FRUIT RECORDS 2 File. Name the sheet JUNE FRUITS.

PRODUCE

QUANTITY HARVESTED

QUANTITY SOLD

Bananas

200

200

Pineapples

250

230

Lemons

150

140

Watermelons

220

220

Oranges

200

200

Papayas

200

120

PART B

You are now required to create a database (FRUIT SALES IN JUNE) to keep a detailed record of sales for

the month of June.

1. Import the sheet JUNE FRUITS. Give the table the name JUNE FRUITS. PROD is the primary key. The table should have the structure.