Question: Shelly Cashman Excel $2019|$ Module $8$: SAM Project $1$aShelly Cashman Excel $2019|$ Module $8$: SAM Project $1$aEastern MobileANALYZE DATA WITH CHARTS AND PIVOTTABLESGETTING STARTEDOpen the fileSC$\_$EX$19\_8$a$\_$FirstLastName$\_1.$xlsx$,$ available for download from the SAM website.Save the file asSC$\_$EX$19\_8$a$\_$FirstLastName$\_2.$xlsx 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.With the fileSC$\_$EX$19\_8$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.To complete this project, you need to add the Analysis ToolPak. If Data Analysis is not listed under the Analysis section of the Data ribbon, click the File tab, click Options, and then click the Add$-$Ins category. In the Manage box, select Excel Add$-$ins and then click Go$.$ In the Add$-$Ins box, check the Analysis ToolPak check box, and then click OK to install. If Analysis ToolPak is not listed in the Add$-$Ins available box, click Browse to locate it$.$PROJECT STEPSMarina Andros works in the Financials Department of Eastern Mobile, a communications company in Alexandria, Virginia. She is using an Excel workbook to analyze the company's recent financial performance, and asks for your help in creating advanced types of charts and PivotTables to provide an overview of mobile phone plans, customers, and orders. Go to the Plans worksheet, which contains a column chart in the range F$18$:K$31$ showing sales of each plan type in Quarter $2.$ Marina wants to create a similar chart showing the Quarter $1$ data.Provide a chart showing Quarter $1$ data as follows:Copy the Q$2$ Sales chart.Paste the chart in cell A$18.$Select the copied chart and drag the blue outline from the range G$4$:G$16$ to the range F$4$:F$16$ to change the data shown in the chart.The Ads table in the range I$4$:K$16$ compares the amount of advertising purchased in the previous year and the number of mobile phone plans sold. Marina asks you to create a chart that shows the relationship between the advertising spent and the plans sold.Insert a Scatter chart that shows the relationship between the advertising amount $($range J$4$:J$16)$ and the number of plans sold $($range K$4$:K$16).$Resize and position the Scatter chart so that it covers the range L$3$:R$16.$Use Ad Amount and Plans