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?
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.