Shelly Cashman Excel 2019 | Module 8: SAM Project 1a #shelly #module8 #samproject1a
If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇
wa.me/message/PPXGSJS2TLWUA1
Whatsapp Contact Number:
+91 8114420233
Email ID:
excelprojectshelp@gmail.com
1. 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 F18:K31 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 Q2 Sales chart.
b. Paste the chart in cell A18.
c. Select the copied chart and drag the blue outline from the range G4:G16 to the range F4:F16 to change the data shown in the chart.
2. 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 (range J4:J16) and the number of plans sold (range K4:K16).
b. Resize and position the Scatter chart so that it covers the range L3:R16.
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.
Insert a recommended PivotTable based on the Customers table as follows:
a. Insert the Sum of Payment by State recommended PivotTable. [Mac Hint: Use the State field in the Rows area, the Payments field in the Values area, and show grand totals for rows and columns.]
b. Use Payments by State Pivot as the name of the new worksheet.
c. Apply the Light Orange, Pivot Style Medium 12 style to the PivotTable.
d. Add a second copy of the Payment field to the Values area of the Field List, and then change its summary function to Average so that Marina can compare the average payments to the totals.
e. Change the Number format of the two value fields to Currency with 0 decimal places and the $ symbol.
f. Use Total Payments as the column heading in cell B3, and use Average Payment as the column heading in cell C3.
5. Insert a PivotChart based on the new PivotTable as follows to help Marina visualize the data:
a. Insert a Combo PivotChart based on the Payments by State PivotTable.
b. Display the Total Payments as a Clustered Column chart and the Average Payment as a Line chart.
c. Include a secondary axis for the Average Payment data.
d. Hide the Field List so that you can format the value axis of the chart.
e. Change the maximum bounds for the value axis on the left to 1,400.
f. Change the PivotChart colors to Monochromatic Palette 4.
g. Resize and position the chart so that it covers the range D3:J17.
h. Display the Field List again.
6. Marina also wants to insert a PivotTable that includes other Customer information so that she can analyze Family plan customer data. Return to the Customers worksheet, and then create a PivotTable based on the Customers table as follows:
a. Place the PivotTable on a new worksheet, and then use Customers Pivot as the name of the worksheet.
b. Display the order location as column headings.
c. Display the state field and then the customer field as row headings.
d. Display the years as the values.
e. Display the plan type as a filter, and then filter the PivotTable to display customer information for Family plans only.
shelly cashman excel 2019 | module 1: sam project 1b,#shelly cashman excel 2019 | module 1: sam project 1b,shelly cashman excel 2019 | module 5: sam project 1a,module 5 sam project 1a,excel module 8 sam project,new perspectives excel 2019 module 1 sam project 1a,excel module 5 sam project a,excel module 8 sam end of module project 1,excel module 8 sam project a,new perspectives excel 2019 | module 10: sam project 1b,module 5: sam project 1a,module 1: sam project 1a