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

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

Modify Excel options to Prevent formulas from being automatically evaluated when data changes. Formulas should not be evaluated when a workbook is saved.

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.

Task3:

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