Please help my solve the yellow boxes. I have no idea how to start this.

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 region. Sales Data \{Sales Order \#, Salesperson \#, State, Region, Product \#, Sales\} Products \{Id, Name, Unit Selling Price } Salesperson \{Code, Name, Title\} Shipping Costs per Unit \{Unit Cost by product ID and Region } Required: 1 Stream 1: Extract the data from the "Sales Report" sheet. Transform the data to the correct values as found on the Region table. 2 Stream 2: Extract the data from the "Products" sheet. Review the data, join to Stream 1 and verify the number of rows. 3 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. 4 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. 5 Create fields to calculate sales in dollars and the shipping cost for each invoice. The total sales for your project is $11,300,052.00. 6 As illustrated below, create a cross-tab report that show the units sold, sales and profit margin for each salesperson. 7 As illustrated below, create a report that show the cost of shipping by product and region. 8 Export the three reports to this Excel file. Sample reports By Product \begin{tabular}{|lrr|} \hline Product & \# of units & Sales \\ \hline Stuffed Bear & 66,936 & $1,673,400.00 \\ Stuffed Elephant & 125,016 & $2,625,336.00 \\ Stuffed Frog & 79,248 & $1,743,456.00 \\ Stuffed Koala & 33,240 & $797,760.00 \\ Stuffed Panda & 40,296 & $926,808.00 \\ Stuffed Unicorn & 42,132 & $842,640.00 \\ \hline Total & 386,868 & $8,609,400.00 \\ \hline \hline & & \\ \hline \end{tabular} By Salesperson \begin{tabular}{|lrrr|} \hline Salesperson & \# of units & \multicolumn{1}{c|}{ Sales } & Shipping Costs \\ \hline Ulysses Grant & 36,636 & $818,052.00 & $77,266.44 \\ George Washingto & 58,284 & $1,299,192.00 & $123,242.28 \\ James Monroe & 97,152 & $2,162,436.00 & $205,622.64 \\ John Tyler & 78,924 & $1,751,352.00 & $166,596.00 \\ James Madison & 38,388 & $854,412.00 & $81,105.24 \\ James Polk & 77,484 & $1,723,956.00 & $163,717.08 \\ \hline Total & 386,868 & $8,609,400.00 & $817,549.68 \\ \hline \hline & & & \\ \hline \end{tabular} Round other answers to the nearest whole unit or \begin{tabular}{|l|l|} \hline 1 What were the sales of the Stuffed Bear product in dollars? & \\ \hline 2 What were the shipping costs in dollars for the product with the third lowest shipping costs? \\ \hline 3 What were the units sold for the product with the second lowest number of units sold? \\ \hline 4 What were the sales in dollars for the product with the second lowest sales? & \\ \hline 5 What was the shipping costs in dollars for the salesperson with the fourth highest shipping costs? \\ \hline 6 What were the units sold for the salesperson with the third lowest number of units sold? \\ \hline 7 What were the sales in dollars for the salesperson with the fifth highest sales? \\ \hline 8 What were the shipping costs of the Stuffed Bear product in the region with the Stuffed Bear's third highest shiping cost? \\ \hline 9 What were the shipping costs of the Stuffed Horse product in the region with the Stuffed Horse's second highest shiping cost? \\ \hline 10 What were the shipping costs of the Stuffed Koala product in the region with the Stuffed Koala's second highest shiping cost? & \\ \hline \end{tabular} Cuddly Stuffed Animals Product Information \begin{tabular}{|c|c|r|r|r|} \hline Product ID & Product & Unit Selling Price & Unit Manufacturing Cost & Profit Margin by Product \\ \hline 101 Stuffed Horse & 20.00 & 9.25 & 10.75 \\ \hline 102 Stuffed Frog & 22.00 & 10.75 & 11.25 \\ \hline 103 Stuffed Koala & 24.00 & 11.75 & 12.25 \\ \hline 104 Stuffed Elephant & 21.00 & 9.75 & 11.25 \\ \hline 105 Stuffed Panda & 23.00 & 10.50 & 12.50 \\ \hline 106 Stuffed Bear & 25.00 & 9.25 & 15.75 \\ \hline \end{tabular} Cuddly Stuffed Animals Salesperson Information Cuddly Stuffed Animals Region Information Cuddly Stuffed Animals Shipping Cost Per Unit \begin{tabular}{|r|cccc|} \hline Product ID & \multicolumn{4}{|c|}{ Region } \\ & Midwest & Northeast & South & West \\ \hline 101 & 2.15 & 2.13 & 2.10 & 2.00 \\ \hline \hline 102 & 2.11 & 2.09 & 2.06 & 1.96 \\ \hline \hline 103 & 2.14 & 2.12 & 2.09 & 1.99 \\ \hline \hline 104 & 2.11 & 2.09 & 2.06 & 1.96 \\ \hline \hline 105 & 2.07 & 2.05 & 2.02 & 1.92 \\ \hline 106 & 2.03 & 2.01 & 1.98 & 1.88 \\ \hline \end{tabular} \begin{tabular}{|r|l|l|c|c|c|} \hline & & \multicolumn{4}{c}{ Cuddly Stuffed Animals } \\ \hline & & & & Sales \\ \hline Sales Order \# & Salesperson \# & Region & State & Product\# & Sales \\ \hline 35005 & 1305 & South & WV & 104 & 3,024.00 \\ \hline 35006 & 1305 & West & CA & 103 & 2,016.00 \\ \hline 35009 & 1303 & Midwest & IL & 101 & 3,120.00 \\ \hline 35011 & 1303 & West & MT & 105 & 3,312.00 \\ \hline 35014 & 1305 & Northeast & VT & 106 & 1,800.00 \\ \hline 35017 & 1305 & Midwest & IN & 104 & 1,260.00 \\ \hline 35025 & 1305 & South & MD & 106 & 2,100.00 \\ \hline 35026 & 1302 & Northeast & CT & 106 & 3,300.00 \\ \hline 35027 & 1303 & Northeast & NJ & 106 & 3,000.00 \\ \hline 35032 & 1303 & West & AZ & 101 & 3,120.00 \\ \hline 35041 & 1303 & South & TX & 106 & 3,300.00 \\ \hline 35046 & 1305 & South & DE & 102 & 3,168.00 \\ \hline 35052 & 1305 & South & WV & 101 & 2,400.00 \\ \hline 35057 & 1301 & South & LA & 101 & 2,160.00 \\ \hline 35058 & 1304 & Midwest & MN & 104 & 3,528.00 \\ \hline 35063 & 1301 & Northeast & MA & 101 & 3,600.00 \\ \hline 35072 & 1304 & South & WV & 104 & 1,764.00 \\ \hline 35074 & 1306 & South & VA & 101 & 1,680.00 \\ \hline \end{tabular} 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 region. Sales Data \{Sales Order \#, Salesperson \#, State, Region, Product \#, Sales\} Products \{Id, Name, Unit Selling Price } Salesperson \{Code, Name, Title\} Shipping Costs per Unit \{Unit Cost by product ID and Region } Required: 1 Stream 1: Extract the data from the "Sales Report" sheet. Transform the data to the correct values as found on the Region table. 2 Stream 2: Extract the data from the "Products" sheet. Review the data, join to Stream 1 and verify the number of rows. 3 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. 4 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. 5 Create fields to calculate sales in dollars and the shipping cost for each invoice. The total sales for your project is $11,300,052.00. 6 As illustrated below, create a cross-tab report that show the units sold, sales and profit margin for each salesperson. 7 As illustrated below, create a report that show the cost of shipping by product and region. 8 Export the three reports to this Excel file. Sample reports By Product \begin{tabular}{|lrr|} \hline Product & \# of units & Sales \\ \hline Stuffed Bear & 66,936 & $1,673,400.00 \\ Stuffed Elephant & 125,016 & $2,625,336.00 \\ Stuffed Frog & 79,248 & $1,743,456.00 \\ Stuffed Koala & 33,240 & $797,760.00 \\ Stuffed Panda & 40,296 & $926,808.00 \\ Stuffed Unicorn & 42,132 & $842,640.00 \\ \hline Total & 386,868 & $8,609,400.00 \\ \hline \hline & & \\ \hline \end{tabular} By Salesperson \begin{tabular}{|lrrr|} \hline Salesperson & \# of units & \multicolumn{1}{c|}{ Sales } & Shipping Costs \\ \hline Ulysses Grant & 36,636 & $818,052.00 & $77,266.44 \\ George Washingto & 58,284 & $1,299,192.00 & $123,242.28 \\ James Monroe & 97,152 & $2,162,436.00 & $205,622.64 \\ John Tyler & 78,924 & $1,751,352.00 & $166,596.00 \\ James Madison & 38,388 & $854,412.00 & $81,105.24 \\ James Polk & 77,484 & $1,723,956.00 & $163,717.08 \\ \hline Total & 386,868 & $8,609,400.00 & $817,549.68 \\ \hline \hline & & & \\ \hline \end{tabular} Round other answers to the nearest whole unit or \begin{tabular}{|l|l|} \hline 1 What were the sales of the Stuffed Bear product in dollars? & \\ \hline 2 What were the shipping costs in dollars for the product with the third lowest shipping costs? \\ \hline 3 What were the units sold for the product with the second lowest number of units sold? \\ \hline 4 What were the sales in dollars for the product with the second lowest sales? & \\ \hline 5 What was the shipping costs in dollars for the salesperson with the fourth highest shipping costs? \\ \hline 6 What were the units sold for the salesperson with the third lowest number of units sold? \\ \hline 7 What were the sales in dollars for the salesperson with the fifth highest sales? \\ \hline 8 What were the shipping costs of the Stuffed Bear product in the region with the Stuffed Bear's third highest shiping cost? \\ \hline 9 What were the shipping costs of the Stuffed Horse product in the region with the Stuffed Horse's second highest shiping cost? \\ \hline 10 What were the shipping costs of the Stuffed Koala product in the region with the Stuffed Koala's second highest shiping cost? & \\ \hline \end{tabular} Cuddly Stuffed Animals Product Information \begin{tabular}{|c|c|r|r|r|} \hline Product ID & Product & Unit Selling Price & Unit Manufacturing Cost & Profit Margin by Product \\ \hline 101 Stuffed Horse & 20.00 & 9.25 & 10.75 \\ \hline 102 Stuffed Frog & 22.00 & 10.75 & 11.25 \\ \hline 103 Stuffed Koala & 24.00 & 11.75 & 12.25 \\ \hline 104 Stuffed Elephant & 21.00 & 9.75 & 11.25 \\ \hline 105 Stuffed Panda & 23.00 & 10.50 & 12.50 \\ \hline 106 Stuffed Bear & 25.00 & 9.25 & 15.75 \\ \hline \end{tabular} Cuddly Stuffed Animals Salesperson Information Cuddly Stuffed Animals Region Information Cuddly Stuffed Animals Shipping Cost Per Unit \begin{tabular}{|r|cccc|} \hline Product ID & \multicolumn{4}{|c|}{ Region } \\ & Midwest & Northeast & South & West \\ \hline 101 & 2.15 & 2.13 & 2.10 & 2.00 \\ \hline \hline 102 & 2.11 & 2.09 & 2.06 & 1.96 \\ \hline \hline 103 & 2.14 & 2.12 & 2.09 & 1.99 \\ \hline \hline 104 & 2.11 & 2.09 & 2.06 & 1.96 \\ \hline \hline 105 & 2.07 & 2.05 & 2.02 & 1.92 \\ \hline 106 & 2.03 & 2.01 & 1.98 & 1.88 \\ \hline \end{tabular} \begin{tabular}{|r|l|l|c|c|c|} \hline & & \multicolumn{4}{c}{ Cuddly Stuffed Animals } \\ \hline & & & & Sales \\ \hline Sales Order \# & Salesperson \# & Region & State & Product\# & Sales \\ \hline 35005 & 1305 & South & WV & 104 & 3,024.00 \\ \hline 35006 & 1305 & West & CA & 103 & 2,016.00 \\ \hline 35009 & 1303 & Midwest & IL & 101 & 3,120.00 \\ \hline 35011 & 1303 & West & MT & 105 & 3,312.00 \\ \hline 35014 & 1305 & Northeast & VT & 106 & 1,800.00 \\ \hline 35017 & 1305 & Midwest & IN & 104 & 1,260.00 \\ \hline 35025 & 1305 & South & MD & 106 & 2,100.00 \\ \hline 35026 & 1302 & Northeast & CT & 106 & 3,300.00 \\ \hline 35027 & 1303 & Northeast & NJ & 106 & 3,000.00 \\ \hline 35032 & 1303 & West & AZ & 101 & 3,120.00 \\ \hline 35041 & 1303 & South & TX & 106 & 3,300.00 \\ \hline 35046 & 1305 & South & DE & 102 & 3,168.00 \\ \hline 35052 & 1305 & South & WV & 101 & 2,400.00 \\ \hline 35057 & 1301 & South & LA & 101 & 2,160.00 \\ \hline 35058 & 1304 & Midwest & MN & 104 & 3,528.00 \\ \hline 35063 & 1301 & Northeast & MA & 101 & 3,600.00 \\ \hline 35072 & 1304 & South & WV & 104 & 1,764.00 \\ \hline 35074 & 1306 & South & VA & 101 & 1,680.00 \\ \hline \end{tabular}