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 Yes No 23 Recover Unsaved Workbooks We were able to save changes to one or more files Do you want to recover them x fx M N O P Q R S T 1964 Hempstead University Foundation N umber Total Cost Average Cost Project Type Expansion Landscape New Construction Renovation Upgrade Final Cost 100000 Number of Projects Completed 2019 Number of Projects 2 ID Project Name 3 EX 4096 Didrikson Gymnasium 4 LA 5066 Wales Lake 5 RE 1751 Ardmore House 6 EX 4188 Transit Center 7 NE 3027 Bixbury Apartments 8 LA 5104 Hempsted Field 9 RE 1854 Sullivan Library 10 RE 1890 Richardson Hall 11 LA 5218 Freestone Plaza 12 EX 4209 Boyle Residences 13 NE 3153 Ambani International Center 14 RE 1904 Clarkson Laboratory 15 LA 5276 Alumni Center 16 RE 1922 Founders House 17 RE 1957 Nakamura Physics 18 RE 1961 Grounds and Building 19 RE 1977 Thorne Family Pavilion 20 RE 1982 121 Forest Street 21 EX 4242 Kao Performance Center 22 NE 3209 Whitman Child Care 23 RE 1953 Riverfront Graduate Housing 24 LA 5303 Student Commons 25 NE 3301 Politzer Center 26 NE 3387 Sills Cultural Center 27 UP 2004 Campus Electrical 28 LA 5355 Arts Quad 29 UP 2033 Computing Research 30 NE 3412 Benton Hall of Business 31 EX 4103 Santiago Field 32 LA 5113 Heinrich Mall 33 NE 3045 Charles Street Entrance 34 UP 2011 Mansfield Observatory 35 LA 5197 visitor's Center Project Type Expansion Landscape Renovation Expansion New construction Landscape Renovation Renovation Landscape Expansion New construction Renovation Landscape Renovation Renovation Renovation Renovation Renovation Expansion New construction Renovation Landscape New construction New construction Upgrade Landscape Upgrade New construction Expansion Landscape New construction Upgrade Landscape Campus La Croix Hempstead Hempstead Hempstead Newburgh Hempstead Newburgh Newburgh Newburgh Newburgh Hempstead La Croix Hempstead Hempstead Hempstead Newburgh La Croix Hempstead Hempstead La Croix Hempstead La Croix Hempstead Newburgh Hempstead Hempstead Hempstead Hempstead Newburgh Hempstead Hempstead Hempstead La Croix Green Feature Materials Materials Materials Stormwater Green roof Stormwater Green roof Stormwater Stormwater Materials Green roof Stormwater Materials Solar panels Materials Stormwater Solar panels Materials Materials Solar panels Materials Materials Materials Materials Solar panels laranels Materials Green roof Materials Solar panels Materials Materials Solar panels Stormwater Completed 2016 2016 2017 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2019 2019 2019 2019 2019 2019 2020 2020 2020 2020 2020 2021 2021 2021 2021 2016 2017 2017 2018 2018 Budget $213,475 $59,320 $82,500 $62,750 $689,430 $42,500 $55,750 $195,640 $48,700 $109,800 $847,400 $78,775 $78,300 $32,500 $195,600 $78,500 $52,500 $153,200 $210,750 $285,430 $225,000 $76,500 $750,325 $575,200 $124,865 $83,450 $179,400 $989,500 $124,500 $76,500 $83,750 $34,600 $37,450 Final Cost $225,631 $60,600 $89,754 $60,935 $700,225 $42,850 $56,127 $200,326 $48,850 $110,456 $889,325 $79,349 $78,550 $32,500 $199,800 $82,500 $52,500 $155,600 $220,158 $285,329 $234,657 $79,225 $752,855 $590,568 $154,382 $84,072 $180,055 $990,455 $126,507 $78,024 $83,750 $34,600 $38,090 Campus Newburgh Total Cost Campus Hempstead Average Cost 38 39 Documentation Capital Projects Cost by Green Feature Cost by Campus Project Budgets Project Types by Year Ready 100 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 Yes No 23 Recover Unsaved Workbooks We were able to save changes to one or more files Do you want to recover them x fx M N O P Q R S T 1964 Hempstead University Foundation N umber Total Cost Average Cost Project Type Expansion Landscape New Construction Renovation Upgrade Final Cost 100000 Number of Projects Completed 2019 Number of Projects 2 ID Project Name 3 EX 4096 Didrikson Gymnasium 4 LA 5066 Wales Lake 5 RE 1751 Ardmore House 6 EX 4188 Transit Center 7 NE 3027 Bixbury Apartments 8 LA 5104 Hempsted Field 9 RE 1854 Sullivan Library 10 RE 1890 Richardson Hall 11 LA 5218 Freestone Plaza 12 EX 4209 Boyle Residences 13 NE 3153 Ambani International Center 14 RE 1904 Clarkson Laboratory 15 LA 5276 Alumni Center 16 RE 1922 Founders House 17 RE 1957 Nakamura Physics 18 RE 1961 Grounds and Building 19 RE 1977 Thorne Family Pavilion 20 RE 1982 121 Forest Street 21 EX 4242 Kao Performance Center 22 NE 3209 Whitman Child Care 23 RE 1953 Riverfront Graduate Housing 24 LA 5303 Student Commons 25 NE 3301 Politzer Center 26 NE 3387 Sills Cultural Center 27 UP 2004 Campus Electrical 28 LA 5355 Arts Quad 29 UP 2033 Computing Research 30 NE 3412 Benton Hall of Business 31 EX 4103 Santiago Field 32 LA 5113 Heinrich Mall 33 NE 3045 Charles Street Entrance 34 UP 2011 Mansfield Observatory 35 LA 5197 visitor's Center Project Type Expansion Landscape Renovation Expansion New construction Landscape Renovation Renovation Landscape Expansion New construction Renovation Landscape Renovation Renovation Renovation Renovation Renovation Expansion New construction Renovation Landscape New construction New construction Upgrade Landscape Upgrade New construction Expansion Landscape New construction Upgrade Landscape Campus La Croix Hempstead Hempstead Hempstead Newburgh Hempstead Newburgh Newburgh Newburgh Newburgh Hempstead La Croix Hempstead Hempstead Hempstead Newburgh La Croix Hempstead Hempstead La Croix Hempstead La Croix Hempstead Newburgh Hempstead Hempstead Hempstead Hempstead Newburgh Hempstead Hempstead Hempstead La Croix Green Feature Materials Materials Materials Stormwater Green roof Stormwater Green roof Stormwater Stormwater Materials Green roof Stormwater Materials Solar panels Materials Stormwater Solar panels Materials Materials Solar panels Materials Materials Materials Materials Solar panels laranels Materials Green roof Materials Solar panels Materials Materials Solar panels Stormwater Completed 2016 2016 2017 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2019 2019 2019 2019 2019 2019 2020 2020 2020 2020 2020 2021 2021 2021 2021 2016 2017 2017 2018 2018 Budget $213,475 $59,320 $82,500 $62,750 $689,430 $42,500 $55,750 $195,640 $48,700 $109,800 $847,400 $78,775 $78,300 $32,500 $195,600 $78,500 $52,500 $153,200 $210,750 $285,430 $225,000 $76,500 $750,325 $575,200 $124,865 $83,450 $179,400 $989,500 $124,500 $76,500 $83,750 $34,600 $37,450 Final Cost $225,631 $60,600 $89,754 $60,935 $700,225 $42,850 $56,127 $200,326 $48,850 $110,456 $889,325 $79,349 $78,550 $32,500 $199,800 $82,500 $52,500 $155,600 $220,158 $285,329 $234,657 $79,225 $752,855 $590,568 $154,382 $84,072 $180,055 $990,455 $126,507 $78,024 $83,750 $34,600 $38,090 Campus Newburgh Total Cost Campus Hempstead Average Cost 38 39 Documentation Capital Projects Cost by Green Feature Cost by Campus Project Budgets Project Types by Year Ready 100

