6. Summarize the data shown in Figure 2-42 using the Pivot Table option in Excel.

Use the Year and Project Type as row fields, the Region as a column field, and the Project Value as a data field.

Show and print the following data on the pivot table:

a. The sum of project value for the 1998-East Region-Office Building projects.

b. The sum of project value for the 1999-Residential projects.

c. The total value of all projects.

d. The average value of the 1998 Office Building projects.

e. The average value of all projects.

f. Modify the pivot table by using the Year as a page field. Display the project value for all years and for the year 1999 only.