For this assignment, you will create lookup tables using the functions listed.

1. Create a worksheet that takes an income and displays that income with the tax lasted, based upon the following table. Find the maximum tax rate using VLOOKUP. For example, if you enter 31245 in the input cell for income, your spreadsheet should display 15% as the output.

   Income	Maximum Tax Rate
   $0-$2,500	5%
   $2,501-$5,000	8%
   $5,001-$10,000	10%
   $10,001-$25,000	12%
   $25,001-$50,000	15%
   $50,001-$100,000	18%
   $100,001-$250,000	25%
   $250,001+	40%

2. Create a worksheet that allows you to enter a size and minimum quantity of dog beds, and displays the total price. Find the price using INDEX and MATCH. Note that it is a minimum quantity. Meaning, if 45 is entered, it should return the price for 48.

   Size	12	24	48	96
   XS	$7.99	$14.78	$27.34	$50.57
   S	$9.99	$18.48	$34.18	$63.23
   M	$12.99	$24.03	$44.45	$82.23
   L	$16.99	$31.43	$58.14	$107.55
   XL	$21.99	$40.68	$75.25	$139.21