This question was posted by someone else, but no steps provided are there any steps? HELP please.

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 database 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. In the range J2:M7, Camille wants to summarize project information. Start by calculating the number of each project type as follows: a. In cell K3, enter a formula using the COUNTIF function that counts the number of Expansion projects, checking that the column of project types in the Projects table (Projects[Project Type]) is equal to the value in cell J3. b. Fill the range K4:K7 with the formula in cell K3. 2. In column L, Camille wants to calculate the total cost of each project type. Determine the total costs as follows: a. In cell L3, enter a formula using the SUMIF function that totals the cost for Expansion projects, checking that the column of project types in the Projects table (Projects[Project Type]) is equal to the value in cell J3, and that the formula totals all the final costs (Projects[Final Cost]). b. Fill the range L4:L7 with the formula in cell L3.

- 2 Xan -11 - AA E EE A ESSE 25 Wrap Text Merge & Center - E2 D2E2 D2 AutoSu Conditional Format as cell Insert Delete Format Formatting table Clear Styles O $ . % 938 Calib In copy - Format Painter B Clipboard hoSave o 9. Styles DOBB E A 2 x 2G YX A 43. Calibri 12 fr - X C D MNOF Number Total Cost Average Cost 2016 Project Type Expansion Landscape New Construction Renovation Upgrade Final Cost >100000 Number of Projects: 2018 2 Project Type Campus Green Feature 3 Expansion La Croix Materials 4 Landscape Hempstead Materials 5 Renovation Hempstead Materials 6 Expansion Hempstead Stormwater 7 New construction Newburgh Green roof B Landscape Hempstead Stormwater 9 Rentation Newburgh Green roof 10 Rervation Newburgh Stormwater 1 Landscape Newburgh Stormwater 12 Expansion Newburgh Materials 13 New construction Hempstead Green rool 14 Renovation La Croix Stormwater 15 Landscape Hempstead Materials 16 Renovation Hempstead Solar panels 17 Renovation Hempstead Materials 18 Renovation Newburgh Stormwater 19 Renovation La Croix Solar panels 20 Renovation Hempstead 21 Expansion Hempstead Materials 22 New construction La Croix Solar panels 23 Renovation Hempstead Materials 24 Landscape La Cro Documentation Capital Projects Completed Budget Final Cost $213.475 $225,631 2016 $59,320 S60,600 2017 $82,500 $89,754 2017 $62,750 $60,935 2017 S689430 S700,225 2017 S42,500 $42.850 2018 $55,750 $56,127 2018 $195,640 $200,326 $48,700 $48,850 2018 $109,00 $110,456 2019 $847,400 $889,325 2019 $78,775 $79,349 2019 $78,300 $78,550 2019 $32,500 $12,500 2019 $195,600 $199.800 2019 $78,500 $82,500 2019 $52,500 $52,500 2019 $153,200 $155.000 2019 $210,750 $220,158 2020 $285,410 $285,329 2020 $225.000 $234,657 2020 $76,500 $79,225 Cost by Green Feature Cost by Campus Completed 2019 Number of Projects Campus Newburgh Totalca Campus Hempstead Average COSE Project Budgets Project Types by Yea... 10 ER Type here to search