Row $18$:

Cell A$18$: Use CONCAT to enter the text FIFO Inventory Balance: $($with colon$).($PG$-4$C$)$

Cell B$18$: Enter a formula that calculates the ending inventory balance under FIFO. $($PG$-4$d$)$

Row $19$:

Cell A$19$: Use CONCAT to enter the text WA Inventory Balance : $($with colon$).($PG$-4$e$)$

Cell B$19$: Enter a formula that calculates the ending inventory balance under the weighted average method. $($PG$-4$f$)$

Switch to the Inventory Listing tab and, in the appropriate location, enter a formula to display the fifth$-$year LIFO inventory balance for construction paper. $($PG$-5)$

Range K$5$:K$62($conditional formatting$)$: $($PG$-6)$

$3$ Symbols $($Uncircled$)$ icon set

Red $-$ White $-$ Green color scale

Visualize the Data

Hint: You should still be on the Inventory Listing tab.

Create a PivotTable based on all inventory balances displayed for all five years:

New worksheet tab name: Inventory PivotTable $($PG$-7$a$)$

Display the Year $5$ Inventory Balances: $($PG$-7$b$)$

Rows area: Country of Manufacture

Columns area: Product Category

Add a filter: Exclude all but the Active product department. $($PG$-7$c$)$

Add a slicer: Show only data for product categories with at least a $3$ of $5$ online rating $($PG$-7$d$)$

Create a $3-$D Clustered Column PivotChart that displays the Online Rating category in the legend $($below any already existing categories in the legend field$).$ Position the PivotChart with the slicer in a logical manner. $($PG$-8)$

Save and close the file.

Using Project Grader: Save the file as EA$4-$ A$1-$ Inventory$-$eSubmi ssion and attach it to the assignment you submit for grading.

Not using Project Grader: Submit the file per your instructor's guidelines.