Microsoft Excel 2016 Expert: Interpreting Data for Insights - 77-728무료 덤프문제 풀어보기
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.
정답:
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 have spent the past year starting up an amusement park. You have decided to create a year end financial report for your stakeholders.
Task4:
On the "Chart" sheet save the PivotChart as a template named "ParkChart" in the charts folder.
You have spent the past year starting up an amusement park. You have decided to create a year end financial report for your stakeholders.
Task4:
On the "Chart" sheet save the PivotChart as a template named "ParkChart" in the charts folder.
정답:
See the explanation below.
Explanation
Right click on the chart and select 'Save as template' then enter the name "ParkChart" and click ok
Explanation
Right click on the chart and select 'Save as template' then enter the name "ParkChart" and click ok
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.
정답:
Pending. Send the suggestions for this question.