Appiy rour skiIIS

If your classroom is using eLab with Project Grader $("$PG$"),$ download and use the eStart file on the Assignments page and submit as directed. If you don't use the eStart file, your work cannot be automatically graded.

If you are not using Project Grader, open the indicated file from your chapter folder.

EA$4-$A$1$ Edit an Inventory Listing and Create A PivotTable for Educational Endeavors PG

In this exercise, you will compile summary data based on an inventory listing for Educational Endeavors. Then you will determine the inventory balance for a product category using three methods. Last, you will create a PivotTable and a PivotChart.

Access the proper file.

Using Project Grader: Download EA$4-$A$1-$Inventory$-$eStart.

Not using Project Grader: Open EA$4-$A$1-$Inventory.

Prepare the Summary Data

Use the Inventory Listing tab for this section.

Cell B$2$: Use the COUNTA function to display the total number of product categories. Do not select individual cells in your formula; instead, include one range that encompasses all necessary entries. $($PG$-1)$

Populate the range J$5$:M$5($Construction Paper category$)$ using the indicated function:

Cell J$5$: Number of years for which an inventory balance is displayed $($COUNT function covering all years$)($PG$-2$a$)$

Cell K$5$: Average inventory balance for the five years shown $($AVERAGE$)($PG$-2$b$)$

Cell L$5$: Maximum inventory balance for the five years shown $($MAX$)($PG$-2$c$)$

Cell M$5$: Minimum inventory balance for the five years shown $($MIN$)($PG$-2$d$)$

Copy and paste those formulas such that the calculations are performed on all product categories. $($PG$-2$e$)$

Populate the totals in the range E$63$:I$63$ by entering formulas using AUTOSUM. $($PG$-3)$

Determine Inventory Balances

Remember, throughout these projects, to follow the approaches discussed and formulas used in the chapter. You won't always be reminded of this, but it is always the requirement.

Use the Construction Paper tab for the first part of this section.

Row $17$:

Cell A$17$: Use CONCAT to enter the text LIFO Inventory Balance: $($with colon$).($PG$-4$a$)$

Cell B$17$: Enter a formula that calculates the ending inventory balance under LIFO. $($PG$-4$b$)$