Reference no: EM131534269

Assignment: COMPUTER APPLICATIONS

INTRODUCTION

This project uses the skills you've acquired for Word, Excel, and PowerPoint to prepare for a sales meeting. You'll assume the role of Director of Sales. For this project, you'll complete a memo, a spreadsheet with sales figures and a chart, and a presentation that integrates spreadsheet data.

INSTRUCTIONS

MEMO

1. Start Word and create a new blank document.

2. Create a memo for the sales meeting as shown in Figure 1, using the following formats:

a. The company name should be in Arial 20-point, bold, purple font.
b. The memo headings and text should be in Times New Roman, 12-point font, with left-aligned tab stops set to 1 inch.
c. Replace Your Name Here with your name.
d. The body text should be in Times New Roman, 12-point font, with bold text where indicated

3. Save the document as Meeting Memo

SPREADSHEET AND CHART

1. Start Excel and create a new blank workbook.

2. Enter data as shown in Figure 2, using the following formats:

a. The company name should be in Arial, 20-point, bold, purple font.
b. The Summer sales title should be in 16-point font.
c. The company name and Summer sales titles should be merged and centered.
d. Column headings should be bold, and month headings right-aligned.
e. The sales figures should be in Currency cell style with no decimal places.
f. Formulas that use functions should be used for calculated totals.
g. Cells B8 through E8 should be formatted in the Total cell style.

3. Save the worksheet as Summer Sales.

4. Create a column chart based on cells A4 through D7 that looks similar to Figure 3.

a. Select the 2-D Column Stacked Column style.
b. After the chart is created, add data labels as shown in the figure.
c. Edit the chart title as shown in the figure.

5. Save the modified workbook. Your final spreadsheet should look similar to Figure 4.

PRESENTATION

1. Start PowerPoint and create a new blank presentation.

2. Change the theme of the presentation to Crop or another appropriate style if you don't have Crop.

3. Verify that slide 1 uses Title Slide layout and then enter text so that your slide looks similar to Figure 5.

4. Add a new slide 2 with a Blank layout, insert a table, and then add the sales data from the Summer Sales workbook. Size the table so that slide 2 looks similar to Figure 6.

5. Add a new slide 3 with a Blank layout and then insert a Stacked Column chart. Add the Summer sales data, format the title, and add the data labels to each column. Size the chart so that slide 3 looks similar to Figure 7.

6. Add a new slide 4 with a Picture with Caption layout and add content so that the slide looks similar to Figure 8. Insert the Glow in the Dark Widget.jpg, a data file for this graded project.

7. Add three more Picture with Caption layout slides to introduce the Lime Doodad, Buttercup Gizmo, and Black Widget products. Their corresponding image files are data files for this graded project. Your slides should look similar to Figures 9, 10, and 11.

8. Add a new slide with a Title and Content layout and add text so that the slide looks similar to Figure 12.

9. Add a new slide with a Title Only layout. Insert text and a clip art picture that thanks employees for their hard work (use "thank you" as the search text when searching for the image). Size and position the picture to look similar to Figure 13.

10. Apply the Page Curl transition to all the slides.

11. Apply the Grow & Turn animation to each of the bullet items on slide 8.

12. Save the presentation as Fall Meeting, and then play the slide show from the beginning to check your presentation.

Attachment:- Project.pdf