Creating a PivotTable, PivotChart, and Trendlin . . . Problem: You work for Altar Holdings and help the financial director prepare and analyze revenue and expense reports. He has asked you to create two PivotTables and corresponding PivotCharts based on sales data. One PivotTable and PivotChart summarize the sales by Supplier (Figure 1). The other PivotTable and PivotChart summarize the Digital Products sales by month for the top supplier (Figure 2). Perform the following tasks: 1. Download and open the workbook Altar Holdings.xIsx from assignment box and then save the workbook using the name, Altar Holdings Complete (your Name). 2. Using the data in the Sales Results worksheet, create the PivotTable and associated PivotChart shown in Figure 1 in a separate worksheet in the workbook. Name the worksheet Sales by Supplier. 3. Change the contents of cell A4 to Supplier and cell B3 to Store. Apply the 'Pivot Style Dark 21'style to the PivotTable. Format the values as currency values with a dollar sign and no decimal places. Apply the chart Style 14 to the PivotChart. Resize the PivotChart to cover the rangeA18:G35 and then hide the field buttons. 4. Create a second PivotTable and associated PivotChart, as shown in Figure 2 in a separate worksheet in the workbook. Name the worksheet Digital Product Sales by Month. 5. Change the contents of cell A4 to Month and cell B3 to Store. Apply the 'Pivot Style Dark 4'style to the PivotTable. Format the values as currency values with a dollar sign and no decimal places. 6. Filter the category by Digital Products. Filter the store to O.G.'s Wholesale Club 7. Change the chart type to Line and then add a linear trendline that forecasts the trend for three more months. Add the R-squared value to the trendline. Apply the chart Style 15 to the PivotChart and then hide the field buttons. Delete the legend. Resize the chart to the range D1:H16. B. If requested by your instructor, add the text, contact number, followed by your phone number to cell B66 of the Sales Results worksheet. 9. Save the workbook. Submit the revised document in the format specified by your instructor. 10. How helpful is the monthly breakdown when analyzing sales of various products? Altar Holdings Sales Results Eastern Imports Housewares Omarell's $11,068 The Digital Shelf Digital Products O.G.'s Wholesale Club $26,949 1 StrongCore Sporting Goods Omarell' $10,820 Silkroad Stockist Accessories Ivy T's Emporium $9,207 2 Eastern Imports Housewares Omarell's $14,218 2 The Digital Shelf Digital Products O.G.'s Wholesale Club $27,640 3 Edison Electronic Digital Products Livingston 12,416 Eastern Imports Housewares Omarell's $9,649 3 The Digital Shelf Digital Products O.G.'s Wholesale Club $31,298 4 Edison Electronic Digital Product Livingston $14,282 StrongCore Sporting Goods Hendricks $18,758 4 Ivy T's Appare Omarell's $37,936 4 Eastern Imports Housewares Omarell's 19,272 4 The Digital Shelf Digital Products O.G.'s Wholesale Club $32,011 4 Silkroad Stockist Accessories Ivy T's Emporium $12,967 5Edison Electronic Digital Products Livingston $11,643 5Ivy T's Apparel marell's $7,174 5 StrongCore Sporting Goods Hendricks $13,292 The Digital Shelf Digital Products O.G.'s Wholesale Club $24,087 6 Edison Electronic Digital Products Livingston $22,569 Homestyle Furnishings Furniture O.G.'s Wholesale Club $19,625 6 The Digital Shelf Digital Products O.G.'s Wholesale Club $23,918 6 Silkroad Stockist Accessories Ivy T's Emporium $9,919 7 Edison Electronic Digital Products Livingston $14,585 7 Wrentham Workwear Apparel marell's $20,498 7 Homestyle Furnishings Furniture O.G.'s Wholesale Club $22,119 7 StrongCore Sporting Goods Omarell's $16,175 7 Eastern Imports Housewares Omarell's $13,427 The Digital Shelf Digital Products O.G.'s Wholesale Club $21,058 Edison Electronic Digital Products Livingston $14,091 Wrentham Workwear Appare Hendricks $14,618 Holling & Sons Apparel Livingston $9,550 8 Davis Family Apparel Apparel Ivy T's Emporium $17,151 Ivy T's Apparel Omarell's $11,051 8 Martin's Kitchen Suppliers Housewares Livingston $20,157 8 Silkroad Stockist Accessories vy T's Emporium $11,923 9 Edison Electronic Digital Products Livingston $12,218 Wrentham Workwear Apparel Omarell's $11,532 Holling & Sons Apparel Livingston $15,367 Ivy T's Appare marell's $13,058 9 Martin's Kitchen Suppliers Housewares Livingston $12,184 9 The Digital Shelf Digital Products O.G.'s Wholesale Club $28, 158 Silkroad Stockist Accessories Ivy T's Emporium $10,855 10 Edison Electronic Digital Products Livingston $21,721 0 Wrentham Workwear Appare Omarell's $14,539 10 Holling & Sons Apparel Livingston $12,310 0 StrongCore Sporting Goods Hendricks $13,874 10 Martin's Kitchen Suppliers Housewares Livingston $13,824 10 The Digital Shelf Digital Products O.G.'s Wholesale Club $32,438 10 Silkroad Stockist Accessories Ivy T's Emporium $10,742 1 Edison Electronic Digital Products Livingston $26,429 11 Wrentham Workwear Apparel Hendricks $14,801 11 Eastern Imports Housewares Ivy T's Emporium $21,485 11 New Age Home Furniture Omarell's $28,523 11 Martin's Kitchen Suppliers Housewares Livingston $12,335 1 The Digital Shelf Digital Products O.G.'s Wholesale Club $17,333 11 New Age Home Furniture Ivy T's Emporium $18,443 12 Eastern Imports Digital Products Ivy T's Emporium $21,613 12 The Digital Shelf Digital Products O.G.'s Wholesale Club $15, 639 12 New Age Home Furniture Ivy T's Emporium $27,714 12 Edison Electronic Digital Products Livingston $24.763