Problem: You work for Matchbox Financial and help the CFO 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. The other PivotTable and PivotChart summarize the digital products sales by month for the top supplier. Perform the following tasks: 1. Open the workbook, Lab 8 Matchbox Financial from the Data Files folder and save the workbook as LastnameFirstnameModule8Lab. 2. Create a new worksheet before the Sales Results worksheet with your name in cell A1, date in cell A2, course in cell A3, instructor name in cell A4, and assignment name in cell A5. Name this worksheet "Module 8Lab Assignment Info". 3. Using the data in the Sales Results worksheet, create a PivotTable in a separate worksheet named "Sales by Supplier". Move this worksheet after "Sales Results" and change the worksheet tab color to orange. The PivotTable needs to start in cell A3; Store is in Columns, Supplier is in Rows, and Sum of Sales is in Values; sort Store and Supplier by A-Z) 4. Change the contents of cell A4 (Row Labels) to Supplier and cell B3 (Column Labels) to Store. Apply the 'Pivot Style Dark 21' style to the PivotTable (data font color is white, data background color is brown, column heading row and Grand Total row font color is white/background color is black). Format the values as currency values with a dollar sign and no decimal places. 5. Create a Clustered Column PivotChart from the PivotTable data. Resize the PivotChart to cover the range A18:G35 and then hide ALL field buttons. Apply the 'Chart Style 14' to the PivotChart (last chart style in selection menu). 6. Using the data in the "Sales Results" worksheet, create a second PivotTable (should start in cell A3; Store is in Columns, Month is in Rows, Sum of Sales is in Values, and Category is in Filters; sort Store and Month by A-Z) in a separate worksheet in the workbook named "Digital Product Sales by Month". Move this worksheet after "Sales by Supplier". 7. Change the contents of cell A4 (Row Labels) to Months and cell B3 (Column Labels) to Store. Apply the 'Pivot Style Dark 7' style to the PivotTable (data font color is black, data background color is tan, column heading row and Grand Total row font color is white/background color is brown). Format the values as currency values with a dollar sign and no decimal places. Filter the category by Digital Products. Filter the store to Wilton Wholesale Club. 8. Create a Line PivotChart from the PivotTable data. Resize the PivotChart to cover the range D1:H16 and then hide ALL field buttons. Apply the 'Chart Style 15 ' to the PivotChart (last chart style in selection menu). Delete the legend. Now, add a linear trendline that forecasts the trend for three more months. Add the R-squared value to the trendline and make it visible. \begin{tabular}{|c|c|c|c|c|} \hlineA & C & D & E & F \\ \hline & \multicolumn{4}{|c|}{ Matchbox Financial } \\ \hline 2 & \multicolumn{4}{|c|}{ Sales Results } \\ \hline 3 & Supplier & Category & Store & Sales \\ \hline 4 & 1 Eastern Imports & Housewares & KJ Maxx & $11,068 \\ \hline 5 & 1 The Digital Shelf & Digital Products & Wilton Wholesale Club & $26,949 \\ \hline 6 & 1 StrongCore & Sporting Goods & KJ Maxx & $10,820 \\ \hline 7 & 1 Silkroad Stockist & Accessories & Amarie's Emporium & $9,207 \\ \hline 8 & 2 Eastern Imports & Housewares & KJ Maxx & $14,218 \\ \hline 9 & 2 The Digital Shelf & Digital Products & Wilton Wholesale Club & $27,640 \\ \hline 10 & 3 Edison Electronic & Digital Products & Market Depot & $12,416 \\ \hline 11 & 3 Eastern Imports & Housewares & KJ Maxx & $9,649 \\ \hline 12 & 3 The Digital Shelf & Digital Products & Wilton Wholesale Club & $31,298 \\ \hline 13 & 4 Edison Electronic & Digital Products & Market Depot & $14,282 \\ \hline 14 & 4 StrongCore & Sporting Goods & Hendricks & $18,758 \\ \hline 15 & 4 Ivy T's & Apparel & KJ Maxx & $37,936 \\ \hline 16 & 4 Eastern Imports & Housewares & KJ Maxx & $19,272 \\ \hline 17 & 4 The Digital Shelf & Digital Products & Wilton Wholesale Club & $32,011 \\ \hline 18 & 4 Silkroad Stockist & Accessories & Amarie's Emporium & $12,967 \\ \hline 19 & 5 Edison Electronic & Digital Products & Market Depot & $11,643 \\ \hline 20 & 5 Ivy T's & Apparel & KJ Maxx & $7,174 \\ \hline 21 & 5 StrongCore & Sporting Goods & Hendricks & $13,292 \\ \hline 22 & 5 The Digital Shelf & Digital Products & Wilton Wholesale Club & $24,087 \\ \hline 23 & 6 Edison Electronic & Digital Products & Market Depot & $22,569 \\ \hline 24 & 6 Homestyle Furnishings & Furniture & Wilton Wholesale Club & $19,625 \\ \hline 25 & 6 The Digital Shelf & Digital Products & Wilton Wholesale Club & $23,918 \\ \hline 26 & 6 Silkroad Stockist & Accessories & Amarie's Emporium & $9,919 \\ \hline 27 & 7 Edison Electronic & Digital Products & Market Depot & $14,585 \\ \hline & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hlinek & B & D & E & F \\ \hline 29 & 7 Homestyle Furnishings & Furniture & Wilton Wholesale Club & $22,119 \\ \hline 30 & 7 StrongCore & Sporting Goods & KJ Maxx & $16,175 \\ \hline 31 & 7 Eastern Imports & Housewares & KJ Maxx & $13,427 \\ \hline 32 & 7 The Digital Shelf & Digital Products & Wilton Wholesale Club & $21,058 \\ \hline 33 & 8 Edison Electronic & Digital Products & Market Depot & $14,091 \\ \hline 34 & 8 Wrentham Workwear & Apparel & Hendricks & $14,618 \\ \hline 35 & 8 Holling \& Sons & Apparel & Market Depot & $9,550 \\ \hline 36 & 8 Davis Family Apparel & Apparel & Amarie's Emporium & $17,151 \\ \hline 37 & 8 Ivy T's & Apparel & KJ Maxx & $11,051 \\ \hline 38 & 8 Martin's Kitchen Suppliers & Housewares & Market Depot & $20,157 \\ \hline 39 & 8 Silkroad Stockist & Accessories & Amarie's Emporium & $11,923 \\ \hline 40 & 9 Edison Electronic & Digital Products & Market Depot & $12,218 \\ \hline 41 & 9 Wrentham Workwear & Apparel & KJ Maxx & $11,532 \\ \hline 42 & 9 Holling \& Sons & Apparel & Market Depot & $15,367 \\ \hline 43 & 9 lvy T's & Apparel & KJ Maxx & $13,058 \\ \hline 44 & 9 Martin's Kitchen Suppliers & Housewares & Market Depot & $12,184 \\ \hline 45 & 9 The Digital Shelf & Digital Products & Wilton Wholesale Club & $28,158 \\ \hline 46 & 9 Silkroad Stockist & Accessories & Amarie's Emporium & $10,855 \\ \hline 47 & 10 Edison Electronic & Digital Products & Market Depot & $21,721 \\ \hline 48 & 10 Wrentham Workwear & Apparel & KJ Maxx & $14,539 \\ \hline 49 & 10 Holling \& Sons & Apparel & Market Depot & $12,310 \\ \hline 50 & 10 StrongCore & Sporting Goods & Hendricks & $13,874 \\ \hline 51 & 10 Martin's Kitchen Suppliers & Housewares & Market Depot & $13,824 \\ \hline 52 & 10 The Digital Shelf & Digital Products & Wilton Wholesale Club & $32,438 \\ \hline 53 & 10 Silkroad Stockist & Accessories & Amarie's Emporium & $10,742 \\ \hline 54 & 11 Edison Electronic & Digital Products & Market Depot & $26,429 \\ \hline 55 & 11 Wrentham Workwear & Apparel & Hendricks & $14,801 \\ \hline 56 & 11 Eastern Imports & Housewares & Amarie's Emporium & $21,485 \\ \hline 57 & 11 New Age Home & Furniture & KJ Maxx & $28,523 \\ \hline 58 & 11 Martin's Kitchen Suppliers & Housewares & Market Depot & $12,335 \\ \hline 59 & 11 The Digital Shelf & Digital Products & Wilton Wholesale Club & $17,333 \\ \hline \end{tabular} \begin{tabular}{l|l|l|l|l|} \hline & \multicolumn{1}{c|}{ C } & \multicolumn{1}{c|}{ D } & \multicolumn{1}{c|}{ E } \\ \hline 60 & 11 New Age Home & Furniture & Amarie's Emporium & $18,443 \\ \hline 61 & 12 Eastern Imports & Digital Products & Amarie's Emporium & $21,613 \\ \hline 62 & 12 The Digital Shelf & Digital Products & Wilton Wholesale Club & $15,639 \\ \hline 63 & 12 New Age Home & Furniture & Amarie's Emporium & $27,714 \\ \hline 64 & 12 Edison Electronic & Digital Products & Market Depot & $24,763 \end{tabular}