G GETTING STARTED

$-$ Open the file IL$\_$EX$19\_7$a$\_$FirstLastName$\_1.$xlsx$,$ available for download from the SAM website. Click Continue to start the project.

$-$ Save the file as IL$\_$EX$19\_7$a$\_$FirstLastName$\_2.$xIsx by changing the $"1"$ to a $"2".$

$-$ If you do not see the $.$xlsx file extension in the Save As dialog box, do not type it$.$ The program will add the file extension for you automatically.

$-$ To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:

$-$ Support$\_$EX$19\_7$a$\_365.$png

$-$ Support$\_$EX$19\_7$a$\_365.$xIsx

$-$ Support$\_$EX$19\_7$a$\_$Banner.jpg

$-$ Support$\_$EX$19\_7$a$\_$Combined.csv

$-$ Support$\_$EX$19\_7$a$\_$Compare.docx

$-$ Support$\_$EX$19\_7$a$\_$Summary.pptx

$-$ With the file IL$\_$EX$19\_7$a$\_$FirstLastName$\_2.$xlsx still open, ensure that your first and last name is displayed in cell B$6$ of the Documentation sheet.

$-$ If cell B$6$ does not display your name, delete the file and download a new copy from the SAM website.

$[1]$ 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 A$1,$ insert the picture Support$\_$EX$19\_7$a$\_$Banner.jpg$.$

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

a$.$ Apply the Brightness $\backslash (\backslash$mathbf$\{+20\backslash \%\}\backslash )$ Contrast $\backslash (\backslash$mathbf$\{+20\backslash \%\}\backslash )$ correction to the picture.

b$.$ Sharpen the picture by $\backslash (\backslash$mathbf$\{50\backslash \%\}\backslash )$ 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