Use the Excel file to answer the following questions. You will need to create various pivot tables to get the necessary subtotals to answer the questions. How does each salesperson's performance vary by quarter? I noticed that the quarter and year automatic options do not always appear when creating a pivot table. If they do, then you are set. If not, create extra columns such as =year() & month() first and then create a pivot table that subtotals by year and filters 3 months at a time to arrive at a subtotal by quarter. You can also sort the records and create three different subsets by year and use the automatic quarter subtotal in the pivot table. Use your creativity and get the subtotals. Finally, if you were the manager wishing to motivate your sales force, how would you distribute bonuses for the salespeople?