77-728 Excel 2016 Expert: Interpreting Data for Insights Questions and Answers

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 5:

Exhibit:

In cell H7 on the “Event 1 -Stand Sales” worksheet, add a formula that uses a single logical function to display TRUE if everyone sold at least on hot dog and FALSE if even one person did not sell any hot dogs.

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 have spent the past year starting up an amusement park. You have decided to create a year end financial report for your stakeholders.

Task 4:

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.

Task 5:

Show the Developer tab on the ribbon.