Create a Spreadsheet for Analysis

1. Please review the pivot exercise done in class and create a workbook named Lastname_firstname_pivottable.xls. It must contain at least 125 records with at least 5 columns.
2. Based on the worksheet you have just completed, create 1 pivot table and 1 pivot chart in Excel to answer 2 business questions (examples below).
   1. What type of customers or region generated the highest revenue?
   2. What's the average total quantity sold/purchase?
3. Explain your work. Include a short paragraph discussing your work.
4. Save the workbook file and upload it to blackboard. Pls remember, this must be your own work. No credit will be given if you reuse the example worksheets