Complete KITCHEN SUPPLIES Excel sheet spreadsheet using formulas. You must submit the Excel

file to be graded.

Column F

Determine which items need to be reordered, and the quantity for each. If there is enough in

stock, the reorder quantity should be $0.$

Cells J$4$ through L$6$

Write the appropriate formulas to determine the costs for each Item Family. Write separate

formulas to determine the maximum, the minimum, and the average costs.

Cells I$13$ and J$13$

Write a formula that will review the prices of any item description that is a Toaster over and

display the minimum and the maximum in the appropriate cells. Note, this range may be hard

coded.

Cells I$16$ and J$16$

Write formulas that will review all item prices and display the two highest priced items in their

appropriate cells.

Cells I$19$ and J$19$

Write formulas that will review all item prices and display the lowest price item and the third

lowest price item in their appropriate cells.