77-728 무료 덤프문제 온라인 액세스

시험코드:77-728
시험이름:Excel 2016 Expert: Interpreting Data for Insights
인증사:Microsoft
무료 덤프 문항수:26
업로드 날짜:2025-09-04
평점
100%

문제 1

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.

문제 2

Exhibit:

Task5:
On the "Quality Control" worksheet change the table name from "Table3" to WeeklyQuality".

문제 3

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.
Task 1:
Using the Fill Series option in Excel fill in the months April through October in cells C1 I1 Do not change the cell formatting.

문제 4

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.

댓글 추가

귀하의 메일주소는 공개되지 않습니다. 필수 입력 사항은 표시되어 있습니다. *

insert code
그림의 인증번호를 입력하세요.