$1.$ Camille Darbonne is the director of the Office of Capital Projects for the Hempstead University Foundation. She uses an Excel workbook to track building projects on three Hempstead University campuses in the state of New York. She asks for your help in summarizing project data as she prepares for a presentation to the Foundation's board. To do so$,$ you will use functions and advanced PivotTable features.

Go to the Capital Projects worksheet, which contains a table named Projects listing details about the university's building projects. Start by clearing the filter from the table.

$2.$ Instead of seeing the data sorted by budget amount, Camille would like to see the data by year. Sort the table by year from oldest to newest.