EA4-R1 Edit an Inventory Listing and Create a PivotTable for XL Sports Emporium In this exercise, you will compile summary data based on an inventory listing for XL Sports Emporium. Then you will determine the inventory balance for a product using three methods. Last, you will create a PivotTable and a PivotChart. 1. Open EA4-R1-Inventory from your Chapter 04 folder and save it as: EA4-R1-Inventory-[YourName] To begin, you will work with the Inventory Listing tab. 2. Click in cell B2, type =COUNTA( and highlight the range A5:A70, and then type ) and tap [Enter]. 3. In cell J5, type =COU and then double-click the Count function, highlight the range E5:I5, and then type ) and tap [Enter]. 4. Click cell K5 and choose FormulasFunction LibraryInsert Function. 5. Type Average in the search box and click Go, choose Average and click OK, highlight the range E5:I5, and then click OK. You may need to move the Function Arguments dialog box by dragging its title bar in order to highlight the specified range. 6. Click cell L5, choose FormulasFunction LibraryInsert Function, click the arrow for Or Select a Category, choose Statistical and then Max, and click OK.