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.
Task3:
Create new customized colors with the Accent 1 option to RGB "255", "153", "51".
Name the customized colors "Orange Table".
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".
Correct Answer:
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
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.
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.
Correct Answer:
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
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.
Task 5:
Show the Developer tab on the ribbon.
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 5:
Show the Developer tab on the ribbon.
Correct Answer:
See the explanation below.
Explanation
Go to file - options - customize ribbon and check the "Developer" tab
Explanation
Go to file - options - customize ribbon and check the "Developer" tab