Attached are two Excel problems with more details about what need to be done. Thanks,
Customer ID QUICK SAVEB JONES UPALL MUDDY SMITH THEHI SHOPS SNACK QUEEN SOULA FLAGS GOODB TASTY Total Mean Standard Dev Company Name QUICK-Foods Save-Big Markets Jones & Sons Grocers Up All Night Market Muddy River Market Smith Family Grocery The Hill Market Shops on the Park Snack Quick Market Queen City Coffee Soulard Pastries Flagstaff Coffee and Tea Good Beverage Mart Tasty Snack and Beverage 2012 2013 117483 115673 113237 57317 52246 34101 32556 32204 31746 30226 29073 28723 26968 26260 % Change 1250253 114597 122659 62854 47523 33102 35698 39658 28745 22356 33345 26574 26995 32654 2014 % Change 125986 122698 135693 65269 52639 31205 33461 41365 29169 29471 36953 22569 21364 39654 Total Sales Coffee Company Quarterly Product Sales 2014 Product Name Q1 Q2 Chai tea 705.6 Dark roast special blend 2720.8 Light roast decaf 590.4 Lafayette medium roast 5127.36 Nutmeg vanilla blend 529.2 Rooibos blueberry tea 1398.4 White herbal tea 1141.92 Holiday blend coffee 5283.52 Costa Rican dark roast 1508.4 Hawaiian blue coffee 214.52 City blend medium roast 179.2 Special Early Grey tea 1742.4 Total Mean Median Q3 878.4 228 360 6806.1 467.55 4496.5 1774.08 2518 384 1508.92 1037.4 1008 Q4 1174.5 2061.5 1100.7 3312.12 219.37 1196 3261.6 3350 1252.5 1233.8 1125.5 1683 Total 2128.5 2028.25 2424.6 1317.5 337.5 3979 1705.5 5242 2683.5 1233.8 750.4 1273.5 Download the le \"Activity_ Coffee .xlsx\" and worksheet by doing the following: , 'n Cdmpute the yearly total for each product. . V" Compute the total (sum), mean, and median sales for each . . . ' _. Format the worksheet to improve readability. - Format the total sales gures (column H) to have a greet-1N background. 0 Create a chart showing for each'product (a) the total sales for the year and (b) the proportion of the total contributed by each quarter's sales. This should be shown on one chart. (Hint: Yen] should have one bar for each product.) ,I 0 Use the proper elements to add the le name and current date to the right- and left-hand footers. 0 Format the worksheet to have 1\" margins on the top, bottom, and each side. 0 Change the page orientation to landscape. 2. Download the le "Activity_Coffee_MultiYear.xlsx\" and complete the worksheet by doing the following: 5 Add the title \"Year-OvergYear Sales Report\" to cell A1. Insert a blank row below the title. - Format the title to be green text and a 14-point font size. (You phi year and (b) the proportion of the total contributed quarter's sales. This should be shown on one chart. ' . should have one bar for each product ) ' Use the proper elements to add the le name and current date to W right and left-hand footers. 0 Format the worksheet to have 1\" margins on the top, bottom, and each side -- ' Change the page orientation to landscape. 2. Download the le \"Activity_ Coffee _MultiYear. xlsx\" and complete the worksheet by doing the following: . Add the title \"Year-OverYear Sales Report\" to cell A1. Insert a blank row below the title. 0 Format the title to be green text and a 14-point font size. (You pick the font.) ' Calculate the percentage change from year to year (2011 to 2012 and 2013 to 2014). Percentage change is computed using the following formula: (current year sales-last year sales) / (last year sales). 0. CalCulate the total. sales for each customer. 0 Calculate the total, mean (average), and standard deviation for each . year. ' 0 Format the spreadsheet to improve readability. ' Create a chart showing the contribution of each product to 2014 total sales. a Add useful header and footer elements. (Use your own judgment.) ' Format the worksheet to have 1\" margins on the top and ham and 0 ."75 margins on each side. aha nace orientation to lands. =11, . m n /\"\\ ' ~. J \" * ' ,~. If'mu'!' .3 .v a1 ~ l \"'51; ' '7 ' ' q (marl
