Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . Camille Darbonne is the director of the Office of Capital Projects for the Hempstead University Foundation. She uses an Excel workbook to track
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.
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started