Instructions
Memo
1. Start Word and create a new blank document.
2. Create a memo for the sales meeting with the following text:
Clever Acme Corp.
TO: All Employees
FROM: Your Name, Director of Sales
DATE: September 17, 20xx
SUBJECT: Fall Sales Meeting
The Fall Sales Meeting will take place on September 28 at 2:00 pm in the conference room. We will review summer sales and discuss our upcoming product launches.
Following the meeting will be a barbeque at Yama Park. Feel free to invite your family to the event, which is expected to begin at 4:00 pm.
3. Apply the following formats:
· The company name should be in Arial 20-point, bold, purple font.
· The memo headings and text should be in Times New Roman, 12-point font, with left-aligned tab stops set to 1 inch.
· Replace Your Name with your name.
· The body text should be in Times New Roman, 12-point font, with the dates and times in bold text.
4. The memo should look like the figure below.
5. Save the document as Meeting Memo.
Spreadsheet and Chart
1. Start Excel and create a new blank workbook.
2. Enter data as shown in the table.
Clever Acme Corp. |
||||
Summer Sales |
||||
Gadget |
June |
July |
August |
Total |
Doodads |
$12,675 |
$8,020 |
$8,600 |
$29,295 |
Gizmos |
$22,975 |
$18,975 |
$23,500 |
$65,450 |
Widgets |
$45,890 |
$50,375 |
$49,890 |
$146,155 |
Total |
$81,450 |
$77,370 |
$81,990 |
$240,900 |
3. Apply the following formats:
· The company name should be in Arial, 20-point, bold, purple font.
· The Summer Sales title should be in 16-point font.
· The company name and Summer Sales titles should be merged and centered.
· Column headings should be bold, and month headings right-aligned.
· The sales figures should be in Currency cell style with no decimal places.
· Formulas that use functions should be used for the calculated totals.
· Cells B8 through E8 should be formatted in the Total cell style.
4. The spreadsheet should look like the figure below.
5. Save the worksheet as Summer Sales.
6. Create a column chart based on cells A4 through D7:
· Select the 2-D Column Stacked Column style.
· After the chart is created, add data labels for the company's products.
· Edit the chart title to say “Summer Sales.”
7. The chart should look like the figure below.
8. Save the modified workbook. Your final spreadsheet should look similar to the figure below.
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 the following text so that your slide looks similar to the figure below.
· Clever Acme Corp.
· Fall Sales Meeting
4. Add a new slide 2 with a blank layout, and then add the sales data from the Summer Sales workbook as a linked Excel Worksheet. Size the table so it takes up the full slide and looks similar to the figure below.
5. Add a new slide 3 with a blank layout and then insert the Summer Sales chart from the Excel workbook. Size the chart so it takes up the full slide and looks similar to the figure below.
6. Add a new slide 4 using Picture with Caption layout and add the following text:
· Glow in the Dark Widget
· Launch Date: 11/1/20
7. Insert the Glow in the Dark Widget.jpg, a data file for this graded project.
8. The slide should look similar to the figure below.
9. 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. The slides should include the following text:
· Lime Doodad
· Launch Date: 11/15/20
· Buttercup Gizmo
· Launch Date: 12/2/20
· Black Widget
· Launch Date: 12/10/20
10. Your slides should look similar to the following figures.
11. Add a new slide with a Title and Content layout and add the following text:
· Title: Discussion
· Regional sales reports
· Questions
· Comments
12. The slide should look similar to the figure below.
13. Add a new slide with a Title Only layout. Insert text “Enjoy the Barbeque” and a clip art picture that thanks employees for their hard work (use “thank you” as the search text when searching for the image). The slide should look similar to the figure below.
14. Apply the Page Curl transition to all the slides.
15. Apply the Grow & Turn animation to each of the bullet items on slide 8.
16. Save the presentation as Fall Meeting, and then play the slide show from the beginning to check your presentation.