Microsoft Excel 2016 Expert: Interpreting Data for Insights - 77-728 Exam Practice Test
Exhibit:
You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task4:
In cell F2 of the "No Medals" worksheet, create a formula that will show if a team participated in both seasons or only the Summer games.
Display "Both" if the team participated in both seasons that year Display
"Summer Only" if the team participated only in the Summer games.
You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task4:
In cell F2 of the "No Medals" worksheet, create a formula that will show if a team participated in both seasons or only the Summer games.
Display "Both" if the team participated in both seasons that year Display
"Summer Only" if the team participated only in the Summer games.
Correct Answer:
Pending. Send the suggestions for this question.
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.
Task 1:
Exhibit:
On the "Sales Pivot Chart" worksheet add the "Price each t-shirt" field as a filter to the PivotChart.
Task 1:
Exhibit:
On the "Sales Pivot Chart" worksheet add the "Price each t-shirt" field as a filter to the PivotChart.
Correct Answer:
See the explanation below.
Explanation
Select the chart and then add"Price each t-shirts" field in report filters area
Explanation
Select the chart and then add"Price each t-shirts" field in report filters area
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.
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.
Correct Answer:
See the explanation below.
Explanation
On the formulas tab, click on Watch window. Click on add watch and add the rangeC53:E56
Explanation
On the formulas tab, click on Watch window. Click on add watch and add the rangeC53:E56