Microsoft Excel 2016 Expert: Interpreting Data for Insights 77-728 Exam Dumps: Updated Questions & Answers (October 2025)

Exhibit:

Task6:

On the “Quality Control” worksheet add a linear trendline to the chart that forecast the quality of batch C1005 through week 12.

Exhibit:

Task5:

On the “Quality Control” worksheet change the table name from “Table3” to WeeklyQuality”.

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.

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 a news reporter. You have a been given the assignment to give a history of the Olympic Games.

Task3:

Create new customized colors with the Accent 1 option to RGB “255”, “153”, “51”. Name the customized colors “Orange Table”

Exhibit:

You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.

Task5:

In column F of the “Hosts” worksheet, create a formula that uses date and time functions to show how many years ago the games were hosted in eachcity.

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.

Task2:

Exhibit:

On the “Merchandise-Costs” worksheet, change the dates in column A to Spanish (Mexico) using the format 14 de marzo de 2012. Change the currency C, E, G and H to $ Spanish (Mexico)