Task Guide Submit View Report C D Bullt-tough Boards sells outside bulletin boards used to display community information on the outside of buildings. They sell blue and red bulletin boards which they will deliver regionally up to 1000 miles While they offer a discount for purchasing in bulk, they require customers to buy at least two bulletin boards at a time. The table below lists 25 recent sales. Each order lista the color of the boards ordered the number to be shipped with the order, and the distance of the delivery in miles. Complete the table by using the VLOOKUP and HLOOKUP functions in Excel to calculate the number of days it will take for delivery, the delivery price, and the price of the signs for each order. Days Delivery Price Order 1 2 3 Total so 50 $0 $0 $o $0 SO Color Red Blue Red Red Red Blue Red Blue Blue Blue Red Blue Blue Blue Blue ) Blue Delivery information Miles Days Price 0 1 $20.00 50 2 $30.00 100 3 $50.00 200 5 $75.00 400 7 $150.00 800 8 $400.00 5 7 Product Pricing Shipped Red 2 $300 $500 3 $400 $700 4 $500 5800 5 $500 $975 6 $700 $1,100 7 5800 51,200 8 $500 $1350 9 $1,000 51.425 10 51.100 $1.550 Shipped Distance 4 845 10 421 5 5 7 883 4 151 9 112 7 862 9 17 2 486 9 195 374 4 74 7 17 6 822 940 4 140 3 56 10 823 2 705 T 3 35 10 11 12 13 14 15 16 $ $0 Hinton Task 5 Note that the 3rd argument within the HLOOKUP function is the row index_num. It specifies how many rows to go down within the matching column to find the right value to return as the function results regalsus to use therewinde number argument sightly differently than we have in prior problems. For each order, the shipped vale specified in Column happens te be the desired Row Indeum for that ander when the table mais ecified correctly, you should refer to the respective Column cell for the 3rd HLOOKUP ment. The row_index_fmument will be a reference to tell in column Drather than a fixed number 18 19 20 $0 $0 so $0 SO $0 50 50 $0 50 50 50 50 50 Red Red Red 23 24 25 9 Rest Hed 50 16