edit an inventory listing and create PivotTable for Educational Endeavors

Endeavors. Then you will determine the inventory balance for a product category using dine methods. Last, you will create a PivatTable and a PivotChart. 1. Open EA4A1Inventory from your Chapter 04 folder and save it as: an A1Inventory- {Youramel 2. Use a function to display the total number of product categories in cell B2. 3. Populate the cells as described for the Construction Paper product category: In this cell; Use a function to display the: 1' \"MI 15 Number of years for which an inventory balance is displayed Cell K5 Average inventory balance for the ve years shown I EB\" L5 Maximum inventory balance for the five years shown coll-M5 Minimum inventory balance for the ve years shown Hint: Make sure the formula in cell J5 will update properly ifany currently lrl'orrl.r cells are later llarl in '3] La: Aa all a, _ _.__.:_ ...+J-._=