I need a, b, c, and d on this question all for #1

1 2 Bins 3 $0-$99.99 4 $100-$249.99 5 $250-$499.99 6 $500-$999.99 7 $1000- B C Zip Shipping Cutoffs Output % $ 10.00% $100.00 5.00% $250.00 4.00% $500.00 2.50% $1,000.00 0.00% 8 9 Input Order Total 10 Shipping Percentage: 11 Shipping costs: $874.00 2.50% $21.85 12 In the table above, we have 5 possibilities for the %. We represent the possibilities in a table in cells, B3:07. This table consists of two columns, #1 and #2. Basically we will LOOKUP the value for the order total B9, in the table, and then output the appropriate % from column #2. The following VLOOKUP function is entered in cell B10 which gives an output of 2.50%: =VLOOKUP(B9, B3:07,2) 1. What are the outputs for the following? (Hint: one strategy is to create the table in an Excel spreadsheet and then enter the following VLOOKUP commands.) a. =VLOOKUP( 165, B3:C7, 2) b. =VLOOKUP( 650, B3:07, 1) c. =VLOOKUP( 650, B3:C7, 2) d. =VLOOKUP( 6500, B3:C6, 2)