In cell I33, create a formula to retrieve the item within the category listed in cell 31. Enter an INDIRECT function nested in an INDEX function to return the item numbers by category. The function will reference cell El and return the value at the intersection of row 1, using the Category number in cell A3 and column 1. Nest the function in an IFERRDR function to retum a blank cell it no items exist within the category. Copy the formula down through cell Bl'r'. This will allow you to change the value in cell Bl to Golf. Inventory. Food, Reading. or Clothing and retrieve the desired data from the appropriate table. In cell C3, create a formula to reuieve the projected sales for each item within the category listed in cell 31. Enter an INDIRECT function nested in an INDEX function to return the item numbers by category. The function will reference cell 31 and retum the value at the intersection of row 1. using the Category number in cell A3 and column 2. Nest the function in an IFERRCR function to return a blank cell if no items exist within the category. Copy the formula down through cell C11 In cell F24, enter a formula that calculates the quantity of each item by subtracting the total out amount from the beginning inventory amount and then adding the total in amount. Copy the formula down through cell F43