Use the following Excel features in exercise 6: VLOOKUP, INDEX and MATCH.

1. Use MATCH to determine what row Rake resides.

2. Use INDEX to display the name Rake for the row you have determined in part 1. Hint, you need the output from part 1 to accomplish part 2.

3. Use a combination of INDEX and MATCH to display the product ID number of light bulbs in cell B6.

4. Using VLOOKUP, add a box under the VLOOKUP heading that displays the quantity in stock when you type in the product name into cell B5. Hint, you need the output for part 3 to accomplish part 4.

5. Use a combination of INDEX and MATCH to display the name of the product that has a retail price of $199.

5 Product Name 6 Product ID On Order Reorder LeRetail Price 39 17 9 ID Product Name Unit CostIn Stock 25 30 10 $18.00 $19.00 $10.00 $97.00 $31.00 $125.00 $45.00 $148.00 $15.50 $17.45 $39.00 $15.00 $16.50 $21.00 $9.00 $4.95 1 Paint Brush 40 70 25 25 4 Gallon of paint 12 13 14 15 16 17 18 19 20 21 5 Grass Seed 150 45 199 89 299 29 24 59 29 25 39 29 31 5 24 9 10' ladder 10 Vacuum 11 Chain saw 15 Tool Set 19 Lawn mower 20 Step stool 21 Rakee 25 Lawn chair 27 Plant stand 28 Axe 29 Shovel 23 Garden hose 14 light bulbs 5 39 29 10 20 31 3 20 23 24 25 26 27 25 25 50 80