Please answer the yellow cells. Provide steps if possible. Thanks!

The marketing department of the Cuddly Stuffed Animals, Inc. has provided a "Sales Data" sheet for last year. A quick review of the "Sales Data" sheet indicates that there are inconsistencies in the "Region" field. The file also contains tables for the products sold and a cross-tab table of unit shipping cost by product and regiom Sales Data {Sales Order Salesperson State, Region, Product Sales} Products {ld, Name, Unit Selling Price} Salesperson {Code, Name, Title} Shipping Costs per Unit {Unit Cost by product ID and Region} Required: 2 3 4 5 6 7 8 9 Create an automated process that can be used over and over agaim Stream 1: Extract the data from the "Sales Report" sheet. Transform the data to the correct values as found on the Region table. Stream 2: Extract the data from the "Products" sheet. Review the data, join to Stream 1 and verify the number of rows. Stream 3: Extract the data from the "Salesperson" sheet. Review the data, join to combined Stream 1 and Stream 2 and verify the number of rows. Stream 4: Extract the data from the "Shipping Costs" sheet. Review the data, create required fields and join to the previously combined streams. Verify that the number of rows has not changed _L Create the number of units sold (units sold=sales/selling price per unit) and the shipping cost (shipping cost=units sold x shipping cost per unit) for each invoice. For your project total sales are $11,351,352.00, units sold are 503,568 and total shipping costs are $1,022,708.76. As illustrated below, create a report that show the number of units sold and sales in dollars by product. As illustrated below, create a report that show the number of units sold, sales in dollars and shipping costs by salespersom As illustrated below, create a cross-tab report that show the shipping costs by product and regiom These three reports are to be saved in this Excel file. Sample reports Product Stuffed Bear Stuffed Elephant Stuffed Frog Stuffed Koala Stuffed Panda Stuffed IJnicorn Total B Product # of units 66,936 125,016 79,248 33,240 40,296 42,132 386,868 Sales S 2,625,336.00 S 1,743,456.00 S 797,760.00 S 926,808.00 S 842,640.00 Salesperson Ulysses Grant George Washington James Monroe John Tyler James Madison James Polk Total B Sales # of units 36,636 58,284 97,152 78,924 38,388 77,484 386,868 erson Sales Shipping Costs in Costs Product and Re ion $818,052.00 $854,412.00 $1, 723,956.00 $77,266.44 $123,242.28 $205,622.64 $166,596.00 $81,105.24 $163,717.08 $817,549.68 Stuffed Bear Stuffed Elephant Stuffed Frog Stuffed Koala Stuffed Panda Stuffed IJnicorn Grand Total S S S S S S S Midwest 26,904.00 54,810.00 36,405.60 14,094.00 16,875.60 13,648.20 162,737.40 S S S S S S S Northeast 43,048.44 72,060.84 52,861.20 20,699.28 26,664.00 30,604.32 245,938.08 S S S S S S S South 22,066.20 48,486.60 30,753.60 14,572.80 IS, 720.00 18,144.00 149,743.20 S S S S S S S West 41,647.80 86,971.80 54,081.00 25,364.40 23,108.40 27,957.60 259,131.00 S S S S S S Round other answers to the nearest whole unit or dollar 1 What were the sales of the Stuffed Koala product in dollars? 2 What were the sales in dollars for the product with the third lowest sales? 3 What were the units sold for the product with the third lowest number of units sold? 4 What were the shipping costs in dollars for the product with the fifth highest shipping costs? 5 What were the sales in dollars for the salesperson with the second highest sales? 6 What were the units sold for the salesperson with the second highest number of units sold? 7 What was the shipping costs in dollars for the salesperson with the second lowest shipping costs? 8 What were the shipping costs of the Stuffed Horse product in the region with the Stuffed Horse's second highest shipping cost? 9 What were the shipping costs of the Stuffed Elephant product in the region with the Stuffed Elephant's third highest shipping cost? 10 What were the shi in costs of the Stuffed Bear roduct in ther ion with the Stuffed Bear's third lowest shi in cost? Grand Total 133,666.44 262,329.24 174,101.40 74,730.48 82,368.00 90,354.12 817,549.68 {2} {3} {4} {5} {6} {7} {8} {9} 10