77-728 – Excel 2016 Expert: Interpreting Data for Insights

CORRECT TEXT

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.

CORRECT TEXT

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.

Task5:

Exhibit:

On the“Cost Pivot Chart” worksheet add a 3D Stacked Bar Chart that shows the data in the

PivotTable.

CORRECT TEXT

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.