PLEASE MAKE SURE YOU DO A EXCEL FORMAT SCREEN SHOT OR WRITE IT OR ANY OTHER FORMAT THAT SHOWS THE WORK!!!!!!!!!!

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] 2. Click in cell B2, type COUNTA ( and highlight the range A5:A70, and then type ) 3. In cell J5, type cOU and then double-click the Count function, highlight the range 4. Click cell K5 and choose Formulas>Function Library->Insert Function. To begin, you will work with the Inventory Listing tab and tap Enter ES:I5, and then type) and tap Enter 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 Click cell L5, choose Formulas Function Library-Insert Function, click the arrow for Or Select a Category, choose Statistical and then Max, and click OK. 6. 7. Highlight the range E5:I5 and cdlick OK. 8. Select cell M5 and choose Home-Editing-AutoSum -Nin, highlight the range E5:15, and tap Enter 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] 2. Click in cell B2, type COUNTA ( and highlight the range A5:A70, and then type ) 3. In cell J5, type cOU and then double-click the Count function, highlight the range 4. Click cell K5 and choose Formulas>Function Library->Insert Function. To begin, you will work with the Inventory Listing tab and tap Enter ES:I5, and then type) and tap Enter 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 Click cell L5, choose Formulas Function Library-Insert Function, click the arrow for Or Select a Category, choose Statistical and then Max, and click OK. 6. 7. Highlight the range E5:I5 and cdlick OK. 8. Select cell M5 and choose Home-Editing-AutoSum -Nin, highlight the range E5:15, and tap Enter