Exhibit:

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.

Task3:

On the “Profits PivtChart” sheet change the settings for the PivotTable to refresh the data of the PivotTable whenever the file is opened

Exhibit:

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.

Task 4:

Exhibit:

Add cells C53 E56 on the “Workforce Statistics” worksheet to the Watch Window.

You have been a manager of a band for the past year. You are reviewing the data you have about the merchandise that was sold at all of the concerts.

Task 1:

Exhibit:

On the “Sales Pivot Chart” worksheet add the “Price each t-shirt” field as a filter to the PivotChart.