Excel lab write up

Practice Exercise DIRECTIONS: 11. Download the inventory spreadsheet and save it on your desktop with your name in the file name. 12. Create a table for the data 13. Create a pivot table on a new spreadsheet. The report filter field should be IA. The Row Labels should contain the Items and the Column Labels should contain In Use. The values should contain the Serial Numbers. 14. Apply one of the fancy styles to the pivot table. Re-name the sheet tab to Hardware Pivot. 15. Create a Column Type Pivot Chart based on the pivot table. . Move it out of the way. Pick a chart style that enables you to clearly view all the elements and that enable you to type in a chart title. The chart title should be Inventory Locations. Re-name that sheet tab Hardware Pivot Chart. 16. Print the Excel file as a PDF. Name it Inventory, along with your first and last name. 17. Complete the last paragraph of the write-up