Clever Acme Corp.;Fall Sales Meeting

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.
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.
The memo should look like the figure below.
An image of a memo for a sales meeting.
Save the document as Meeting Memo.
Spreadsheet and Chart
Start Excel and create a new blank workbook.
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,540 $77,370 $81,990 $240,900
Apply the following formats:
The company name should be in Arial, 20-point, bold, purple font.
The Summer Sales title should be in Arial 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.
The spreadsheet should look like the figure below.
An image of the formatted summer sales worksheet.
Save the worksheet as Summer Sales.
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."
The chart should look like the figure below.
An image of column chart based on cells A4 through D7 of the summer sales worksheet.
Save the modified workbook. Your final spreadsheet should look similar to the figure below.
An image of the modified summer sales workbook.
Presentation
Start PowerPoint and create a new blank presentation.
Change the theme of the presentation to Crop or another appropriate style if you don’t have Crop.
Verify that slide 1 uses Title Slide layout and then enter the following text so that your slide looks similar to the 
10/24/2020 Order 329045733
https://admin.writerbay.com/orders_available?subcom=detailed&id=329045733 3/5
figure below.
Clever Acme Corp.
Fall Sales Meeting
An image of the title slide layout.
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.
An image of a new PowerPoint slide with a table containing the sales data from the summer sales workbook.
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.
An image of a new PowerPoint slide with a stacked column chart containing the sales data from the summer
sales workbook.
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
Insert the Glow in the Dark Widget.jpg, a data file for this graded project.
The slide should look similar to the figure below.
An image of a PowerPoint slide using picture with caption layout with the Glow in the Dark Widget image.
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
Your slides should look similar to the following figures.
An image of a picture with caption layout PowerPoint slide with the Lime Doodad image.
An image of a picture with caption layout PowerPoint slide with the Buttercup Gizmo image.
An image of a picture with caption layout PowerPoint slide with the Black Widget image.
Add a new slide with a Title and Content layout and add the following text:
Title: Discussion
Regional sales reports
Questions
Comments
The slide should look similar to the figure below.
An image of a title and content layout PowerPoint slide with discussion text. 
10/24/2020 Order 329045733
https://admin.writerbay.com/orders_available?subcom=detailed&id=329045733 4/5
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.
An image of a title only layout slide with inserted text and clip art.
Apply the Page Curl transition to all the slides.
Apply the Grow & Turn animation to each of the bullet items on slide 8.
Save the presentation as Fall Meeting, and then play the slide show from the beginning to