11.11 Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

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

Page: 1 / 3
Total 26 questions

Excel 2016 Expert: Interpreting Data for Insights Questions and Answers

Question 1

Exhibit:

Question # 1

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:

Question # 1

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

Options:

Question 2

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.

Question # 2

Options:

Question 3

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:

Question # 3

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

Options:

Page: 1 / 3
Total 26 questions