Question: Please help with excel steps, I will thumbs up. Thank you! File Home Insert Page Layout Formulas Data Review View Help Arial -10 28 General
Please help with excel steps, I will thumbs up. Thank you!
File Home Insert Page Layout Formulas Data Review View Help Arial -10 28 General - AA - - A E. Paste 49.0 8 IV- mert te Format $ - %) 8-9 Conditional Format Cell Formatting Table Styles Styles SON Gpboard Font Number C AI fi Order Date B D E F G J K 1 Orde Date Productio ProductName Quantity Unit Price Total Sales Unit Cost Total Cost Profit Customer Customer Sales 2 04.Jan Mosan cheese 41 $ 24.00 984 00 18.00 S 738 005 240.00 The Station (lan.11 16 Romanettone 90 5 15.00$ 1.350005 14001 260 00 S 90,00 315 The Station 4 05.Jan. 30 Red Onions 27 $12.00$ 324 005 0.005 216,00 108.00 BB 5 06.Jan 10 Romantic 67 5 15,00 1 00500 1400 910 00367.00 TA Smoke 6 07.11 2 Black alves 79 12.00 $948.00 3005 474005 47400 572 Fungintal Home 7 07 Jan.lt 10 Romaine lettuce 46 315 005 BR0.00 1400 04100 10.00 23 Twe 8 07 Jan. 11 10 Romance 52 5 15.00 5 790005 14.00 72800 S5200 6 Purce 9 30 Red Onions 19 $ 12.003 468.00 8.00 312.00 15.000 05 Mamma Pasta 10 09 Jan 11 TO Rorraine 55 315.00$ 990005 14.00 124.00 500.00 500 The Dance 10.11 Romance SA 15.0079005 14.00 11300 S800 557 cas LO 12 1011 30 Pineapple 40 5231820.00 28.00 520,00 200.00 315 Then 13 110-11 10 5 35005 2343005 28.000 15.00 The Dandelion 14 10.11 10 Romane letture 38 $ 15.00 270.00 16002520000 557 Loramech 15 14 18 Romance 20 5 15.00 420.005 14003392005200 Flagstaff Hout PH 16 15 Pepperoni 5 53.00 5 1749.003 35 00 155.00 $94.00 TE Timo HOUSE 17 Pan cheese 14 100S F 003 4,00 50 50 00 14 House 1B 16-18 100 Parmesan cheese 72 3 2005 576.004000.00 201.00 25 Mamma Pasta Palace Roberto 19 13.3.11 100 Parmesan cheese 10 5 8.00 5 80.00 4003 40.005 00 00 95 Mara Pasta Palace Lone Schult 20 16 Romantic S 15.003 630 00 $ 14 005 SBB 003 A2.00 14 Smoke Roberta 21 2011 4 Tomatoes 40 S 9.00 81.00 2005 336.000.00 23 Lorane fichi 22 21 an 11 33 Pepper 20 3 21 00 BOR DOS 1200 348 0020109 The Dandelion Roberta Cross 23 21.11 22 Moral these 10 52400 240 COS 18.00 180.005 00.00 05 Maua Pasta Pata PH 24 28-11 2 Black olives 98 $ 12.001 S 1176.00 6.00% 588.00 $ 585.00 23 Two Bus Roberta Cross mentale Customer Relatione nata TWO B Subtotals (5 points) 1. Copy the customer relations data onto the next worksheet and name it "Customer Subtotals" 2. On the customer subtotals worksheet, sort simultaneously by customer and product name in ascending order 3. Add subtotals to your data using the subtotal menu on the Data tab in the ribbon to subtotal the total quantity and sales for each customer 4. Examine the levels of subtotal and leave/display level 2 as your final answer. File Home Insert Page Layout Formulas Data Review View Help Arial -10 28 General - AA - - A E. Paste 49.0 8 IV- mert te Format $ - %) 8-9 Conditional Format Cell Formatting Table Styles Styles SON Gpboard Font Number C AI fi Order Date B D E F G J K 1 Orde Date Productio ProductName Quantity Unit Price Total Sales Unit Cost Total Cost Profit Customer Customer Sales 2 04.Jan Mosan cheese 41 $ 24.00 984 00 18.00 S 738 005 240.00 The Station (lan.11 16 Romanettone 90 5 15.00$ 1.350005 14001 260 00 S 90,00 315 The Station 4 05.Jan. 30 Red Onions 27 $12.00$ 324 005 0.005 216,00 108.00 BB 5 06.Jan 10 Romantic 67 5 15,00 1 00500 1400 910 00367.00 TA Smoke 6 07.11 2 Black alves 79 12.00 $948.00 3005 474005 47400 572 Fungintal Home 7 07 Jan.lt 10 Romaine lettuce 46 315 005 BR0.00 1400 04100 10.00 23 Twe 8 07 Jan. 11 10 Romance 52 5 15.00 5 790005 14.00 72800 S5200 6 Purce 9 30 Red Onions 19 $ 12.003 468.00 8.00 312.00 15.000 05 Mamma Pasta 10 09 Jan 11 TO Rorraine 55 315.00$ 990005 14.00 124.00 500.00 500 The Dance 10.11 Romance SA 15.0079005 14.00 11300 S800 557 cas LO 12 1011 30 Pineapple 40 5231820.00 28.00 520,00 200.00 315 Then 13 110-11 10 5 35005 2343005 28.000 15.00 The Dandelion 14 10.11 10 Romane letture 38 $ 15.00 270.00 16002520000 557 Loramech 15 14 18 Romance 20 5 15.00 420.005 14003392005200 Flagstaff Hout PH 16 15 Pepperoni 5 53.00 5 1749.003 35 00 155.00 $94.00 TE Timo HOUSE 17 Pan cheese 14 100S F 003 4,00 50 50 00 14 House 1B 16-18 100 Parmesan cheese 72 3 2005 576.004000.00 201.00 25 Mamma Pasta Palace Roberto 19 13.3.11 100 Parmesan cheese 10 5 8.00 5 80.00 4003 40.005 00 00 95 Mara Pasta Palace Lone Schult 20 16 Romantic S 15.003 630 00 $ 14 005 SBB 003 A2.00 14 Smoke Roberta 21 2011 4 Tomatoes 40 S 9.00 81.00 2005 336.000.00 23 Lorane fichi 22 21 an 11 33 Pepper 20 3 21 00 BOR DOS 1200 348 0020109 The Dandelion Roberta Cross 23 21.11 22 Moral these 10 52400 240 COS 18.00 180.005 00.00 05 Maua Pasta Pata PH 24 28-11 2 Black olives 98 $ 12.001 S 1176.00 6.00% 588.00 $ 585.00 23 Two Bus Roberta Cross mentale Customer Relatione nata TWO B Subtotals (5 points) 1. Copy the customer relations data onto the next worksheet and name it "Customer Subtotals" 2. On the customer subtotals worksheet, sort simultaneously by customer and product name in ascending order 3. Add subtotals to your data using the subtotal menu on the Data tab in the ribbon to subtotal the total quantity and sales for each customer 4. Examine the levels of subtotal and leave/display level 2 as your final

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
