$1.$ Fix the following errors in the$$Shopping List$$worksheet$.$ Use cell references and named ranges where appropriate. All the named ranges you might need have been defined for you. Refer to the$$Named Ranges Reference$$sheet for a description of each defined name.

a$.$ The formula in cell$$B$2$should calculate the total cost of all the shopping items by multiplying the number of items ordered in the$$Quantity$$column by the cost of each item in the$$TotalCostperUnit$$column and then summing the values. Be sure to round the final value to two decimal places. If necessary, apply the$$Accounting Number Format. b$.$ The formula in cell$$B$4$should allow you to look up the vendor for the item listed in cell$$B$3.$ Using a nested INDEX and MATCH formula is the right idea, but the formula is not quite right. Add an IFERROR function to display$$No such item$$if the formula results in an error. Also, use absolute references so you can copy the formula to cells$$B$5$and$$B$6.$ c$.$ In cell$$B$5,$ copy and paste the corrected nested INDEX and MATCH formula and then update the$$Column$\_$num$$argument to find the quantity ordered. d$.$ In cell$$B$6,$ copy and paste the corrected nested INDEX and MATCH formula and then update the$$Column$\_$num$$argument to find the item$$s total cost per unit. Edit the formula to calculate the total cost by multiplying the result of the INDEX formula by the quantity ordered $($cell$$B$5).($Hint: Maintain the IFERROR function as the outermost function in the nested formula.$)$ If necessary, apply the$$Accounting Number Format. e$.$ There are three items in the shopping list that are based on the number of guests, but the quantity ordered should be rounded up to the nearest whole number. Add the appropriate rounding function to the formulas in cells$$D$10,$D$11,$ and$$D$23.$ f$.$ The formula in cell$$E$4$should calculate how many months it will take to pay off the loan using the total cost in cell$$B$2$and the loan terms in cells$$E$2$and$$E$3.$ The formula is using the wrong function and the arguments are in the wrong order. Once you correct this formula, the final cost of the party $($cell E$5)$ will be correct as well.