Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The city of Honu Point wants to fast-track mixed-use development projects that use loans for funding. Add a column to the ProposedProjects table, and determine
- The city of Honu Point wants to fast-track mixed-use development projects that use loans for funding. Add a column to the ProposedProjects table, and determine which projects meet the criteria as follows:
- In cell G1, type Fast Track as the column heading.
- In cell G2, enter a formula using the AND function that includes structured references to display TRUE if a project has a [Project Type] of "Mixed Use" and a [Funding Type] of "Loan". Fill the range G3:G13 with the formula in cell G2 if Excel does not do so automatically.
Project Name | Start Date | Number of Days | Project Type | Funding Type | Funding | Fast Track |
Old Town Design Plan | 1/10/2022 | 24 | Public | Grant | $ 1,500 | |
Honu Point Sports Complex | 1/13/2022 | 340 | Commercial | Loan | $ 24,000 | |
Mahina Regional Park | 2/22/2022 | 148 | Public | Grant | $ 12,500 | |
Downtown Bike Path | 2/22/2022 | 360 | Public | Grant | $ 15,000 | |
Burton Estates Expansion | 3/3/2022 | 90 | Mixed Use | Tax Credit | $ 4,500 | |
Highacre Farms Modification | 3/13/2022 | 90 | Residential | Loan | $ 10,000 | |
Makana Road Multifamily | 3/19/2022 | 180 | Residential | Tax Credit | $ 15,000 | |
Honu Point Center | 3/20/2022 | 120 | Mixed Use | Grant | $ 4,000 | |
Sunset Heights Zoning | 3/20/2022 | 21 | Mixed Use | Loan | $ 2,500 | |
Manu Hill Drive Parking | 4/9/2022 | 125 | Commercial | Tax Credit | $ 9,500 | |
Allied Insurance | 4/9/2022 | 60 | Commercial | Tax Credit | $ 6,000 | |
Nalu Parks Village | 4/18/2022 | 420 | Mixed Use | Loan | $ 50,000 | |
Total | $ 154,500 | 0 |
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