Bus
- Pivot Table Exercise
- http://ulearnoffice.com/excel2013/exercises/pivottable.htm - instructions for exercise
- datalist.xlsx - file used in the exercise - included
- Add your name and the following to the end of the list: soc_sec_num - 123456789, name and gender - yours, title - Assistant, Salary - $37,500, category - 4
- Complete the exercise - some of the numbers will not be the same. If you get stuck, access other sources - ie. YouTube
- Save the file after working with the chart - yourlastname_firstname
- Send as an attachment to jotto@calstatela.edu
- Questions to answer when completed:
- How many InOffice employees?, What is the total benefits of InField employees?, Looking at the chart - who makes the highest wages?, Of the InOffice employees category, who makes the lowest wages? How much?, Of the InField employees category, who makes the highest wages? How much?
10 years ago 5
Answer(0)
Bids(1)