77-728 무료 덤프문제 온라인 액세스

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.

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.

정답:

See the explanation below.
Explanation
Go to file - options - formulas and check manual in calculation options. Uncheck recalculate workbook before saving option.

Exhibit:

Task5:
On the "Quality Control" worksheet change the table name from "Table3" to WeeklyQuality".

정답:

See the explanation below.
Explanation
Click on the table and go to table properties as mentioned below and then enter the table name

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.

정답:

See the explanation below.
Explanation
Select the PivotTable and from the Analyze tab select the chart as mentioned below