Homework answers / question archive / 1)The city of Honu Point wants to fast-track mixed-use development projects that use loans for funding

1)The city of Honu Point wants to fast-track mixed-use development projects that use loans for funding

Computer Science

Share With

1)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:
a.       In cell G1, type Fast Track as the column heading.
b.       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.