77-728 試験問題を無料オンラインアクセス

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".

正解：

See the explanation below.
Explanation
* Go to Page layout - colors - customize colors

* In Accent 1 go to more colors and enter the required RGB valuesand give it the nameorange Table

Exhibit:

Task3:
On the "Available Must" worksheet, use a query to load the cells beginning at A1 from the HarvestLog.xlsx workbook in the documents folder. Include only the "Variety","Location" and "Litters of must" Columns.

正解：

See the explanation below.
Explanation
Put the curser on cell A1 of the "Available Must" worksheet and then go to Data tab- New Query - from File - from Workbook Select the desired file and edit it in Query Editor. Remove the columns and only include onlyVariety, Location and Litters of must columns

Put the curser on cell A1 of the "Available Must" worksheet and then go to Data tab- New Query - from File - from Workbook Select the desired file and edit it in Query Editor. Remove the columns and only include onlyVariety, Location and Litters of must columns

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.

正解：

See the explanation below.
Explanation
Right click on the chart and select 'Save as template' then enter the name "ParkChart" and click ok

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.
Task2:
Remove all of the conditional formatting from the "Year 1" sheet.

正解：

See the explanation below.
Explanation
On the "Year 1" sheet, go to home - conditional formatting - clear rules - clear rules from entire sheet