Microsoft Excel 2016 Expert: Interpreting Data for Insights - 77-728 Exam Practice Test
Exhibit:
You are an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.
Task3:
On the "Profits PivtChart" sheet change the settings for the PivotTable to refresh the data of the PivotTable whenever the file is opened.
You are an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.
Task3:
On the "Profits PivtChart" sheet change the settings for the PivotTable to refresh the data of the PivotTable whenever the file is opened.
Correct Answer:
See the explanation below.
Explanation
Right click on Pivottable and select Pivottable options
On the data tab click on "Refresh data when opening the file"
Explanation
Right click on Pivottable and select Pivottable options
On the data tab click on "Refresh data when opening the file"
Exhibit:
You are an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.
Task 1:
Modify Excel options to Prevent formulas from being automatically evaluated when data changes. Formulas should not be evaluated when a workbook is saved.
You are an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.
Task 1:
Modify Excel options to Prevent formulas from being automatically evaluated when data changes. Formulas should not be evaluated when a workbook is saved.
Correct Answer:
See the explanation below.
Explanation
Go to file - options - formulas and check manual in calculation options. Uncheck recalculate workbook before saving option.
Explanation
Go to file - options - formulas and check manual in calculation options. Uncheck recalculate workbook before saving option.
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.
Task5:
Exhibit:
On the"Cost Pivot Chart" worksheet add a 3D Stacked Bar Chart that shows the data in the PivotTable.
Task5:
Exhibit:
On the"Cost Pivot Chart" worksheet add a 3D Stacked Bar Chart that shows the data in the PivotTable.
Correct Answer:
See the explanation below.
Explanation
Select the PivotTable and from the Analyze tab select the chart as mentioned below
Explanation
Select the PivotTable and from the Analyze tab select the chart as mentioned below