Microsoft Excel 2016 Expert: Interpreting Data for Insights (77-728) Free Practice Test
Question 1
Exhibit:
Task4:
On the "Batches in Progress" worksheet, use an Excel forecast feature to calculate the "Desired Specific Gravity" for batch 1005 to result in a "Final Percent Alcohol" level of 15%.
Task4:
On the "Batches in Progress" worksheet, use an Excel forecast feature to calculate the "Desired Specific Gravity" for batch 1005 to result in a "Final Percent Alcohol" level of 15%.
Correct Answer:
Pending. Send the Suggestion for this question.
Question 2
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.
Correct Answer:
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
Question 3
Exhibit:
You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task2:
Prevent users from adding, deleting or modifying worksheets unless they enter the password "12345".
You are a news reporter. You have a been given the assignment to give a history of the Olympic Games.
Task2:
Prevent users from adding, deleting or modifying worksheets unless they enter the password "12345".
Correct Answer:
See the explanation below.
Explanation
Go to Review - Protect workbook -and enter the password 12345 and click 'Ok'
Explanation
Go to Review - Protect workbook -and enter the password 12345 and click 'Ok'