Microsoft 77-728 Excel 2016 Expert: Interpreting Data for Insights Exam Practice Test

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.

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.

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.

Task4:

Exhibit:

Remove the name “Sales” that refers to the range “Merchandise-Sales’ISAS1 SHS17”