PrepAway - Latest Free Exam Questions & Answers

You need to extract tabular information grouped by year, month, team, and resource

In Microsoft Office Project Web Access, you want to analyze the work performed on your projects over the last 2 years. You need to extract tabular information grouped by year, month, team, and resource. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
For each project, export the project’s default Gantt view to a Microsoft Office Excel worksheet. Then combine the worksheets into a pivot table.

B.
For each project, export the projects unsubmitted timesheets to a Microsoft Office Excel worksheet. Then combine the worksheets into a pivot table with the required fields.

C.
On the Data Analysis page, create a pivot chart with the required fields, and then save the pivot chart as an image.

D.
On the Data Analysis page, create a pivot table with the required fields, and then export it to a Microsoft Office Excel worksheet.


Leave a Reply