Provide a chart showing Quarter $1$ data as follows:

a$.$ Copy the Q$2$ Sales chart.

b$.$ Paste the chart in cell A$18.$

C$.$ Select the copied chart and drag the blue outline from the range G$4$: G$16$ to the range $F4$:$F16$ to change the data shown in the chart.

$2.$ 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.

a$.$ 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).$

b$.$ Resize and position the Scatter chart so that it covers the range L$3$:R$16.$

c$.$ Use Ad Amount and Plans Sold as the chart title.

$3.$ Marina wants to analyze the relationship between advertising spent and the plans sold. Add a Linear trendline to the scatter chart.

$4.$ Go to the Customers worksheet, which contains customer details in a table named Customers. Marina wants to display the payments customers made in each of five states where Eastern Mobile does business.