Please answers question #3,4 and 5

Home Insert Draw Page Layout Formulas Date Review Viow Automate Tellilo Finding Lowest Quote for Restocking Switch to "Grocery" worksheet, label the column E "Average" and column F "Minimum". In columns E and F, use VLOOKUP to find the average and minimum quotes for each ltem from the "Suppliers" worksheet. Note: the list in the "Suppliers" is much longer so copy \& paste won't work. You will need to REALLY understand how VLOOKUP function works and the -1 - meaning of each argument. 4. Go back to Grocery worksheet and type "Category" in cell D1, In cell D2, type "=VLOOKUP (B2,Categories)A:B,2,FALSE)". Press Enter. You should see "Fruits" as the category if the first product in your worksheet is "Apples". Then, use auto-fill or dragfill to populate the rest of the list for column D. 5. Inventory Management Based on Previous Demand. Every week Britney needs to decide how many units she needs to replenish for each item. She would like toestimate the weekly replenishment order size using both the sales and quotes data fromWeek 52 of last year (more precisely, the number of units sold across all items during that week). Please calculate the estimate for her and put the results in column G. Label it "Units." Since we do not have weekly sales data, we will assume the following for simplicity: (1) There were exactly 52 weeks in the last year; (2) Weekly demand for each item is constant all year long (i.e., demand in week 1= demand in week 2= demand in week 52) (Think: given annual sales, how do you calculate weekly sales): (3) Brithey always orders from the supplier with the lowest quote; and (4) Britney always sets a fixed 5% markip for each item. Let's quickly organize what information we have on hand. For each item, we know: (1) the annual sales from the last year, (2) the unit cost (lowest quote), and (3) the 5% markup for the selling price