Develop Your Skills EA4-D1 In this exercise, you will use functions to summarize data within an inventory listing. Start Excel. Open EA4-D1-Inventory from your Chapter 04 folder.On the Inventory Listing tab, type the following in cell B2: =COUNTA( Highlight the range A5:A83, type ) (a closed parenthesis), and tap Enter.The total number of inventory categories is now prominently displayed at the top of the worksheet.Type =COU in cell J5, double-click the Count function in the list, highlight the range E5:I5, type ) (a closed parenthesis), and tap Enter.Because there is no entry within cell I5 at this point, the result of this formula is 4. Select cell K5 and choose FormulasFunction LibraryInsert Function.Type Average in the Search for a Function field, click Go, click Average from the Select a Function box, and click OK.Highlight the range E5:I5 and click OK in the Function Arguments dialog box.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 and choose FormulasFunction LibraryInsert Function.Choose Statistical from the Or Select a Category drop-down menu, scroll through the list in the Select a Function box and click Max, and click OK.Highlight the range E5:I5 and click OK in the Function Arguments dialog box.Click cell M5 and HomeEditingAutoSum Min, highlight the range E5:I5, and tap Enter.Highlight the range J5:M5, click the fill handle, and drag down to row 83.The fill handle is the small square at the bottom right of the selected range. Notice that the appearance of the cursor changes to a small + when it hovers over the fill handle.Beginning with cell E84, highlight the range E84:I84 and choose HomeEditingAutoSum.Save your file.Unless otherwise directed, always keep your file open at the end of each exercise.