You are an accountant for an event stadium.

You are an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.

Task2:

Create a PivotTable in Cell A2 of the “Vendor Costs” worksheet based on cells C3 K19 on the “Purchases” worksheet to show the average of the total cost for each vendor. Display each vendor on a row.