77-728 Questions and Answers
Question # 1
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
Question # 2
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.
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â€
