typing

ELECTRONIC DOCUMENT PREPARATION AND MANAGEMENT

MICROSOFT EXCEL

1. Type the following spreadsheet and save it as CATERING.

2. Rename Sheet1 to PREPARE. Make a copy of PREPARE and rename it FINISH. (Delete the

unnecessary worksheets)

3. Using a function, insert today’s date in the appropriate cell (DATE FORMAT: Month-Day-Year)

4. In cell A16 type the heading Setup Rate and in Cell A17 type the value 10%.

5. Calculate the Setup Cost if the Setup Cost is 10% of Service Charges (Service Charges * Setup

Rate)

6. Use functions to calculate the following:

· Total income on food, drinks, service charges and setup cost;

· Average income on food, drinks, service charges and setup cost;

· Highest income on food, drinks, service charges and setup cost;

· Lowest income on food, drinks, service charges and setup cost;

· Total cost for catering to Jamal, Akesha, Deidra and Amber;

· The total overall income from catering; and

· The percentage of Catering Income from Each Individual in relation to the Overall Total Catering Income. (Answer must be to 2 decimal places)

7. Complete the following formatting operations:

· Format all necessary numbers to Currency and no decimal places;

· Center the headings across the columns.

· Use appropriate cell styles for the main, column and row headings

· Insert a suitable graphic. The graphic should be appropriately sized and placed on both sides of the heading

8. Highlight the range A5:G9 and name it FOOD.

Create the following charts:

9. A PIE CHART to compare the Total Income for catering for Each Individual. Give the chart an

appropriate title. Label the chart with percent and place the legend on the left of the chart. Place

on a new sheet called INDIVIDUAL CATERING.

10. A COLUMN CHART to show the Total Income for each item (e.g., food, drink, etc). Give the chart an appropriate title and label the axes. Place the legend on the bottom of the chart. EMBED in the chart from A19 to G35.

11. Create another chart of your choice using information from the spreadsheet. Give the chart an appropriate title and label the chart appropriately. Place on a new sheet called UNIQUECATERING.

______________________________________________________________________________

12. Save the changes to the worksheet.