Microsoft Excel 2016 Expert: Interpreting Data for Insights - 77-728 FREE EXAM DUMPS QUESTIONS & ANSWERS
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.
Task2:
Create a PivotTable in Cell A2 of the "Vendor Costs" worksheet based on cells C3 K19 on the "Purchases" worksheet to show the average of the total cost for each vendor. Display each vendor on a row.
Task2:
Create a PivotTable in Cell A2 of the "Vendor Costs" worksheet based on cells C3 K19 on the "Purchases" worksheet to show the average of the total cost for each vendor. Display each vendor on a row.
Correct Answer:
See the explanation below.
* Select the rangeC3:K19 on the Purchases worksheet
* Go to Insert - Pivot table
* Put Vendor in Row area andtotal cost for each vendorin values
* Change the sum oftotal cost for each vendorto Averagetotal cost for each vendorby going to value field settings
* Select the rangeC3:K19 on the Purchases worksheet
* Go to Insert - Pivot table
* Put Vendor in Row area andtotal cost for each vendorin values
* Change the sum oftotal cost for each vendorto Averagetotal cost for each vendorby going to value field settings
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.
Task4:
Exhibit:
Remove the name "Sales" that refers to the range "Merchandise-Sales'ISAS1 SHS17".
Task4:
Exhibit:
Remove the name "Sales" that refers to the range "Merchandise-Sales'ISAS1 SHS17".
Correct Answer:
See the explanation below.
Explanation
Go to Formulas - name Manager - select the above mentioned name from the list and hit 'Delete'
Explanation
Go to Formulas - name Manager - select the above mentioned name from the list and hit 'Delete'
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.