Edit an Inventory Listing and Create a PivotTable for Educational Endeavors
In this drill, you conciliate constitute digest axioms grounded on an register listing for Educational Endeavors. Then you conciliate determine the register et for a result nature using three courses. Last, you conciliate produce a PivotTable and a PivotChart. 1. Open EA4-A1-Inventory from your Chapter 04 folder and preserve it as: EA4-A1-Inventory-[YourName]
2. Use a administration to evince the whole enumerate of result categories in cell B2. 3. Populate the cells as vivid for the Reading Tract result nature: In this cell:
Use a administration to evince the:
Cell J5 Cell K5 Cell L5 Cell M5
Number of years for which an register et is evinceed Middle register et for the five years shown Maximum register et for the five years shown Minimum register et for the five years shown
Hint: Make stable the formula in cell J5 conciliate update properly if any currently broad cells are succeeding industrious in.
4. Copy the formulas in the rove J5:M5 and paste them such that the calculations conciliate be manufactured for all result categories.
5. Invade formulas in the rove E63:I63 to add the register ets for each year.
Use Register Costing Methods 6. Switch to the Reading Tract tab. 7. Use the CONCATENATE administration to invade LIFO Register Et in cell A17. 8. Invade a formula in cell B17 to proportion the consequence register et for reading tract subordinate the LIFO course.
9. In cell A18, use the CONCATENATE administration to invade FIFO Register Balance.
10. Invade a formula in cell B18 to proportion the consequence register et for reading tract subordinate the FIFO course.
11. In cell A19, use the CONCATENATE administration to invade WA Register Balance. 12. Invade a formula in cell B19 to proportion the consequence register et for reading tract subordinate the weighted middle course.
13. Invade a formula in the expend dregs on the Register Listing tab to evince the fifth-year LIFO register et for reading tract.
14. Apply the 3 Symbols (Uncircled) icon set and Red – White – Green distortion layer to the rove K5:K62.
15. Produce a PivotTable on the Register Listing tab grounded on the register ets evinceed for all five years.
16. Rename the new worksheet tab containing the PivotTable. 17. Evince the Year 5 Register Balances amid the PivotTable with: • Country of Manufacture in the Rows area • Result Nature in the Columns area • A depurate that excludes all but the Active result department
18. Add a slicer that limits the axioms to result categories that earned at lowest a 3 of 5 online rating.
19. Produce a 3-D Clustered Column PivotChart and evince the Online Rating nature in the myth.
20. Position the PivotChart and slicer in a close carriage.