i need help on number 4 of excel

On the Shopping shot, check all the formulas Cells to check are filed with the light purple color. Most of the need to be contected. Many of the problems on this worksheet can be solved by creating named ranges or using a name that way exists a. The formula in cell 82 uses the wrong function . The formula in cells A9 A23 reference a named range that doesn't exist. There is more than one correct way to fix this problom using the cell rango AS:H18 on the plans to Shop worksheet. You can create the same tinge referenced in the formulas, or you can change the function arguments to reference the col range instead c The formula in coll H9 results in the correct value. However, the workbook author copied this formula to the remaining cells in the column and those values are definitely not correct Fix the formula in cell H9 and copy it to colis H10:H23. Hunt Notice that cel HB is named Tax Det mes AS Foting VLOOKUP(89, Places to Shop FALSE) 8 D G Shopping List H number of different iten o NAMA Average item INAME ghost item Cou INAME lowest Item Cost Be total cost with tax 5 7 City NAME #NAMES 10 11 1 1 14 15 NAME NAME NAME! NAME #NAMER Source Item Description buon Units Coutperuri Coil Ta Total Code 5% Aber Supermarke Apporters 10 pounds $10.00 $100 $5.00 505.00 Sharon Boy Cake 1 Eoch $350.00 $350 1.730.00 $2,100.00 Dessert Forks Colee The Porly Store spoons 125 each $0.50 $63 The Party for Dessert Plates 125 och $1.00 3125 The Party More Dinner Plates 125 each $1.25 SI56 The Party Store Dinner Silverwore 125 sets $1.00 $125 Flower Power Flor Flower Arangements 25 eoch 340.00 $1.000 Glass Coffee Cups Party Rentals and Saucon 75 each 52.00 $150 The Party Store Glasses 125 each $1.50 $188 Engraven Invitations 75 och $0389 $61 The Entertainen Music leach $1.500.00 $1.500 The Porty Store Napkins 125 each 560 $0.50 Solad Plates $0.75 125 each The Party Store $94 16 17 18 19 20 20 ENAME ENAME? NAMEE ENAME FNAMET MAMCE #NAME NAME? 3108 Costco -Folsom Soft Drinks and Water The Party Store Table Cloths 59.00 $4.00 12 caso 25 each 51000 24 25 26 27