Show all the work

Formatti K37 B D Phoenix Merchandising Company 2 Sales Transactions by Order Number 3 September 2014 Order # Customer Order Date Order Amount Salesperson Store Location 50325 Target 9/1/14 73192 F. Lemming CA 6 50326 Wal-Mart 9/1/14 51924 S. Moore 50327 Kmart 9/2/14 39149 G. Sammy AZ 8 50328 9/2/14 A. Foreman WA (1) Download the Excel data file for Phoenix Merchandising Company from BlackBoard. 9 Target $52,455 50329 Costco 9/3/14 $14,461 R. Clemens OR 10 50330 Sears 9/4/14 $49.516 A. Rod TX (2) The worksheet presented list sales transactions by sales order number. 11 50331 Castro 9/7/14 $30,177 S. Moore CA 12 0332 Target 9/8/14 $21,090 G. Sammy FL 13 50333 Kmart 9/9/14 $71,433 A. Foreman AZ (3) Make 4 additional copies of the worksheet and rename as follows: 14 5033 Target 9/10/14 $54,275 S. Moore WA (a) Rename original worksheet, "Order #" 15 50335 Costco 9/11/14 $16,276 R. Clemens OR (b) Rename worksheet 2, "Customer Name" 16 50336 Kmar 9/14/14 $21,028 A. Rod TX (c) Rename worksheet 3, "Order Date" 17 50337 Kmar 9/15/14 $32,809 A. Foreman WA (d) Rename worksheet 4, "Salesperson" 18 50338 Wall-Mart 9/16/14 $22,663 R. Clemens FL (e) Rename worksheet 5, "Store Location" 19 50339 Kmart 9/17/14 $39,509 A. Rod AZ 20 50340 Targe 9/18/14 $26,616 S. Moore WA 21 50341 Costco 9/18/14 $57,573 G. Sammy OR (a) Subtotal the Order # worksheet. 2Z 50342 Sears 9/21/14 $36,967 A. Rod FL (b) On the remaining worksheets, create subtotals by customer, 23 50343 Wal-Mart 9/21/14 $35,274 R. Clemens OR order date, salesperson, and store location using the Subtotal function. 24 50344 Kmart 9/22/14 $63.419 F. Lemming CA 25 50345 Target 9/23/14 $23,817 S. Moore AZ (4) The regional sales manager is especially interested in sales made in the states of 26 50346 Costco 9/24/14 $39,705 G. Sammy FL Washington. Filter the data and show details of sales made in that state. 27 50347 Sears 9/25/14 $70,546 A. Foreman AZ 28 50348 Wal-Mart 9/28/14 $60,482 R. Clemens WA 29 50349 Kmart 9/28/14 $47.847 A. Rod OR 30 50350 Target 9/28/14 $57,965 R. Clemens FL 31 Total Sales $1,110,168 32 33 34 135 36 37 38 Order # + Normal View Ready