Illustrated Excel 365/2021 | Module 7: SAM Project 1a Chastain Group

GETTING STARTED

1. Open the file IL_EX365_2021_7a_Mac_FirstLastName_1.xlsx, available for download. Click the X to disable automatic updates of links, and begin the project.

2. Save the file IL_EX365_2021_7a_Mac_FirstLastName_1.xlsx as IL_EX365_2021_7a_Mac_FirstLastName_2.xlsx

a. Edit the file name by changing “1” to “2”.

b. If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically.

3. To complete this Project, you will also need the following files:

Support_EX365_2021_7a_Mac_365.png

Support_EX365_2021_7a_Mac_365.xlsx

Support_EX365_2021_7a_Mac_Banner.jpg

Support_EX365_2021_7a_Mac_Compare.docx

Support_EX365_2021_7a_Mac_Summary.pptx

4. With the file IL_EX365_2021_7a_Mac_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet.

a. If cell B6 does not display your name, delete the file and download a new copy.

PROJECT STEPS

1. Ravi Chambal is a partner at the Chastain Group, a business consulting firm specializing in management and technology consulting. The Chastain Group wants to expand to include marketing consulting services by merging with an existing marketing company. Ravi is using an Excel workbook to compare the candidate companies. He asks for your help to improve the appearance of the workbook and include data stored in other files. Go to the Merger Options worksheet. In cell A1, insert the picture Support_EX365_2021_7a_Mac_Banner.jpg.

2. Adjust the banner picture as follows to make it more attractive:

a. Apply the Brightness +20% Contrast +20% correction to the picture.

b. Sharpen the picture by 50% to remove the blurriness.

c. Add the Tight Reflection: Touching effect from the Reflection gallery.

3. Ravi needs to add another shape and picture to the SmartArt on the worksheet to show four marketing companies instead of three. He also wants to indicate that one company specializes in technology marketing. Add a shape and picture to the SmartArt as follows:

a. Add a shape after the D&M shape.

b. Type 365 in the new shape.

c. Use the picture placeholder to add the picture Support_EX365_2021_7a_Mac_365.png to the SmartArt.

d. Add another shape after the BrandUp shape.

e. Type Tech in the new shape, and then demote the new shape.

4. Format the SmartArt as follows so that it coordinates more closely with the rest of the worksheet:

a. Change the SmartArt colors to Colored Fill – Accent 1.

b. Apply the Moderate Effect SmartArt style.

5. Ravi wants to include an image of a PowerPoint slide he created summarizing the four marketing companies. Include the image as follows:

a. Use PowerPoint to open the presentation Support_EX365_2021_7a_Mac_Summary.pptx.

b. In Excel, use the Screen Clipping tool to paste a screenshot of Slide 1: Marketing Consultants into the Merger Options worksheet.

c. Position the upper-left corner of the screenshot image in cell I1.

6. Go to the Revenue Comparison worksheet. Add a Black, Text 1, Lighter 50% border to the Chastain Group picture to match the same picture on the Merger Options worksheet.

7. Position and format the picture of the four logos as follows to improve the appearance of the worksheet:

a. Copy the formatting of the Chastain Group picture to the picture of the four logos.

b. Without moving the logos picture to the left or right, align the top of the logos picture with the top of the Chastain Group picture.

8. Ravi has a Word document with a table that compares the total 2024 revenues for the four companies. Embed the Word table in the Revenue Comparison worksheet as follows:

a. Use Word to open the document Support_EX365_2021_7a_Mac_Compare.docx.

b. Copy the table and then paste it into the Revenue Comparison worksheet starting in cell A21. Use the Keep Source Formatting option.

9. The embedded data includes only an estimate for the D&M Group total revenues. In cell B24, edit the embedded data to use 279,150 as the total revenues for the D&M group.

10. Ravi originally inserted the 365 Marketing revenue data as a link to another Excel workbook. He asks you to update the data and then remove the link. Update and remove the link as follows:

a. Display the links to external files, and then update the link to the workbook Support_EX365_2021_7a_Mac_365.xlsx.

b. Break the link to the Support_EX365_2021_7a_Mac_365.xlsx file.

Your workbook should look like the Final Figures on the following pages. Close all support files. Save your changes, close the workbook, and then exit Excel. Follow the directions on the website to submit your completed project.

Final Figure 1: Merger Options Worksheet

Microsoft product screenshot reprinted with permission from Microsoft Incorporated. Copyright © 2020 Cengage Learning. All Rights Reserved.; © bsd/Shutterstock.com; © IMRAN SHEIKH/Shutterstock.com; © Dmytro Shvetsov/Shutterstock.com; © Ed Samuel/Shutterstock.com

Final Figure 2: Revenue Comparison Worksheet