Illustrated Excel $2019|$ Module $7$: SAM Project $1$a

specializes in technology marketing.

Add a shape and picture to the SmartArt as follows:

a$.$ Add a shape after the D$\backslash$&M shape.

b$.$ Type $365$ in the new shape.

c$.$ Use the picture placeholder to add the picture Support$\_$EX$19\_7$a$\_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$\_$EX$19\_7$a$\_$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 I$1.$

$6.$ Go to the Revenue Comparison worksheet. Add a Black, Text $1,$ Lighter $50\backslash \%$ 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 $2021$ revenues for the four companies.

Embed the Word table in the Revenue Comparison worksheet as follows:

a$.$ Use Word to open the document Support$\_$EX$19\_7$a$\_$Compare.docx.

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

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