Pass the Microsoft Office Specialist 77-728 Questions and answers with ExamsMirror

Exhibit:

You have spent the past year starting up an amusement park. You have decided to create a year end financial report for your stakeholders.

Task4:

On the “Chart” sheet save the PivotChart as a template named “ParkChart” in the charts folder.

Exhibit:

You have spent the past year starting up an amusement park. You have decided to create a year end financial report for your stakeholders.

Task3:

On the “Chart” sheet add a slicer for the “Expense/Income” Column

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.

Task3:

Exhibit:

In Cell B19 on the “Merchandise-Sales” worksheet, calculate the total number of T-shirts that were sold for less than $18 at all concerts at which more than 1500 t-shirts were sold.

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.

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.

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:

Task3:

On the “Available Must” worksheet, use a query to load the cells beginning at A1 from the HarvestLog.xlsx workbook in the documents folder. Include only the “Variety”,”Location” and “Litters of must” Columns.