Show all the work on excel
Excel Practice Exercise #4 Phoenix Merchandising Company (1) Download the Excel data file for Phoenix Merchandising Company from BlackBoard. Customer Sales for September 2014 (2) The worksheet presented list sales transactions by sales order number. Data: The data shown below is posted on BackBoard in an Excel file titled, "Excel Practice Data - (3) Make 4 additional copies of the worksheet and rename as follows: Phoenix Merchandising Company". Download the file and save before performing activities (a) Rename original worksheet, "Order #" requested. (b) Rename worksheet 2, "Customer Name" (c) Rename worksheet 3, "Order Date" Phoenix Merchandising Company (d) Rename worksheet 4, "Salesperson" Sales Transaction (e) Rename worksheet 5. "Store Location" September 2014 Order (a) Subtotal the Order # worksheet. Order it Customer Order Date Amount Salesperson Store Location (b) On the remaining worksheets, create subtotals by customer, coder date, salesperson, and store location using the Subtotal function. 50325 Target 9/1/2014 73192 F. Lemming 50326 S. Moore CA Wal-Mart 9/1/2014 51924 (4) The regional sales manager is especially interested in sales made in the states of 50327 Kmart 9/2/2014 39149 G. Sammy AZ Target 972/2014 A. Foreman WA Washington. Filter the data and show details of sales made in that state. 50328 52455 50329 Costco 9/3/2014 14461 R. Clemens OR 50330 Sears 9:4/2014 49518 A. Rod TX 50331 Costco 9/7/2014 30177 S. Moore CA 50332 Target 9/8/2014 21090 G. Sammy FL 50333 Kmart 9/9/2014 71433 AZ 50334 Target 9/10/2014 54275 S. Moore WA 50335 Costco 9/11/2014 16276 R. Clemens OR 50336 Kmart 9/14/2014 21028 A. Rod TX 50337 Kmart 9/15/2014 32809 A Foreman WA 50338 Wal-Mart 9/16/2014 22663 R. Clemens FL 50339 Kmart 9/17/2014 39509 A. Rod AZ 50340 Target 9/18/2014 26616 S. Moore WA 50341 Costco 9/18/2014 57573 G. Sammy OR 50342 Sears 9/21/2014 36967 A. Rod FL 50343 Wal Mart 9/21/2014 35274 R. Clemens OR 50344 Kmart 9122/2014 63419 F. Lemming CA 50345 Target 9/23/2014 23817 S. Moore AZ 50346 Castro 9/24/2014 39705 G. Sammy FL 50347 Sears 9:25/2014 70546 A. Foreman AZ 50348 Wal Mart 9/28/2014 60482 R. Clemens WA 50349 Kmart 9/28 2014 47847 A. Rod OR 50350 Target 9/28/2014 57965 R. Clemens FL. int Layout View Sec Pages: 1 of 2 Words: 0 of 356