Question: Please help with the excel steps if possible, will thumbs up. Thank you! File Home Insert View Help Arial X 06 Paste Page Layout Formulas
Please help with the excel steps if possible, will thumbs up. Thank you!
File Home Insert View Help Arial X 06 Paste Page Layout Formulas Data Review - 10-AA === 0.A.= == : 26 Accounting Insert Delete Format . BIU- $ - % Conditional Format at Cw Formatting Table Styles Sort Find & Filter Select Arual Da Clipboard Alignment Celle Editing A H2 028628 B D E F G K 1 OrderDate Productio ProductName Quantity Unit Price Total Sales Unit Cost Total Cost Profit Customer Customer Sales Rep 2 Dan 22 Marella che 4 $24.00 934 00 18.00 $ 730,00 200.00 315 The Station PHelgoth 3 0 10 Romantic 90 5 15.00 1.350.00 14.00 1.200.00390.00 215 The Station Roberta Cross 4 30 Red Onion 27 5 12003 324 00 8.00 210.00 100.00 Barts B Lorin Schult 5 DEALIT Bama 67 $ 15.00$ 1.005.00 1400 93.00 $7.00 Smoke House Roberta Crous 6 On 11 2 Blaces 7 $12.00 98,00 8.00 474 474.00 Flagstaff House Loraine Schule 7 D. 11 Romane $15.00 090.00 14.00 3 440.00 23 Tits Loraine chutz B 0.11 10 52 15.00 780.00 T4003 72800 5900 0 Pesce Ano Roberta Cross OBJan 11 30 Red Onion 20 $12.00 46 OD 3 8.00 31200 1 1000 95 Marta Pasta Palace Lars Schutz 10 OD 10 16 Home the 15 900.000 1400S 924:00 06.00 040 The Dandelion LOS 11 10-11 5 5 15 00 37000 3 14005 812005 58.00 557 Loraine Schultz 12 10-Jan-11 30 Pineapple 40 5330053202005 28.00 $120.00 20000 315 The station 13 11 Jan 11 39 Pineapple 71 S33.00 S 234300S 28.005 190.005 355,00 840 The Dander Loraine Schult 10 Romaine 18 191003170.00 14 005 252.00 1000 557 Cam Loraine Schulte 15 Jan 11 10 Romaine 7 $15.00 420003 14005 312092800 Flagstaff HOLE Helgoth 10 15-11 85 Pepperoni 53.00 1749005 05001355.00 54.00 14 Smoke House Robertas 17 TOO $ 100 11200 4001 50.00 50.00 14 Sincke House Lorare cu 18 15-Jan 11 Pamesan cheese 3 11.00 ST6.00 400 280.00 288.00 05 Marmo Rasta Palace Roberta Cross 1918-Jan-11 10 10 3 DOD BO DO 400 2000 54000 95 Maria Pasta Palace Loraine Schultz 2011 10 Romainen 42 5 1500 610.00 1400 568 004200 14 Smoke House Roberta Cross 21 2011 Tomatoes 5 900 13200 700 33000 3000 21 Two Brts Loraine Schule 22 21 Jun 11 31 Pepper 20 21.00 609003 200 348 00201.00 The Dandelion Roberta Cross 23 1 an 11 22 Matches 10 5 240025 240005 1800 100005 50.00 05 Pasta Palace PH 24 2 larves 02 1200 1600 500 KAROON 58000 Two | | | | Assignment Detail Customer Relations Data 72 Tables (5 points) 1. Examine the Assignment details worksheet and enter your full name. 2. Copy the customer relations data onto the next worksheet and name it "Customer Detail Table" 3. Convert the data on the customer detail table to a table. 4. Click anywhere in the data and click Insert>> Table. 5. Freeze the top row by using the appropriate option on the View tab in the ribbon. 6. Click anywhere in the data and add a Total Row by checking the box for Total Row in the Table tab on the ribbon. 7. Using the drop down on the total row, find the average quantity and total sales based on your data. File Home Insert View Help Arial X 06 Paste Page Layout Formulas Data Review - 10-AA === 0.A.= == : 26 Accounting Insert Delete Format . BIU- $ - % Conditional Format at Cw Formatting Table Styles Sort Find & Filter Select Arual Da Clipboard Alignment Celle Editing A H2 028628 B D E F G K 1 OrderDate Productio ProductName Quantity Unit Price Total Sales Unit Cost Total Cost Profit Customer Customer Sales Rep 2 Dan 22 Marella che 4 $24.00 934 00 18.00 $ 730,00 200.00 315 The Station PHelgoth 3 0 10 Romantic 90 5 15.00 1.350.00 14.00 1.200.00390.00 215 The Station Roberta Cross 4 30 Red Onion 27 5 12003 324 00 8.00 210.00 100.00 Barts B Lorin Schult 5 DEALIT Bama 67 $ 15.00$ 1.005.00 1400 93.00 $7.00 Smoke House Roberta Crous 6 On 11 2 Blaces 7 $12.00 98,00 8.00 474 474.00 Flagstaff House Loraine Schule 7 D. 11 Romane $15.00 090.00 14.00 3 440.00 23 Tits Loraine chutz B 0.11 10 52 15.00 780.00 T4003 72800 5900 0 Pesce Ano Roberta Cross OBJan 11 30 Red Onion 20 $12.00 46 OD 3 8.00 31200 1 1000 95 Marta Pasta Palace Lars Schutz 10 OD 10 16 Home the 15 900.000 1400S 924:00 06.00 040 The Dandelion LOS 11 10-11 5 5 15 00 37000 3 14005 812005 58.00 557 Loraine Schultz 12 10-Jan-11 30 Pineapple 40 5330053202005 28.00 $120.00 20000 315 The station 13 11 Jan 11 39 Pineapple 71 S33.00 S 234300S 28.005 190.005 355,00 840 The Dander Loraine Schult 10 Romaine 18 191003170.00 14 005 252.00 1000 557 Cam Loraine Schulte 15 Jan 11 10 Romaine 7 $15.00 420003 14005 312092800 Flagstaff HOLE Helgoth 10 15-11 85 Pepperoni 53.00 1749005 05001355.00 54.00 14 Smoke House Robertas 17 TOO $ 100 11200 4001 50.00 50.00 14 Sincke House Lorare cu 18 15-Jan 11 Pamesan cheese 3 11.00 ST6.00 400 280.00 288.00 05 Marmo Rasta Palace Roberta Cross 1918-Jan-11 10 10 3 DOD BO DO 400 2000 54000 95 Maria Pasta Palace Loraine Schultz 2011 10 Romainen 42 5 1500 610.00 1400 568 004200 14 Smoke House Roberta Cross 21 2011 Tomatoes 5 900 13200 700 33000 3000 21 Two Brts Loraine Schule 22 21 Jun 11 31 Pepper 20 21.00 609003 200 348 00201.00 The Dandelion Roberta Cross 23 1 an 11 22 Matches 10 5 240025 240005 1800 100005 50.00 05 Pasta Palace PH 24 2 larves 02 1200 1600 500 KAROON 58000 Two | | | | Assignment Detail Customer Relations Data 72 Tables (5 points) 1. Examine the Assignment details worksheet and enter your full name. 2. Copy the customer relations data onto the next worksheet and name it "Customer Detail Table" 3. Convert the data on the customer detail table to a table. 4. Click anywhere in the data and click Insert>> Table. 5. Freeze the top row by using the appropriate option on the View tab in the ribbon. 6. Click anywhere in the data and add a Total Row by checking the box for Total Row in the Table tab on the ribbon. 7. Using the drop down on the total row, find the average quantity and total sales based on your data

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