Question

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  Yes No   23 Recover Unsaved Workbooks  We were able to save changes to one or more files  Do you want to recover them  x fx M N O P Q R S T 1964   Hempstead University Foundation N umber Total Cost Average Cost Project Type Expansion Landscape New Construction Renovation Upgrade Final Cost  100000 Number of Projects  Completed 2019 Number of Projects  2 ID Project Name 3 EX 4096 Didrikson Gymnasium 4 LA 5066 Wales Lake 5 RE 1751 Ardmore House 6 EX 4188 Transit Center 7 NE 3027 Bixbury Apartments 8 LA 5104 Hempsted Field 9 RE 1854 Sullivan Library 10 RE 1890 Richardson Hall 11 LA 5218 Freestone Plaza 12 EX 4209 Boyle Residences 13 NE 3153 Ambani International Center 14 RE 1904 Clarkson Laboratory 15 LA 5276 Alumni Center 16 RE 1922 Founders House 17 RE 1957 Nakamura Physics 18 RE 1961 Grounds and Building 19 RE 1977 Thorne Family Pavilion 20 RE 1982 121 Forest Street 21 EX 4242 Kao Performance Center 22 NE 3209 Whitman Child Care 23 RE 1953 Riverfront Graduate Housing 24 LA 5303 Student Commons 25 NE 3301 Politzer Center 26 NE 3387 Sills Cultural Center 27 UP 2004 Campus Electrical 28 LA 5355 Arts Quad 29 UP 2033 Computing Research 30 NE 3412 Benton Hall of Business 31 EX 4103 Santiago Field 32 LA 5113 Heinrich Mall 33 NE 3045 Charles Street Entrance 34 UP 2011 Mansfield Observatory 35 LA 5197 visitor's Center Project Type Expansion Landscape Renovation Expansion New construction Landscape Renovation Renovation Landscape Expansion New construction Renovation Landscape Renovation Renovation Renovation Renovation Renovation Expansion New construction Renovation Landscape New construction New construction Upgrade Landscape Upgrade New construction Expansion Landscape New construction Upgrade Landscape Campus La Croix Hempstead Hempstead Hempstead Newburgh Hempstead Newburgh Newburgh Newburgh Newburgh Hempstead La Croix Hempstead Hempstead Hempstead Newburgh La Croix Hempstead Hempstead La Croix Hempstead La Croix Hempstead Newburgh Hempstead Hempstead Hempstead Hempstead Newburgh Hempstead Hempstead Hempstead La Croix Green Feature Materials Materials Materials Stormwater Green roof Stormwater Green roof Stormwater Stormwater Materials Green roof Stormwater Materials Solar panels Materials Stormwater Solar panels Materials Materials Solar panels Materials Materials Materials Materials Solar panels laranels Materials Green roof Materials Solar panels Materials Materials Solar panels Stormwater Completed 2016 2016 2017 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2019 2019 2019 2019 2019 2019 2020 2020 2020 2020 2020 2021 2021 2021 2021 2016 2017 2017 2018 2018 Budget $213,475 $59,320 $82,500 $62,750 $689,430 $42,500 $55,750 $195,640 $48,700 $109,800 $847,400 $78,775 $78,300 $32,500 $195,600 $78,500 $52,500 $153,200 $210,750 $285,430 $225,000 $76,500 $750,325 $575,200 $124,865 $83,450 $179,400 $989,500 $124,500 $76,500 $83,750 $34,600 $37,450 Final Cost $225,631 $60,600 $89,754 $60,935 $700,225 $42,850 $56,127 $200,326 $48,850 $110,456 $889,325 $79,349 $78,550 $32,500 $199,800 $82,500 $52,500 $155,600 $220,158 $285,329 $234,657 $79,225 $752,855 $590,568 $154,382 $84,072 $180,055 $990,455 $126,507 $78,024 $83,750 $34,600 $38,090 Campus Newburgh Total Cost  Campus Hempstead Average Cost  38 39 Documentation Capital Projects Cost by Green Feature Cost by Campus Project Budgets Project Types by Year   Ready   100  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  Yes No   23 Recover Unsaved Workbooks  We were able to save changes to one or more files  Do you want to recover them  x fx M N O P Q R S T 1964   Hempstead University Foundation N umber Total Cost Average Cost Project Type Expansion Landscape New Construction Renovation Upgrade Final Cost  100000 Number of Projects  Completed 2019 Number of Projects  2 ID Project Name 3 EX 4096 Didrikson Gymnasium 4 LA 5066 Wales Lake 5 RE 1751 Ardmore House 6 EX 4188 Transit Center 7 NE 3027 Bixbury Apartments 8 LA 5104 Hempsted Field 9 RE 1854 Sullivan Library 10 RE 1890 Richardson Hall 11 LA 5218 Freestone Plaza 12 EX 4209 Boyle Residences 13 NE 3153 Ambani International Center 14 RE 1904 Clarkson Laboratory 15 LA 5276 Alumni Center 16 RE 1922 Founders House 17 RE 1957 Nakamura Physics 18 RE 1961 Grounds and Building 19 RE 1977 Thorne Family Pavilion 20 RE 1982 121 Forest Street 21 EX 4242 Kao Performance Center 22 NE 3209 Whitman Child Care 23 RE 1953 Riverfront Graduate Housing 24 LA 5303 Student Commons 25 NE 3301 Politzer Center 26 NE 3387 Sills Cultural Center 27 UP 2004 Campus Electrical 28 LA 5355 Arts Quad 29 UP 2033 Computing Research 30 NE 3412 Benton Hall of Business 31 EX 4103 Santiago Field 32 LA 5113 Heinrich Mall 33 NE 3045 Charles Street Entrance 34 UP 2011 Mansfield Observatory 35 LA 5197 visitor's Center Project Type Expansion Landscape Renovation Expansion New construction Landscape Renovation Renovation Landscape Expansion New construction Renovation Landscape Renovation Renovation Renovation Renovation Renovation Expansion New construction Renovation Landscape New construction New construction Upgrade Landscape Upgrade New construction Expansion Landscape New construction Upgrade Landscape Campus La Croix Hempstead Hempstead Hempstead Newburgh Hempstead Newburgh Newburgh Newburgh Newburgh Hempstead La Croix Hempstead Hempstead Hempstead Newburgh La Croix Hempstead Hempstead La Croix Hempstead La Croix Hempstead Newburgh Hempstead Hempstead Hempstead Hempstead Newburgh Hempstead Hempstead Hempstead La Croix Green Feature Materials Materials Materials Stormwater Green roof Stormwater Green roof Stormwater Stormwater Materials Green roof Stormwater Materials Solar panels Materials Stormwater Solar panels Materials Materials Solar panels Materials Materials Materials Materials Solar panels laranels Materials Green roof Materials Solar panels Materials Materials Solar panels Stormwater Completed 2016 2016 2017 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2019 2019 2019 2019 2019 2019 2020 2020 2020 2020 2020 2021 2021 2021 2021 2016 2017 2017 2018 2018 Budget $213,475 $59,320 $82,500 $62,750 $689,430 $42,500 $55,750 $195,640 $48,700 $109,800 $847,400 $78,775 $78,300 $32,500 $195,600 $78,500 $52,500 $153,200 $210,750 $285,430 $225,000 $76,500 $750,325 $575,200 $124,865 $83,450 $179,400 $989,500 $124,500 $76,500 $83,750 $34,600 $37,450 Final Cost $225,631 $60,600 $89,754 $60,935 $700,225 $42,850 $56,127 $200,326 $48,850 $110,456 $889,325 $79,349 $78,550 $32,500 $199,800 $82,500 $52,500 $155,600 $220,158 $285,329 $234,657 $79,225 $752,855 $590,568 $154,382 $84,072 $180,055 $990,455 $126,507 $78,024 $83,750 $34,600 $38,090 Campus Newburgh Total Cost  Campus Hempstead Average Cost  38 39 Documentation Capital Projects Cost by Green Feature Cost by Campus Project Budgets Project Types by Year   Ready   100

Accepted Answer

The Answer is in the image, click to view ...

Question

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,

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Liquidated An Ethnography Of Wall Street

Students also viewed these Finance questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question