$A*B*A.A*B*A.$

$$

$.$

If cell B$6$ does not display your name, delete the file and download a new copy

from the SAM website.

CT STEPS

Marina 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:

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 $G4$:$G16$ to the

range $F4$:F$16$ to change the data shown in the chart.

The Ads table in the range $I4$:$K16$ 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

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

range F$4$:F$16$ to change the data shown in the chart.

previous year and the number of mobile phone plans chart that shows the relationship between the advertising spent and the plans sold.

$$

$.$

If cell B$6$ does not display your name, delete the file and download a new copy

from the SAM website.

CT STEPS

Marina 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:

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 $G4$:$G16$ to the

range $F4$:F$16$ to change the data shown in the chart.

The Ads table in the range $I4$:$K16$ 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

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

range F$4$:F$16$ to change the data shown in the chart.

previous year and the number of mobile phone plans chart that shows the relationship between the advertising spent and the plans sold.