Select Page

You work for the Farmers Wholesale Cooperative and help the financial director prepare and analyze revenue and expenses. He has asked you to create two PivotTables and corresponding PivotCharts from the annual sales worksheet for the Farmers Wholesale Cooperative. One PivotTable and PivotChart summarize the sales by farm and the other PivotTable and PivotChart summarize the dairy sales by month for the top dairy producer. Instructions: 1.

Document Preview:

You work for the Farmers Wholesale Cooperative and help the financial director prepare and analyze revenue and expenses. He has asked you to create two PivotTables and corresponding PivotCharts from the annual sales worksheet for the Farmers Wholesale Cooperative. One PivotTable and PivotChart summarize the sales by farm and the other PivotTable and PivotChart summarize the dairy sales by month for the top dairy producer. Instructions: 1. Create the workbook Farmers Wholesale use the data from the table below, name the worksheet tab Annual Sales and save the workbook using the file name, Unit 9 Project_Your Name. worksheet Sales by Farm. See below for ex Change cell A4 to Farms and cell B3 to Stores. Apply the Pivot Style Light 16 style to the PivotTable. Format the values as Currency values with a dollar sign and no decimal places. Apply the Style 19 to the PivotChart. Create a second PivotTable and associated PivotChart to determine the dairy sales by month in a separate worksheet in the workbook. Name the worksheet Dairy Sales by Month. See below for example: Change cell A4 to Month an d cell B 3 to Farm. Apply the Pivot Style Light 16 style to the PivotTable. Format the values as Currency values with a dollar sign and no decimal places. Turn off the legend for the chart. Filter the product type by Dairy. Filter the farm to Red Earth. Change the chart type to Line and then add a linear Trendline that forecasts the trend for two more months. Save the workbook. Using the concepts and techniques learned in the unit chapter’s readings, create the PivotTable and associated PivotChart to determine the sales by farm. Name the Change cell A4 to Month an d cell B 3 to Farm. Apply the Pivot Style Light 16 style to the PivotTable. Format the values as Currency values with a dollar sign and no decimal places. Turn off the legend for the chart. Filter the product type by Dairy. Filter the farm to Red Earth. Change the…

Attachments: